Pinterest Pixel

Pivot Charts

Pivot Charts in Excel are an extension of a Pivot Table and they show its values in... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Pivot Charts | MyExcelOnline Pivot Charts | MyExcelOnline

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 workbookInsert-a-Pivot-Chart.xlsx

Here is our Pivot Table:

Pivot Charts

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

Pivot Charts

 

STEP 2: Select a Chart type and click OK.

Pivot Charts

You now have your cool Pivot Chart!

Pivot Charts

 

Helpful Resource:

728x90

 

If you like this Excel tip, please share it
Pivot Charts | MyExcelOnline Pivot Charts | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...