Scatter Chart

[JIM456]

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

 

[Andrew Poulsom]

If you plot columns 2 and 3 as an XY(Scatter) Chart don't the axes cross at zero? They do for me in Excel 2010.

 

[JIM456]

If you plot columns 2 and 3 as an XY(Scatter) Chart don't the axes cross at zero? They do for me in Excel 2010.

Thanks....I developed a solution. The regular scatter chart works in you omit the "scenario" numbering. I then manually added the scenario numbering to the data points.

Thanks for looking at this anyway.


Jim