graph changed from the last time I worked with it

  • Thread starter Thread starter jake 750
  • Start date Start date
J

jake 750

I have a simple line graph and when I went back to it the dates in the date
column
had changed to sequential numbers eg. 39088, 39089, . . . and Date now
appears in the legend. I tried to get back to hoe I set it up with Wizard
but only am able to get wizard to take me to a new setup.
 
Hi,

I'm not clear on the question, but here are a few ideas:

1. You can't get back into the charting wizard unless the chart is selected.
2. If you are asking about the number 39088 - these just need to be
formatted as dates, Excel stores dates as integers and times as decimals, so
together you get dates and times 39088.1234.
 
Back
Top