| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I get the dates on an excel chart to stay as dates instead.
On some of my Excel charts, the date series on the X axis changes
automatically from a date format to serial numbers. Can anyone help me figure out why, pls? |
|
#2
|
|||
|
|||
|
If the data is in one workbook, and the chart in another, when the data
workbook is closed, the chart can no longer find the right number format. Reopen the data workbook, activate the chart, double click the date axis, and click on the Number tab. If the number format is wrong, fix it there. In any case, uncheck the Linked to Source box, then click OK. Since you're no longer linked to source, the number format stays with the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Rani wrote: On some of my Excel charts, the date series on the X axis changes automatically from a date format to serial numbers. Can anyone help me figure out why, pls? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| axis title text box is wrong size in chart for excel 2003 | Charts and Charting in Excel | |||
| copying excel chart formats from one chart to another | Excel Discussion (Misc queries) | |||
| How do we generate Candlestick chart using Microsoft Excel? | Charts and Charting in Excel | |||
| Excel 2003 Trashes Imported Dates | Excel Discussion (Misc queries) | |||
| Lines not visible in an Excel line chart | Charts and Charting in Excel | |||
Linear Mode
