Pivot Charts in Excel are an extension of a Pivot Table and they show its values in a graphical representation.  So when you filter a Pivot Table, the Pivot Chart updates accordingly.

To insert a Pivot Chart you need to click in your Pivot Table, go to the PivotTable Tools tab in the Ribbon and choose Pivot Chart.  Below I show you how easy this can be achieved and in a few clicks you can turn dull information in to colorful insight!

Pivot Charts | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

Here is our Pivot Table:

Pivot Charts | MyExcelOnline

STEP 1: Click on your Pivot Table and go to Options > PivotChart

Pivot Charts | MyExcelOnline

 

STEP 2: Select a Chart type and click OK.

Pivot Charts | MyExcelOnline

You now have your cool Pivot Chart!

Pivot Charts | MyExcelOnline

 

Helpful Resource:

728x90

 

HELPFUL RESOURCES:

Get access to 30+ Microsoft Excel & Office courses for ONLY $1.


Click here to get this limited-time $1 offer!



 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn