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 Straight From Data Source

 

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

Insert a Pivot Chart Straight From Data Source

 

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

Axis: Region and Year

Values: Sales

Insert a Pivot Chart Straight From Data Source

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

Insert a Pivot Chart Straight From Data Source

 

How to Insert a Pivot Chart Straight From Data Source

 

Helpful Resource:

Excel Pivot Table

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

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