来自单一提示词的真实 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