Secondary Vertical Axis

[aadhyaa]

Hi all !

I was trying to insert a secondary vertical axis in my graph but unfortunately I'm not able to proceed after step 3 for Excel.
https://support.office.com/en-us/ar...-a-chart-025f91b8-d70a-4d4c-b645-1431ec1c8c97

Please tell me how to go about it. i cant see the Axis option, let alone secondary axis.

 

[NARAYANK991]

Hi ,

I think a secondary axis is available only when you have more than one data series.

If you do have two or more data series in your chart , as mentioned in the link that you have posted , click on the series which you wish to plot on the secondary axis ; all the points will be selected.

If you have Excel 2010 , you can see a section of the Ribbon labelled as Chart Tools. One of the options in this section is Format. Clicking on this should display the name of the selected series in the top left hand corner , and below that you should see a menu option labelled Format Selection. Clicking on this should display the option buttons which allow you to select either the Primary or Secondary Axis.

 

[aadhyaa]

Thank you so much ! Didn't notice, it was right there in front of me :P Thanks !