ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   graph changed from the last time I worked with it (https://www.excelbanter.com/charts-charting-excel/188256-graph-changed-last-time-i-worked.html)

jake 750

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.

ShaneDevenshire

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.



All times are GMT +1. The time now is 05:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com