Pinterest Pixel

Insert a Pivot Chart Straight From Data Source

You have tried out Pivot Charts and have created one from an existing Pivot Table. Did you... read more

Download Excel Workbook
Bryan
Posted on

Overview

Insert a Pivot Chart Straight From Data Source | MyExcelOnline Insert a Pivot Chart Straight From Data Source | MyExcelOnline

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 workbookInsert-a-Pivot-Chart-Straight-from-Data-Source.xlsx

 

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

 

If you like this Excel tip, please share it
Insert a Pivot Chart Straight From Data Source | MyExcelOnline Insert a Pivot Chart Straight From Data Source | MyExcelOnline
Insert a Pivot Chart Straight From Data Source | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Group Sales with a Pivot Table

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...