why can't Y-axis cross the X-axis at zero

J

John Bess

Hi,

The problem I have is that the y axis crosses the x axis
at 1 and when I try to change that to 0 under format
axis>scale it returns a message saying "The Number must
be between 1 and 31999, Try again bla bla.."

Is there anyway to change that?


Thanks,

John
 
P

Paolo T

Hi,

The problem I have is that the y axis crosses the x axis
at 1 and when I try to change that to 0 under format
axis>scale it returns a message saying "The Number must
be between 1 and 31999, Try again bla bla.."

Is there anyway to change that?


Thanks,

John
Click to expand...

You are using a "line graph" or "bar chart" - in order to do what yo
uwant you'll need to set to an XY scatter graph, or re-number your
x-axis so that the first one is zero.
 

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

Make Y-axis values correspond to x- axis value 1
Formatting 'X' Axis -- 2 fundamental differences 7
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
How do I change where category x axis crosses the 2nd y axis? 7
move y-axis to the left of x-axis "0" 3
X-axis to cross Y-axis at avrg Y-value 7
Excel 2007: X-axis labeling 1
Can't get the x-axis to cross at value 0 for both y-axes 3

Top