![]() |
changing the location of the x axis labels
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! |
changing the location of the x axis labels
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... 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! |
All times are GMT +1. The time now is 12:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com