ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   changing the location of the x axis labels (https://www.excelbanter.com/charts-charting-excel/173490-changing-location-x-axis-labels.html)

[email protected]

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!

Jon Peltier

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