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

%3CLINGO-SUB%20id%3D%22lingo-sub-2530378%22%20slang%3D%22en-US%22%3EHow%20to%20add%202nd%20vertical%20axis%20on%20bar%20graph%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2530378%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22FredOz_0-1625783223243.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294513i7D44A0A0BEC8483E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22FredOz_0-1625783223243.png%22%20alt%3D%22FredOz_0-1625783223243.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIn%20the%20autoscaled%20plot%20above%20the%20blue%20bars%20are%20too%20small%20to%20see%20trends%20easily.%26nbsp%3B%20How%20can%20I%20add%20a%202nd%20scale%20on%20the%20right%20for%20the%20blue%20bars%3F%26nbsp%3B%20Excel%20Help%20shows%20how%20to%20make%20an%20XY%20scatter%20plot%20with%20bar%20chart%20but%20that's%20now%20what%20I%20want.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2541041%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20add%202nd%20vertical%20axis%20on%20bar%20graph%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2541041%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1099087%22%20target%3D%22_blank%22%3E%40FredOz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20found%20a%20partial%20(kludgie)%20solution%20'tho%20I%20have%20a%20newer%20version%20of%20Excel%20than%202010.%26nbsp%3B%20I%20cannot%20get%20the%20bars%20separate.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftrumpexcel.com%2Fadd-secondary-axis-charts%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftrumpexcel.com%2Fadd-secondary-axis-charts%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22FredOz_0-1626145864106.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F295310i9EE47D596D95BE73%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22FredOz_0-1626145864106.png%22%20alt%3D%22FredOz_0-1626145864106.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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. 

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