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

Copper 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. 

3 Replies

@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

 

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.

 

Thanks

Qaiser_j_0-1631629857946.png