Excel chart with two Y - axis (vertical)

Posted on 2010-01-07
Last Modified: 2012-05-08
Hi Experts,

I have an excel chart which I need to modify. As you can see in the screenshot, the vertical axis to the left correctly displays reported revenues (blue line). However, I need an vertical axis on the right side displaying number of days which is from 0 - 40. As you can see the vertical axes only shows values in thousands while I need the axe to the right to go from 0 - 50 and only be related to the red line.

Can anyone help me out with this?

All help is highly appreciated.

Best regards,


Question by:Stayer
    LVL 10

    Accepted Solution

    Right Click on the DAYS Line
    Click Format Data Series
    Click "Plot Series On" Secondary Axis
    LVL 39

    Expert Comment

    by:Pratima Pharande
    LVL 10

    Expert Comment

    @ pratima_mcs
    Precisely what I said

    Author Closing Comment


    Works perfectly.

    Best regards,


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now