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.