Chart Axis Help

[forge13]

I am having issues with creating charts. I have some data as seen below

When I then put this into a chart it all goes a bit wrong!

Ideally I would like the High Threshold value along the x-axis (as 0.1,0.2,0.3 etc) with the detection accuracy on y-axis. I know the test data only shows a range of 0 to 1 for the detection accuracy but for other results it goes as high as 30.

It seems that Excel won't play ball though and the X-axis is linked to the number of cells that are selected rather than their content. It's all a bit of a mess.

I have tried varying number formatting options etc but with no real luck. Any advice would be greatly appreciated!

 

[VoG]

Try plotting that data on an x-y scatter chart.

Once plotted you can right click a point, select Format Data Series, then add a line and remove the points if you wish.

 

[forge13]

cool, that seems to work a bit better. thanks!