|
|
|
|
#1
01-02-2020, 06:52 PM
|
|||
|
|||
Incorrect Dates on Horizontal Access in Line Chart
The attached was created in Excel 365 I have researched how to fix this issue and nothing works. The dates I entered into the raw data in column 1 are different from the dates in the horizontal axis. Does anyone know why the dates on the axis do not match the raw data? Your help is greatly appreciated. Karen 
|
|
#2
01-03-2020, 08:02 AM
|
||||
|
||||
|
See picture:
Box With Date axis the horizontal placing of points will be proportional to the actual dates, with points having a longer period between them further appart. Choose Text axis and all the points will be evenly spaced horizontally, regardless of period between individual points.
|
|
#3
01-05-2020, 07:07 PM
|
|||
|
|||
|
Thank you very much for your help.
That worked great, but for some reason it didn't work on another spreadsheet I have. See attached. When converting to text, it removed 10 dates from the axis. Not sure why! Any ideas?  Your help is greatly appreciated. Karen
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Date Axis on line chart includes dates with no data under them, but text axis causes data to clump | jcyo233 | Excel | 6 | 10-18-2018 04:49 AM |
| my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. | jalea148 | Excel | 3 | 01-06-2017 09:04 AM |
| How to change the default features for AutoShape horizontal line (button 'Insert horizontal line') | 534tomasz | Word | 6 | 10-13-2016 02:33 AM |
 Select which labels to display on horizontal axis on line chart
|
Jack H | Excel | 5 | 01-13-2016 10:05 AM |
|
Finish to Start Tasks dates incorrect
|
Rowey | Project | 5 | 05-01-2015 07:22 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode