I have been tasked with plotting torque, current, power and speed of a motor on the same graph.
I am using excel 2016.
I've spent hours trawling the web to gain answers but in summary.
PX = Speed
PY = Torque
SX = Current
SY = Power
Series 1 = Torque/Speed
Series 2 = Power/Speed
Series 3 = Current/Torque
This doesn't work and I keep getting my axis primary X values instead of secondary X hich means something is falling over somehow. I have seen in previous excel versions that you can select which primary/secondary axis you wish to use for each set of values but in 2016 it seems to be either primary or secondary and it breaks if not.
I've managed to create all my axis values correctly by doing
Torque/Speed
Current/Power
This weirdly plots correctly for
Torque/Speed
Power/Speed
Then when I add current as a line and try to plot it onto either axis, torque changes the values again and power just gives me the power curve from series 2.
Here are the values and how I want the graph to look, minus the current data being plotted
Here is a copy of my spreadsheet shared from one drive. Ignore all other data inside. If accessing, try to save on your own pc than editing online to allow others to see my problem
https://1drv.ms/x/s!AsbTP-iyRlMW7Tc0zlll47LUIQmN?e=oRJODq
Many thanks for looking and hopefully helping
I am using excel 2016.
I've spent hours trawling the web to gain answers but in summary.
PX = Speed
PY = Torque
SX = Current
SY = Power
Series 1 = Torque/Speed
Series 2 = Power/Speed
Series 3 = Current/Torque
This doesn't work and I keep getting my axis primary X values instead of secondary X hich means something is falling over somehow. I have seen in previous excel versions that you can select which primary/secondary axis you wish to use for each set of values but in 2016 it seems to be either primary or secondary and it breaks if not.
I've managed to create all my axis values correctly by doing
Torque/Speed
Current/Power
This weirdly plots correctly for
Torque/Speed
Power/Speed
Then when I add current as a line and try to plot it onto either axis, torque changes the values again and power just gives me the power curve from series 2.
Here are the values and how I want the graph to look, minus the current data being plotted

Here is a copy of my spreadsheet shared from one drive. Ignore all other data inside. If accessing, try to save on your own pc than editing online to allow others to see my problem
https://1drv.ms/x/s!AsbTP-iyRlMW7Tc0zlll47LUIQmN?e=oRJODq
Many thanks for looking and hopefully helping