Forum Discussion
Extra y-axis, to add to line graph (Excel, Mac v16.41)
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.
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
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.
- Thank you Riny, for being helpful.
Best,
Frank
