#1
|
|||
|
|||
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
|
||||
|
||||
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
|
|||
|
|||
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 |
#5
|
|||
|
|||
Thank you sooo much! It worked great!
|
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 |