graph changed from the last time I worked with it

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.
 
S

ShaneDevenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top