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

New Contributor

FredOz_0-1625783223243.png

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

@FredOz 

I found a partial (kludgie) solution 'tho I have a newer version of Excel than 2010.  I cannot get the bars separate.
https://trumpexcel.com/add-secondary-axis-charts/

 

FredOz_0-1626145864106.png