| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
X-Axis Date
Hi,
I am making a graph with dates along the X-axis. The data was exported from Access and is in the format m/dd/yyyy h:mm:ss AM/PM. Excell doesnt seem to recognize this as a data format and it wont graph properly. I have tried "format cells", but it doesnt work. What is really strange is that when I click in the cell and then press enter, it converts to a date format that is recognized by excell. I have over 2 years of hourly data, so I dont really want to click in every cell. Anyone have any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Axis | Excel Discussion (Misc queries) | |||
| How do I force a secondary horizontal axis to act as a date axis? | Charts and Charting in Excel | |||
| X axis date - display beyond latest date. | Charts and Charting in Excel | |||
| Date Axis Must be on Date Basis | Charts and Charting in Excel | |||
| how to draw a chart using x,y axis not the date with x-axis? | Excel Worksheet Functions | |||
Threaded Mode
