How to add 2nd vertical axis on bar graph in Excel?

New Contributor


In the autoscaled plot above the blue bars are too small to see trends easily.  How can I add a 2nd scale on the right for the blue bars?  Excel Help shows how to make an XY scatter plot with bar chart but that's now what I want. 

1 Reply


I found a partial (kludgie) solution 'tho I have a newer version of Excel than 2010.  I cannot get the bars separate.