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