How do I set the unit value on the x-axis?

T

Terry

My x values are 18.75, 37.5, 75, 150, 300. I need the axis to be linear from
0 to 300, but Excel evenly spces my values creating an exponential graph out
of linear data. How can I set the units to remain equal throughout the range
0-300? This is my work computer, and they just up-graded and the excel
program that I was accustomed to changed, but I assume this is Excel 2007?
 
D

David Biddulph

Perhaps you have chosen the wrong Chart Type? If you have used the
misleadingly named "Line Chart" it will treat the X-values as categories,
not as number values. You need the equally confusingly named XY-scatter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top