Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart incorrectly displays time of day on x-axis | Excel Discussion (Misc queries) | |||
XY Scatter Chart with X-axis displays the Category Name | Charts and Charting in Excel | |||
Y axis box size incorrect in Excel 2003 | Charts and Charting in Excel | |||
X axis displays incorrect values | Charts and Charting in Excel | |||
Sum Function sometimes displays incorrect answer | Excel Worksheet Functions |