Stayer
asked on
Excel chart with two Y - axis (vertical)
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,
Stayer
Example-screenshot.jpg
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,
Stayer
Example-screenshot.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@ pratima_mcs
Precisely what I said
Precisely what I said
ASKER
Excellent.
Works perfectly.
Best regards,
Stayer
Works perfectly.
Best regards,
Stayer
http://www.lytebyte.com/2009/02/24/how-to-create-excel-chart-with-2-y-axis-or-x-axis/