Excel Combo Chart: How to Add a Secondary Axis

This tutorial explains how to create an Excel combo chart (aka dual axis chart) with a secondary vertical axis to visualize two different types of data on the same chart.

____________________________________________

Learning how to build an Excel combo chart (or dual axis chart) is a powerful skill that can help you simplify complex stories around data.

The benefit of a combo chart, compared with a regular chart, is that we can visualize two different data sets on the same chart - for instance - financial ($ denominated) data as well as website conversion rates (% denominated), by adding a secondary vertical axis.

The prerequisite to building an Excel combo chart is that you need to have the right data to visualize. You will have a different type of data on each vertical axis (one on the left and one on the right) but these two types of data will share the horizontal axis.

What this means is that the two types of data need to share the something in common - usually that they happen during the same time (on the horizontal axis) - in order to build an Excel combo chart.

As long as you have the right data, you can add a secondary axis (vertically) and visualize your two data sets one one chart!

By the end of this video you will feel confident creating & adapting dual axis charts and visualizing different types of data. If you have a question - leave me a question in the comments and I'll get back to you!

#excelcombochart #dualaxischart #secondaryaxisexcel

[lankylankster]

THANK YOU, Eric! It helped that you taught how to reposition the horizontal labels to a lower position so they're distinguished from the more visual parts of the graph (vertical bars and horizontal % line). LL

[MrRajnishdwivedi]

Thank you very very much for such clear and concise explanation 👍!!!!

[HeadBeeGuy]

Super helpful! Thank you for this video.

[joelong]

I'm trying to put together a line graph comparing five different teams performance on one of our priority metrics. I have a graph depicting their daily performance throughout the month. I would like to add their current average displayed as a dot on the far right side of the chart with the color corresponding with that of their line.

I have not found a video with this information so I was wondering if you have a video you could direct me to or any ideas as to how to accomplish this something of a similar effect.

[funny__bean]

thank you very much for mentioning the axis title part!!! 💓💓💓💓💓💓💓💓

[babatundekozeem]

Thanks for the insightful video. I will like to ask if it it possible to have one of say five series to be on the secondary axis (line graph) while the remaining four series remain in a starked column not clustered as you have brilliantly shown in this video. Thanks

[vladimirmoravek]

nice video, is it somehow possible to overlay both X axis? I mean, that when I set up overlay 100% I will still be able to see orange over the blue vertical line.

[suzy]

Thanks very much... very useful...
🙏🙏🙏

[docdaven]

how did you get Sales and Net Profit to show side-by-side? No matter what I do, the bars overlap. All I want is 2-axes both sets with separate bars (no lines) and then, ideally, somehow show it in 3D (though it looks like 2 axes aren't supported in Excel 2013)

[celltrey]

hey how do you get to all charts in the new excel

[thmagd]

Hello Eric, your videos really helps, thanks for uploading. Could you please do the video of how to do an animation with powerpivot, I couldn't find any videos on the internet.

[amiramedhat]

For some weird reason, the dates don't show up at the bottom of my chart which messes up the chart and i don't know how to fix that..

[robertkostka]

I was looking for scaling... thank you!

[heatherwilson]

Hey Eric, I have a graph with historical data and projected data. I currently have this as a scatter plot with two sets of data. My boss would like the historical data to be columns, but when I convert the historical data to columns, the historical and projected data overlaps. Anyway to have column and scatter on two separate sets of x values?

[midoterminator]

please i have urgent question in charts that stops my work could you help me please

[videovoice]

thanks for teaching me how to put the label low!!!

[nomunacc]

there is no combo chart type in my chart6. What can i do?

[querlt]

Hi Eric! Great video! Question: Instead of manually setting a value in "Minimum Bounds" under Axis Options (referring to timestamp 6:43), is there a way to make it automatically adjust properly? Because I find that this method works only if my the data in the combo chart doesn't change.

[antoniobacic]

This helps, thanks a lot.
PS Pleasant to listen to.

[jsrockin]

What if I want conversion rate axis on left and money on left side