Software

Ask something
Question Locked

Excel Chart

0 helpful
3 replies

by fran_lew1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have been charting two columns of data --'value' and 'date' to a line chart.When I move the cursor to the line it shows 'series 'value' point (date) and and the 'value' at that point. Recently the date(ie '9/4') does not appear-instead it is replaced with a five digit number(ie'39329').I use Excel 2000
How can I retrive the 'date'??

3 replies

by gerila_7

I think it is just a matter of cell formatting.. copy those number to a cell and change the cell formatting from general/number to date/time format

hope that helps... TQ

by fran_lew1

I have tried your suggestion and it corrected the issue.

Thanks

This discussion is closed to new replies.