You have tried out Pivot Charts and have created one from an existing Pivot Table. Did you know that you can insert a pivot chart straight from the data source?

See how you can do this in just a couple of steps.

Insert a Pivot Chart Straight From Data Source | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Select your data source. Go to Insert > Charts > PivotChart > PivotChart

Insert a Pivot Chart

 

STEP 2: Select Existing Worksheet and pick a spot to place your Pivot Chart on. Click OK.

Insert a Pivot Chart

 

STEP 3: Let us quickly setup our Pivot Chart. Set the following:

Axis: Region and Year

Values: Sales

Insert a Pivot Chart

You now have your Pivot Chart straight from the data source!

Insert a Pivot Chart

 

How to Insert a Pivot Chart Straight From Data Source

 

Helpful Resource:

Excel Pivot Table

 

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

Insert a Pivot Chart Straight From Data Source | MyExcelOnline