课程: Learning Excel Online (Microsoft 365)

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Create engaging PivotCharts

Create engaging PivotCharts

课程: Learning Excel Online (Microsoft 365)

开始一个月试用 购买团队方案

Create engaging PivotCharts

“

- [Instructor] PivotCharts are a super fun and engaging way of getting the most from your PivotTable data. Have the XL PivotChart exercise file open to follow along with me. What you're looking at is a basic PivotTable of company expenditure data summarized by general ledger code. The data in this PivotTable comes from the information in the Pivot worksheet. Now, whilst this PivotTable looks rather neat, I think it would look far more engaging if it was to be presented graphically. After all, a picture speaks 1,000 words. Let's create a PivotChart. Go ahead and click anywhere in the PivotTable. It doesn't matter where. And from the insert menu here, select one of the charting options. I'm just going to select a 2D pie chart. In a split second, a 2D pie chart has been created using the PivotTable data. With the chart being linked to the underlying PivotTable, this means that any changes we make to the PivotTable will…

内容