Excel - Secondary X & Y Axis (How do I link secondary X to primary Y)

Associate
Joined
17 Dec 2009
Posts
2,008
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
graph.png


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
 
Back
Top Bottom