From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using PivotCharts

Using PivotCharts

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using PivotCharts

- You may be familiar with how to create charts to illuminate data. Could be financial data, personnel data, anything, and with PivotTables, we also have the ability to create charts. They're called PivotCharts. They're a little bit different, but pretty much the same general idea. Now I might not have a PivotTable available for this data at all, so I'm going to create one, but notice that on the Insert tab and not near PivotTable off to the left, but way over here under Charts, we've got an option called PivotChart. Use PivotChart to graphically summarize data and explore complicated data. Let's create a PivotChart. Now we will get a PivotTable at the same time. Now we could put this on the same worksheet, I've got data off to the right there, or we'll just put it on a new worksheet. How about a new worksheet? We'll simply click OK. Now what's a little bit different here is that the PivotChart Fields list, first of all, does not say PivotTable Fields List. Instead of seeing row and…

Contents