Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dates display inconsistent in MS Excel 2007
I have two files with the same date ranges (Jun-01 thru Jun-09), but in the
chart one file shows Jan not Jun. The only difference is the format, in the first file the first date is shown as a number format with value of , whereas in the second file it is shown as a date mmm-yy. Can someone explain why this is happening? I can send the files if you want to see exactly how the dates are entered. Please assist. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inconsistent order of dates on pivot axis | Excel Discussion (Misc queries) | |||
display dates with ordinal numbers in excel | Excel Discussion (Misc queries) | |||
Help! ISO formula for inconsistent monthly dates | Excel Discussion (Misc queries) | |||
Graphing inconsistent dates and data | Charts and Charting in Excel | |||
How can I get Excel 2003 to display dates before 1900 | Excel Discussion (Misc queries) |