Home |
Search |
Today's Posts |
#1
|
|||
|
|||
time scale axis
When I change my X axis to time scale, it changes my axis dates to 1/1/1900.
When I try to fix this, it scrunches all my data points up to the left. What the heck am I doing wrong? |
#2
|
|||
|
|||
Sounds like Excel doesn't recognize your category labels as numerical
dates. In this case, it treats the categories as 1, 2, 3, etc, and Excel thinks day 1 is 1/1/1900. Remove the horizontal alignment from the cells with dates. Are they all right aligned? Any which are not are text. To convert them to numerical dates, assuming they are otherwise recognizable to Excel, format the cells as dates (Format cells Number tab, select something from the Date category), and if that doesn't do it, select and copy a blank cell, select the nonnumeric cells, and use Paste Special from the Edit menu, and choose the Value and Operation - Add options, and press OK. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ HB1972 wrote: When I change my X axis to time scale, it changes my axis dates to 1/1/1900. When I try to fix this, it scrunches all my data points up to the left. What the heck am I doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate Date & Time differences | Excel Worksheet Functions | |||
Time and motion chart | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Time Sheets | Excel Discussion (Misc queries) | |||
I want to produce a log-log chart. Logrithmic scale on both axis. | Charts and Charting in Excel |