來自單一提示詞的真實 Excel 圖表

01 · 一位銀行分析師，一份 8 頁的 PDF

將五個 PDF 表格放入 Excel 並繪製了細分圖表

1. 閱讀第 2 頁至第 5 頁的表格，完全不需要手動輸入

   一個包含一個「Results」工作表與每個表格一個資料區塊的新活頁簿。每個數字皆以數值儲存，諸如 (24) 的括號會變成 -24，且年增率（YoY）欄位在每一列都有公式。綠色數字為公式；點擊任一個即可檢視。

   JPM 2Q26 results.xlsx新檔案

   E8fx=(B8/D8)-1

   	A	B	C	D	E
   1	JPMorgan Chase 2Q26 Results ($ in millions)
   2	FIRM
   3		2Q26	1Q26	2Q25	YoY %
   4	Net revenue - reported	57,347	49,836	44,912	27.7%
   5	Net revenue - managed	58,022	50,536	45,680	27.0%
   6	Noninterest expense	27,316	26,850	23,779	14.9%
   7	Provision for credit losses	2,515	2,507	2,849	-11.7%
   8	Net income	21,155	16,494	14,987	41.2%
   9	CCB — Consumer & Community Banking
   10		2Q26	1Q26	2Q25	YoY %
   11	Net revenue	20,272	19,568	18,847	7.6%
   12	Noninterest expense	11,108	10,979	9,858	12.7%
   13	Provision for credit losses	2,156	2,050	2,082	3.6%
   14	Net income	5,311	4,976	5,169	2.7%
   15	CIB — Commercial & Investment Bank
   16		2Q26	1Q26	2Q25	YoY %
   17	Net revenue	24,853	23,379	19,535	27.2%
   18	Noninterest expense	11,390	11,136	9,641	18.1%
   19	Provision for credit losses	356	482	696	-48.9%
   20	Net income	9,678	9,044	6,650	45.5%
   21	AWM — Asset & Wealth Management
   22		2Q26	1Q26	2Q25	YoY %
   23	Net revenue	6,851	6,374	5,760	18.9%
   24	Noninterest expense	4,207	4,167	3,733	12.7%
   25	Provision for credit losses	13	-24	46	-71.7%
   26	Net income	1,957	1,775	1,473	32.9%
   27	CORPORATE
   28		2Q26	1Q26	2Q25	YoY %
   29	Net revenue	6,046	1,215	1,538	293.1%
   30	Noninterest expense	611	568	547	11.7%
   31	Provision for credit losses	-10	-1	25	-140.0%
   32	Net income	4,209	699	1,695	148.3%
   33
   34	Segment	2Q26	2Q25
   35	CCB	20,272	18,847
   36	CIB	24,853	19,535
   37	AWM	6,851	5,760
   38	Corporate	6,046	1,538

   Results新

2. 繪製了連結至表格的群組直條圖

   2Q26 對比 2Q25 四項業務的淨收益。圖表的資料區塊會對應回帶有公式的表格，因此若數字變動，圖表也會隨之更新。所有 63 個數字皆已與發布內容進行核對。

   JPM 2Q26 results.xlsxResults 工作表

   Net revenue: 2Q26 vs 2Q25 ($m)

   • 2Q26
   • 2Q25

02 · 一位數學教練，一份 7 個工作的分頁活頁簿

新增了一個趨勢工作表和一個折線圖，隨後應要求新增了第二條折線

1. 找到七個第 01 區的列，並將其繪製在新工作表上

   一個包含小型表格的「D01 Trend」工作表，依年份舊到新排列，旁邊附有原生折線圖。2020 年與 2021 年因無資料而未繪製資料點。這七個原始工作表與上傳內容完全相同，逐格一致。

   district-math-results-public.xlsxD01 Trend 工作表

   District 01 Math % Level 3+4

   • % Level 3+4

