View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Excel Chart displays incorrect X-Axis

Excel doesn't have room to fit the entire label. Try one or more of these
steps:

1. Reduce the axis font size.
2. Widen the chart.
3. Increase the space between labels (the major unit on the scale tab, if
it's a time scale axis, or the categories between tick labels if it's a
category axis).
4. Use a format like m/d/yy, which shortens the data to a 2-digit year,
"12/12/06".
5. Rotate the labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Andreas" wrote in message
ups.com...
Hello,

question to the all the smart Excel brains out there. I have a chart
whose X-Axis displays dates for the year 2006. The dates are formatted
as "General". The chart does not display more than 9 digit dates. This
means that the date "1/12/2006" is displayed fine, but the date
"12/12/2006" will be truncated to "12/12/200."

Although I tried to change the formatting, increase the font size, and
tried various other steps, I am unable to display the full date on the
X-Axis. Does anybody have any idea on how to fix this.

Thanks in advance.

Andreas