Jul 24 2021 09:33 AM
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
Jul 25 2021 01:02 AM
Jul 25 2021 10:54 AM
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
Jul 25 2021 11:35 AM
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?
File attached.
Jul 26 2021 05:16 AM
Hi @Frank7879
I tried to create a dual axis line chart using your sample data.
Chart is created in Excel from few clicks using Data Visualization add-on.
Best Regards!
Jul 27 2021 04:23 AM
Jul 27 2021 04:24 AM
Jul 25 2021 11:35 AM
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?
File attached.