Negative numbers on X axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a line chart that has 2 Y axis and the X axis has values from 1 to 60.
Is there a way to place negative numbers on the x axis. For example I need to
have the x axis start at -5. When I go to format axis and then Scale, it
won't let me start at -5. I am using Excel 2002.

Thank you in advance for any help.

Regards,

Dee
 
Dear Barb,

I am not sure what that means. Could you explain?

Regards,

Dee
 
Dee,

Is the Chart Type set to XY (Scatter)? If you change it to that type,
you should be able to set the X-axis scale to what you need.

Also, when you are editing the X-axis scale, make sure the box next to
"Logarithmic Scale" is NOT checked. Don't worry about what it means,
you do not want that option.

Mark
 
You must log in or register to reply here.

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

Similar Threads

Horizontal axis to the bottom 1
Make Y-axis values correspond to x- axis value 1
Negative values on X axis 6
Positioning x axis at bottom of chart with negative values 5
Formatting 'X' Axis -- 2 fundamental differences 7
How do I change where category x axis crosses the 2nd y axis? 7
Data labels along below x axis when y axis has negative values 1
X-axis in 2007 4

Back
Top