Does anyone know why when I have excel file open where I link my X-Axes that shows dates from another excel file that have dates shown in one column, if I have both files open, dates show no problem. When I close the file where I link from, then in my file where I have chart, X-Axes date labels switch to 5 digit number (ex.37999)
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
EXCEL-DATES IN CHART
- Thread starter xsubzeroz
- Start date
SkipVought
Programmer
xsubzeroz,
That 5 digit number IS the date serial value ( for instance, today, at this moment is 38012.31114, which can be FORMATTED in any number of ways like Mon Jan, 26, 04 07:28 using the format ddd mmm, d, yy hh:mm)
Make sure that the x-axis is formatted explicitly with a date format.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
That 5 digit number IS the date serial value ( for instance, today, at this moment is 38012.31114, which can be FORMATTED in any number of ways like Mon Jan, 26, 04 07:28 using the format ddd mmm, d, yy hh:mm)
Make sure that the x-axis is formatted explicitly with a date format.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Thread starter
- #3
SkipVought
Programmer
How is the DATE source data range formatted?
Does this formatting change when you close the linked file?
Try formatting as date.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
Does this formatting change when you close the linked file?
Try formatting as date.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Thread starter
- #5
Try converting 'em to text - use this formula
=TEXT(A1,"dd/mm/yyyy"
copy down and then paste values over the originals - be careful though - if you are doing any calcs based on the dates, they will no longer be dates
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
=TEXT(A1,"dd/mm/yyyy"
copy down and then paste values over the originals - be careful though - if you are doing any calcs based on the dates, they will no longer be dates
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
- Status