当前位置：网站首页>100 lectures on practical application cases of Excel (VIII) - report connection function of Excel

100 lectures on practical application cases of Excel (VIII) - report connection function of Excel

2022-04-23 13:02:00 【Gatulo book】

1. Prepare the data

Prepare the following experimental data .

picture

2. Insert PivotChart

（1） Insert a PivotChart of month and investment amount , Graph selection bar chart .

picture

（2） Insert a PivotChart of type and investment amount , Graph selection pie chart .

picture

3. Insert slice

（1） PivotChart of bar chart , Insert year 、 month 、 Type three field slices .

picture

（1） Pie chart PivotChart , Insert year 、 month 、 Type three field slices .

picture

4. Report connection

take year 、 month 、 The three field slices of type are connected to the report respectively .

picture

版权声明
本文为[Gatulo book]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230612572041.html

边栏推荐

猜你喜欢

随机推荐