Thread: How to get graph axis to have evenly spaced values.

Hi

I'm trying to get a graphs to show difference against power, but i want the power axis to be labled evenly along its length, from 1000 to 100 and not in uneven jumps of 1000, 660 etc as it has done, I've attached a screen shot. I can understand why its' doing what it's doing, just using my numbers as lables, but does anyone know how i can get it to change this?

http://img843.imageshack.us/img843/4344/excels.jpg

I hope that made sense.

Thanks for any help.

Jim

Oh its Excel 2010

EDIT - I've highlighted the values i want to use in the image

Use a xy-scatter chart rather than a line chart.

Note this will reverse the order of your plotted information as the default position of 0 is bottom left of plot area.