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:
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
Then navigate to the Design Ribbon and click on the Change Chart Type button:
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.
You will then have the Combo Pivot Chart you desire:
Video Tutorial
Sample Excel Chart File
Combo-Line-and-Column-Excel-Pivot-Chart-Sample1.xlsx
Steve=True
Thanks for video. And I would like to ask the way to move secondary axis of each point sit in
primary column end position, not in the middle. I tried many ways but not succeed.
The video show only secondary each point at the middle of column point.
Hi Myo Ko Ko, I believe I understand what you mean. Sorry, you cannot do that with a line chart. Line Charts only plot to the middle of the category. Perhaps you can do it with a XY chart. I will have to try it 🙂 Steve=True
Hi
Can the same be achieved using excel 2010 as I do not have the option of combined chart type.
Is it possible to combine the Bar graph and Line graph when the Bar Chart is on a different spreadsheet (for example: measuring Import Profits) and a Line graph on another separate spreadsheet (For Example: Measuring Export Sales)?
Hi Celeste, since it is a pivot chart, your data has to be in the pivot table. So I would assume if you can get your data into the pivot table and thus the pivot chart then you would be able to do this. Steve=True