| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
graph changed from the last time I worked with it
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
graph changed from the last time I worked with it
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. -- Cheers, Shane Devenshire Microsoft Excel MVP "jake 750" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| graph won't update when data is changed | Charts and Charting in Excel | |||
| Figuring time worked, and then separating it into regular time an. | Excel Worksheet Functions | |||
| Total TIme worked | Excel Worksheet Functions | |||
| Calculating Pay based on time of day hrs worked | Excel Worksheet Functions | |||
| How do I subtract one time from another to get OT worked? | Excel Worksheet Functions | |||
Linear Mode
