Hi...I can't figure this one out! Really need some help. Trying to create a 2 axis scatter chart with the vertical axis in the middle (so the axis look like an cross). I can't get the secondary axis to go from vertical to horizontal. Data is as follows:
Scenario EAC Kg
1a 84 -150
1b -31 500
2a 43 -700
2b 56 -400
2c 6 -700
2d -59 -100
3a 30 -700
3b -87 200
3c -26 -400
4a 81 -400
4b -33 500
4c -14 500
I need, for each scenario an individual data point on an x and y axis.....any ideas?
Thanks much!
Jim
Scenario EAC Kg
1a 84 -150
1b -31 500
2a 43 -700
2b 56 -400
2c 6 -700
2d -59 -100
3a 30 -700
3b -87 200
3c -26 -400
4a 81 -400
4b -33 500
4c -14 500
I need, for each scenario an individual data point on an x and y axis.....any ideas?
Thanks much!
Jim