| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Date in data is changing to Jan in chart Excel 07
I have a row of dates: Dec-96, Dec-97, Dec 98, and so on up to Dec-08. The
date in the first cell is typed in as 12/15/96, but formatted to show Dec-96. The rest of the cells are a foumula: =cell+365, the cell value is relative. When we create a chart, they become Jan. I tried changing the first underlying date to 12/1/96, which worked sometimes but not everytime I created a chart, and it didn't work for the end user at all. I've never run into this before. We have recently migrated to Office 07. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to change data table without changing chart | Charts and Charting in Excel | |||
| Changing color of line chart by date | Charts and Charting in Excel | |||
| Want to use same Chart against changing data and variable titles? | Charts and Charting in Excel | |||
| stop changing data to date | New Users to Excel | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
Threaded Mode
