How-to Create a Combo Line and Column Pivot Chart

Some Excel users can be confused when it comes to Pivot Tables and Pivot Charts.  I recently saw a post asking for this help:

“Please advise if it is possible to combine a pivot line graph and a pivot stacked column graph into one graph?”

Maybe you have this problem as well.  Here is how to quickly create a Combo Line Column Chart in Excel

1) Create your Pivot Chart

Click in the Pivot Table and then go to the Insert Ribbon and click on the Column Chart type:

Insert Excel Pivot Chart

Then select the data series that you want to change into a Line Chart Type:

If you can’t select the right data series, try a tip or trick from this post to help:

how-to-select-data-series-in-an-excel-chart-when-they-are-un-selectable

Select Excel Chart Data Series

Then navigate to the Design Ribbon and click on the Change Chart Type button:

Chart Tools Change Chart Type

In Excel 2013, you will be able to change the chart type of each series as well as move the ones you want to the secondary axis.

Combo Line Column Chart

 

You will then have the Combo Pivot Chart you desire:

Combo Line Column Chart 2

 

Video Tutorial

Sample Excel Chart File

Combo-Line-and-Column-Excel-Pivot-Chart-Sample1.xlsx

 

Steve=True