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!

DOWNLOAD EXCEL WORKBOOK

Here is our Pivot Table:

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

 

STEP 2: Select a Chart type and click OK.

You now have your cool Pivot Chart!

Insert a Pivot Chart

Helpful Resource:

728x90

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Connect Slicers to Multiple Excel Pivot Tables Pivot Table Slicers were first introduced in Excel 2010 for Windows and Excel 2016 for Mac. They are a visual filter in the form of an interactive button.  There are several cool things that you can do with Slicers, like customize them, filter them and connect them to mult...
Conditional Format a Cell´s Value A great way to highlight values within your data set, Excel Table or Pivot Table is to use Conditional Formatting rules. Formatting cells that contain a specific criteria, for example, greater than X or less than X, is a good way to visualize your results. When your criteri...
Show The Difference From Previous Years With Excel... Excel Pivot Tables have heaps of calculations under the SHOW VALUES AS option and one that gets the most use is the DIFFERENCE FROM calculation. You can show the values as the Difference From previous months, years, day etc.  This is just great when your boss asks you how you ...
Pivot Table Filter: Top 5 Customers You can easily Filter your Pivot Table to show your Top X customers.  There are lots of different Value Filters to choose from and one of my favorites is the Top 10 Filter. DOWNLOAD EXCEL WORKBOOK Here is our pivot table:   STEP 1: Go to Row Labels > Val...