Pivot Chart

In this lesson you can learn how to use a Pivot Chart.

PivotChart chart is similar to the traditional, but has some additional features useful for the analysis of data.

I have prepared table with sales data:

sales data

Next go to Ribbon. Click Insert -> PivotTable ->PivotChart

insert pivot chart

Dialog box appears. Choose here range of table with headers.

Create PivotTable

Now you can create your own PivotChart.

pivot chart inserting

Choose fields which you want to put on the PivotChart.

pivot field list

Here's how the PivotChart looks.

pivot chart basic

You can click Country or Customer button to filter values.

pivot chart filter

Excel inerted also a Pivot Table in your Spreadsheet.

pivot chart pivot table

You can change Pivot Chart by changing this Pivot Table. Pivot Chart shows the same values which you see in this Pivot Table.

Try to update / filter / change data in Pivot Table and see, how the Pivot Chart changed.

Download free spreadsheet here