Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-02-2020, 06:52 PM
Karen615 Karen615 is offline Incorrect Dates on Horizontal Access in Line Chart Windows 7 64bit Incorrect Dates on Horizontal Access in Line Chart Office 2010 64bit
Competent Performer
Incorrect Dates on Horizontal Access in Line Chart
 
Join Date: Jun 2011
Location: Chicago
Posts: 112
Karen615 is on a distinguished road
Default 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
Attached Files
File Type: xlsx LineChart.xlsx (17.4 KB, 6 views)
Reply With Quote
  #2  
Old 01-03-2020, 08:02 AM
p45cal's Avatar
p45cal p45cal is offline Incorrect Dates on Horizontal Access in Line Chart Windows 10 Incorrect Dates on Horizontal Access in Line Chart Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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.
Reply With Quote
  #3  
Old 01-05-2020, 07:07 PM
Karen615 Karen615 is offline Incorrect Dates on Horizontal Access in Line Chart Windows 7 64bit Incorrect Dates on Horizontal Access in Line Chart Office 2010 64bit
Competent Performer
Incorrect Dates on Horizontal Access in Line Chart
 
Join Date: Jun 2011
Location: Chicago
Posts: 112
Karen615 is on a distinguished road
Default

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
Attached Files
File Type: xlsx Tracking.xlsx (17.0 KB, 5 views)
Reply With Quote
  #4  
Old 01-06-2020, 03:52 AM
p45cal's Avatar
p45cal p45cal is offline Incorrect Dates on Horizontal Access in Line Chart Windows 10 Incorrect Dates on Horizontal Access in Line Chart Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

See pic.
Box

You have interval set to 3, change to Automatic or set a different number.
Reply With Quote
  #5  
Old 01-07-2020, 09:02 PM
Karen615 Karen615 is offline Incorrect Dates on Horizontal Access in Line Chart Windows 7 64bit Incorrect Dates on Horizontal Access in Line Chart Office 2010 64bit
Competent Performer
Incorrect Dates on Horizontal Access in Line Chart
 
Join Date: Jun 2011
Location: Chicago
Posts: 112
Karen615 is on a distinguished road
Default

Thank you sooo much! It worked great!
Reply With Quote
Reply

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
Incorrect Dates on Horizontal Access in Line Chart Select which labels to display on horizontal axis on line chart Jack H Excel 5 01-13-2016 10:05 AM
Incorrect Dates on Horizontal Access in Line Chart Finish to Start Tasks dates incorrect Rowey Project 5 05-01-2015 07:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft