[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1169
  • Last Modified:

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
0
Stayer
Asked:
Stayer
  • 2
1 Solution
 
bromy2004Commented:
Right Click on the DAYS Line
Click Format Data Series
Click "Plot Series On" Secondary Axis
0
 
bromy2004Commented:
@ pratima_mcs
Precisely what I said
0
 
StayerAuthor Commented:
Excellent.

Works perfectly.

Best regards,

Stayer
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now