Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart dates
Top of the Morning
Using a date range (by the week) for my x-axis 1/1/06, 1/2/06, 1/3/06........ displaying as 1/1/00, 1/8/00, 1/15/00....... need to dispaly as 1/1/06, 1/8/06, 1/15/00........ Thanks in advance |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart dates
The numbers 1/1/00, 1/8/00 are really 1/1/1900, 1/8/1900, etc., which are
how 1, 8, etc. appear in date format. This is because Excel doesn't recognize the X values as dates. First make sure the chart has values assigned as X values: select Source Data from the Chart menu, click on the Series tab, and make sure a range is specified in the box for Category Labels. If not, Excel uses 1, 2, 3 by default, explaining your strange axis labels. If there is a range specified for Category labels, make sure they are truly dates, and not text labels that look like dates but that Excel doesn't recognize as such. Remove horizontal formatting (e.g., left or center alignment) from the cells. If the values are not right aligned, they are not numerical. Assign a date or other numerical (non text) number format to the cells, then copy a blank cell, select the cells, and use Paste Special from the Edit menu, with the options Values and Operation - Add. Adding zero (from the blank cell you copied) forces Excel to reevaluate the uncooperative cells as numbers. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "jeff" wrote in message ... Top of the Morning Using a date range (by the week) for my x-axis 1/1/06, 1/2/06, 1/3/06........ displaying as 1/1/00, 1/8/00, 1/15/00....... need to dispaly as 1/1/06, 1/8/06, 1/15/00........ Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I limit my chart | Charts and Charting in Excel | |||
Pie chart on a pie chart (exploded)? | Excel Discussion (Misc queries) | |||
Formatting dates on x axis of chart...! | Excel Discussion (Misc queries) | |||
the dates to label the x axis on the scatter chart won't print | Charts and Charting in Excel | |||
How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel |