SOLVED

Extra y-axis, to add to line graph (Excel, Mac v16.41)

%3CLINGO-SUB%20id%3D%22lingo-sub-2583132%22%20slang%3D%22en-US%22%3EExtra%20y-axis%2C%20to%20add%20to%20line%20graph%20(Excel%2C%20Mac%20v16.41)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2583132%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20colleague%20or%20helpful%20person%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20made%20graphs%20in%20Excel%20with%209%20mean%20values%20%2B%20SD%20error%20bars.%20To%20these%20I%20wish%20to%20add%20a%20second%20y-axis%20to%20the%20right%2C%20which%20will%20show%20Coefficient%20of%20Variation.%20These%20are%20then%209%20extra%20values%20that%20also%20will%20be%20linked%20with%20line.%20I%20am%20using%20Swedish%20Excel%20version%2C%20but%20that%20should%20not%20matter.%20I%20can%20only%20see%20alternatives%20with%20histogram%20%2B%20lines%2C%20with%20two%20y-axes.%20%26nbsp%3BGrateful%20for%20any%20help.%20(I%20can%20send%20the%20graph%20with%20data.)%26nbsp%3B%3C%2FP%3E%3CP%3EKindly%2C%3C%2FP%3E%3CP%3EFrank%20G%C3%B6tmark%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2583132%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2584135%22%20slang%3D%22en-US%22%3ERe%3A%20Extra%20y-axis%2C%20to%20add%20to%20line%20graph%20(Excel%2C%20Mac%20v16.41)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2584135%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111712%22%20target%3D%22_blank%22%3E%40Frank7879%3C%2FA%3E%26nbsp%3BYes%2C%20please%20send%20the%20graph%20with%20the%20data.%20Tack!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2584928%22%20slang%3D%22en-US%22%3ERe%3A%20Extra%20y-axis%2C%20to%20add%20to%20line%20graph%20(Excel%2C%20Mac%20v16.41)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2584928%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Riny%2C%20thanks%20for%20responding.%20I%20attach%20the%20Excel%20file%2C%20where%20you%20seem%20mean%20values%20(dots)%20connected%20by%20line%2C%20and%20with%20standard%20deviation.%20%26nbsp%3BYou%20can%20also%20see%20CV%20values%20(coefficient%20of%20variation)%2C%20and%20those%20are%20the%20values%20I%20would%20like%20to%20add%20to%20graph%20with%20a%20second%20y-axis%20to%20the%20right%2C%20and%20connected%20with%20lines%20to%20(the%20lines%20etc%20are%20easy%20to%20fix.%20But%20I%20could%20fine%20a%20graph%20function%20for%20line%20%2B%20line%20graph.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKindly%2C%3C%2FP%3E%3CP%3EFrank%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2584973%22%20slang%3D%22en-US%22%3ERe%3A%20Extra%20y-axis%2C%20to%20add%20to%20line%20graph%20(Excel%2C%20Mac%20v16.41)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2584973%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111712%22%20target%3D%22_blank%22%3E%40Frank7879%3C%2FA%3E%26nbsp%3BNot%20sure%20what%20you%20tried%2C%20but%20Just%20selected%20both%20the%20Mean%20and%20CV%20data%20ranges.%20Then%2C%20inserted%20a%20line%20chart.%20Right-click%20on%20the%20the%20CV%20line.%20Format%20Data%20Series...%20and%20then%20select%20%22Secondary%20axis%22.%3C%2FP%3E%3CP%3EIs%20that%20what%20you%20needed%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-07-25%20at%2020.34.17.png%22%20style%3D%22width%3A%20481px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298259i00D5FE2D3395CA69%2Fimage-dimensions%2F481x296%3Fv%3Dv2%22%20width%3D%22481%22%20height%3D%22296%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-07-25%20at%2020.34.17.png%22%20alt%3D%22Screenshot%202021-07-25%20at%2020.34.17.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFile%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2586577%22%20slang%3D%22en-US%22%3ERe%3A%20Extra%20y-axis%2C%20to%20add%20to%20line%20graph%20(Excel%2C%20Mac%20v16.41)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2586577%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1111712%22%20target%3D%22_blank%22%3E%40Frank7879%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20create%20a%20dual%20axis%20line%20chart%20using%20your%20sample%20data.%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%22Dual%20Axis%20Line%20Chart.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298347i8B3E4CF78F08EF6F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Dual%20Axis%20Line%20Chart.png%22%20alt%3D%22Dual%20Axis%20Line%20Chart.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChart%20is%20created%20in%20Excel%20from%20few%20clicks%20using%20Data%20Visualization%20add-on.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20Regards!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello colleague or helpful person,

 

I have made graphs in Excel with 9 mean values + SD error bars. To these I wish to add a second y-axis to the right, which will show Coefficient of Variation. These are then 9 extra values that also will be linked with line. I am using Swedish Excel version, but that should not matter. I can only see alternatives with histogram + lines, with two y-axes.  Grateful for any help. (I can send the graph with data.) 

Kindly,

Frank Götmark

6 Replies

@Frank7879 Yes, please send the graph with the data. Tack!

 

 

@Riny_van_Eekelen 

 

Hi Riny, thanks for responding. I attach the Excel file, where you seem mean values (dots) connected by line, and with standard deviation.  You can also see CV values (coefficient of variation), and those are the values I would like to add to graph with a second y-axis to the right, and connected with lines to (the lines etc are easy to fix. But I could fine a graph function for line + line graph.

 

Kindly,

Frank

 

 

best response confirmed by allyreckerman (Microsoft)
Solution

@Frank7879 Not sure what you tried, but Just selected both the Mean and CV data ranges. Then, inserted a line chart. Right-click on the the CV line. Format Data Series... and then select "Secondary axis".

Is that what you needed?

Screenshot 2021-07-25 at 20.34.17.png

File attached.

Hi @Frank7879 

 

I tried to create a dual axis line chart using your sample data.

 

Dual Axis Line Chart.png

 

Chart is created in Excel from few clicks using Data Visualization add-on.

Best Regards!

Thank you for help!

Frank
Thank you Riny, for being helpful.
Best,
Frank