changing the location of the x axis labels

S

sunminlee1027

Hello, I'm trying to make column graphs by using excel 2002. The
problem is, my y axis values have some negative numbers, so the x axis
labels overlap with some of the columns. Is there anyway to relocate
the x axis labels while keeping the category x axis crossing at zero?
Thanks!
 
J

Jon Peltier

Double click on the axis. On the Patterns tab, for Tick Labels, choose the
Low option. The axis will remain at zero, but the labels will move to the
bottom of the chart.

- Jon
 

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