MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Need to control where Y axis crosses X axis


Posted by dax on October 16, 2001 1:14 PM

Hi, If I have 10 category levels for X and doing a line
chart, can I make the Y axis crosses X axis at "0" level,
i.e., not overlaps with the "1" level of X? In other words,
I'd like to have an offset between where Y crosses X and
the first tick mark for the X axis. And how could I do that?
Thanks a lot!


Posted by Jonathan on October 16, 2001 1:33 PM

Hmmm. I just tried this and it seemed to work. I made up two columns of numbers, selected them, and hit F11 to get the default chart. Just as you say, there's no tick mark between the Y-axis and the first X category. So then I went back to my "source data..." and I just stuck in two blanks at the top of the two data columns and made sure they were now included in the 'data source'. Does this accomplish what you want?

Posted by dax on October 16, 2001 3:00 PM

Yes, adding an empty row did it. Thanks! They should
have made this an option though in my opinion.
I made up two columns of numbers, selected them,
and hit F11 to get the default chart. Just as you
say, there's no tick mark between the Y-axis and
the first X category. So then I went back to my
"source data..." and I just stuck in two blanks
at the top of the two data columns and made sure
they were now included in the 'data source'. Does this accomplish what you want?