Forum Discussion

Frank7879's avatar
Frank7879
Copper Contributor
Jul 24, 2021
Solved

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

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. T...
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jul 25, 2021

    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.

Resources