Excel Chart displays incorrect X-Axis
 

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

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

Excel Chart displays incorrect X-Axis
 

One more - Starting with cells numberformat as my international "dd-mm-yyyy"
the axis numberformat, though linked to cells, was "dd-mm-yy". The full year
was truncated in the axis. Curiously, I found if I changed the axis format
to same as cells, then re-linked numberformat (somehow it got de-linked) I
got the full date to display.

Regards,
Peter T

"Jon Peltier" wrote in message
...
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