| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to colntrol location of category X axis labels on a bar chart? | Charts and Charting in Excel | |||
| dot plot - single x axis location with multiple y axis dots | Charts and Charting in Excel | |||
| XL2003 - Changing X-axis labels in XY Scatter... | Charts and Charting in Excel | |||
| Changing Y-Axis Labels from Numerical to Textual | Charts and Charting in Excel | |||
| how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel | |||
Linear Mode
