Excel Combo Chart: How to Add a Secondary Axis

About this tutorial:

Video duration: 00:10:08
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.

My Courses:
► Become an Excel Power User in 2.5 Hours (81% discount):
► Master Excel Keyboard Shortcuts (85% discount):

Related Excel Videos:
► Sensitivity Analysis in Excel:
► Build a Basic Financial Model:
► Top 27 Keyboard Shortcuts in…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

16 thoughts on “Excel Combo Chart: How to Add a Secondary Axis

    Eric Andrews

    (June 29, 2020 - 9:42 pm)

    Take a look at my brand new video on calculating venture capital's #1 most important metric – LTV ► https://youtu.be/eHi875QuVcA

    Ghazala Hashmi

    (June 29, 2020 - 9:42 pm)

    I don't understand

    Ralph Que

    (June 29, 2020 - 9:42 pm)

    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.

    Tokyo Beat Records

    (June 29, 2020 - 9:42 pm)

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

    Youssra El

    (June 29, 2020 - 9:42 pm)

    Thank you so much

    patrick cordero

    (June 29, 2020 - 9:42 pm)

    my 2010 excel doesn't have this deature? what is your version?


    (June 29, 2020 - 9:42 pm)

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

    Barbara Millet

    (June 29, 2020 - 9:42 pm)

    Thank you, Thank you, Thank you!

    Mohamed Elshreif

    (June 29, 2020 - 9:42 pm)

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

    suzy Foo

    (June 29, 2020 - 9:42 pm)

    Thanks very much… very useful…

    John Curtis

    (June 29, 2020 - 9:42 pm)

    You are an excellent teacher. Thank you for doing this two-axis video. It was very helpful.

    edwin kagga

    (June 29, 2020 - 9:42 pm)

    Thank you, for helping.

    Babatunde Kozeem

    (June 29, 2020 - 9:42 pm)

    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

    Magda Dvalishvili

    (June 29, 2020 - 9:42 pm)

    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.

    Heather Wilson

    (June 29, 2020 - 9:42 pm)

    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?

    Curso de Excel Online

    (June 29, 2020 - 9:42 pm)

    Very good Eric

Leave a Reply

Your email address will not be published. Required fields are marked *