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. 

3 Replies


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




Hi @FredOz 


Following chart created easily by using No Code Data Visualization add-in. 


You can check here for Microsoft Excel & Office 365.


And if you are comfortable with Google Sheets, you can find here.