Chart Axis Help

forge13

New Member
Joined
Apr 2, 2011
Messages
2
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!
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,329
Messages
5,528,033
Members
409,799
Latest member
mlewan_ca

This Week's Hot Topics

Top