2. 第二則訊息：英語學習者折線已加入同一個圖表中

   教練

   Now add English Language Learners to the same chart. 1. From the sheet 'Math - ELL', take the rows where District = 01, Grade = All Grades and Category = Current ELL, and add their % Level 3+4 as a new column 'Current ELL % Level 3+4' in the 'D01 Trend' table (same years). 2. Add it as a second line on the existing chart, with a legend showing 'District 01 (all students)' and 'Current ELL'. 3. Put a cell comment on the 2023 row of the table explaining that the drop/jump there is because the 2023 tests were aligned to new standards, so earlier years aren't directly comparable. Keep the first series as it is.

   「目前的 ELL」(Current ELL) 欄位已新增至表格中，並作為現有圖表上的第二個數列；第一條線保持不變，2023 年的資料列則帶有註解。圖例保留了欄位標題，而不是所要求的名稱，且回覆中已說明此事。

   district-math-results-public.xlsxD01 Trend 工作表

   District 01 Math % Level 3+4

   • % Level 3+4
   • Current ELL % Level 3+4

03 · 一位審計員，3,161 筆付款

建立了包含公式的摘要工作表以及按區域劃分的支出條形圖

這是對話中的第二條訊息：第一個請求要求相同的摘要，而 把它寫入了另一個 CSV 中。一句話把它放回了正確的位置。

1. 新增 Summary 工作表，列出 11 個類別，由大到小排列

   每個總計都是對資料工作表進行的 SUMIF 運算，下方則有總計，接著是依支出金額排序的前十大供應商及其 COUNTIF 交易次數。綠色數字代表公式。

   Telford_Wrekin_transparency_report_December_2025.xlsx新工作表

   A1fxTelford & Wrekin Council — December 2025 spend: Summary

   	A	B	C	D
   1	Telford & Wrekin Council — December 2025 spend: Summary
   2	Covering 3161 transactions, 1-31 December 2025
   3
   4	Total spend by Service Delivery Area (largest first)
   5	Area	Total spend
   6	Prosperity & Investment	5,744,335.15
   7	Neighbourhood & Enforcement Services	4,948,876.56
   8	Education & Skills	4,609,122.15
   9	Corporate Items	1,734,016.14
   10	Housing, Commercial & Customer Services	1,254,821.61
   11	Health & Wellbeing	971,198.15
   12	Finance, People & IDT	263,360.71
   13	Children's Safeguarding & Family Support	258,890.99
   14	Adult Social Care	208,305.53
   15	Policy & Governance	40,802.28
   16	Corporate Communications	975.00
   17	Grand total	20,034,704.27
   18
   19	Top 10 suppliers by total spend
   20	Rank	Supplier	Total spend	Transactions
   21	1	Bowmer & Kirkland Ltd	1,884,772.10	2
   22	2	PAVE-AWAYS LTD	1,661,965.98	9
   23	3	Veolia ES T&W Ltd	1,482,145.55	1
   24	4	PYRAMID SCHOOLS (HADLEY) LTD	1,462,179.11	5
   25	5	Balfour Beatty Civils Limited	1,376,066.91	1
   26	6	Id verde	1,067,695.39	6
   27	7	SHROPSHIRE COMMUNITY HEALTH NHS TRUST	838,577.00	3
   28	8	WORCESTERSHIRE COUNTY COUNCIL	756,693.52	1
   29	9	Hawk Incentives Ltd (Crown Commercial Services)	631,235.42	6
   30	10	SHROPSHIRE COUNCIL	538,607.76	3

   Transparency ReportSummary新

2. 繪製了會隨公式變動的長條圖

   圖表會讀取「摘要」(Summary) 表格，因此當付款金額變更時，圖表也會隨之改變。共十一個區域，如要求以最大者排序優先。

   Telford_Wrekin_transparency_report_December_2025.xlsxSummary 工作表

   Spend by Service Delivery Area — December 2025

   Prosperity & Investment5,744,335

   Neighbourhood & Enforcement Services4,948,877

   Education & Skills4,609,122

   Corporate Items1,734,016

   Housing, Commercial & Customer Services1,254,822

   Health & Wellbeing971,198

   Finance, People & IDT263,361

   Children's Safeguarding & Family Support258,891

   Adult Social Care208,306

   Policy & Governance40,802

   Corporate Communications975