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

Question

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.

fredoz · Answer

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

qaiser_j · Answer

Hi FredOz&nbsp;&nbsp;Following chart created easily by using No Code Data Visualization add-in.&nbsp;&nbsp;You can check here for&nbsp;https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr.&nbsp;And if you are comfortable with Google Sheets, you can find&nbsp;https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr.&nbsp;Thanks&nbsp;

sergeibaklan · Answer

FredOz&nbsp;
Workarounds are here
Stop Excel From Overlapping the Columns When Moving a Data Series to the Second Axis - Excel Dashboard Templates
Excel Column Chart with Primary and Secondary Axes - Peltier Tech Blog

Forum Discussion

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

3 Replies

Resources