学越千山：WPS数据透视图做动态图表（二二）01:36来自LearningYard学苑
分享兴趣，传播快乐，增长见闻，留下美好！
亲爱的您，这里是LearningYard新学苑。
今天小编为大家带来
“学越千山：WPS数据透视图做动态图表（二二）”，
欢迎您的访问。
Share interest, spread happiness, increase knowledge, and leave beautiful.
Dear, this is the LearingYard Academy!
Today, the editor brings the
Learning over a thousand mountains:WPS pivot chart making dynamic charts (22)，
Welcome to visit!
思维导图
Mind mapping
设置数据透视表
Set up a pivot table
选中数据后，点击菜单栏“数据”中的“数据透视表”，在新的工作表中生成透视表。
After selecting the data, click on "pivot table" in the menu bar "Data" to generate a pivot table in the new worksheet.
设置图表
Set up charts
将各字段拖入对应的区域，如下图：
Drag each field into the corresponding area, as shown in the following figure:
此时应出现下图这样的图表，如果没有，可能是版本问题，需通过选中单元格中所有求和项区域，点击“插入”图表，来手动设置。
At this point, a chart like the one shown in the figure should appear. If not, it may be a version issue. You need to manually set it by selecting all the sum item areas in the cells and clicking "Insert" chart.
在“分析”中插入切片器，勾选筛选字段。就可通过切片器上的不同筛选信息自动变化图表了。
Insert a slicer in "Analysis" and check the filtering field. You can automatically change the chart by filtering different information on the slicer.
美化图表
Beautify charts
通过“图表工具”可以添加元素、快速布局、更改图表样式。
You can add elements, quickly layout, and change chart styles through the Chart Tools.
可以在右侧数据分析表的操作卡中选中字段，右键单击，进行值字段设置，包括字段重命名及数据处理方式。
You can select fields in the operation card of the data analysis table on the right, right-click, and set value fields, including field renaming and data processing methods.
这里的自定义名称不能与“源名称”相同，即不能仅删除“求和项：”这一段字符。
The custom name here cannot be the same as the "source name", that is, it cannot only remove the character "sum term:".
今天的分享就到这里了，
如果您对文章有独特的想法，
欢迎给我们留言。
让我们相约明天，
祝您今天过得开心快乐！
That's all for today's sharing.
If you have a unique idea about the article,
please leave us a message,
and let us meet tomorrow.
I wish you a nice day!
翻译：百度翻译
参考资料：百度、WPS office技巧
本文由LearningYard新学苑整理并发出，如有侵权请后台留言沟通