Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |