Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-20-2020, 12:18 PM
oscarlimerick oscarlimerick is offline Date spacing on clustered line graph Windows 8 Date spacing on clustered line graph Office 2013
Advanced Beginner
Date spacing on clustered line graph
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default Date spacing on clustered line graph

I looked through the FAQ and can't find any reference to this problem:

I am having a problem with the date label on my clustered column graphs. I have attached the excel worksheet as well as a JPEG screen snapshot. Ideally I want a clustered column graph that has the date along the horizontal axis with the days spaced one day apart. So using the data on my spreadsheet, if I select "a4:a103,d4:d103" and create a clustered column graph, I get the desired outcome, the graph spaces the dates on the horizontal axis 1 day apart. But if I then select "a4:a104,d4:d104", and ask for a clustered column graph, I get the graph, but Excel has spaced the days 2 days apart on the horizontal axis instead of one day! It still plots every day, but doesn’t label the date in the horizontal axis the way I want it to appear, and it doesn’t seem to matter if I widen or narrow the horizontal graph area. Something happens between selecting rows 4-103 and 4-104 that makes excel create a different graph. As you can see on the screen snapshot, I have formatted the plot of the horizontal axis to be spaced major units 1 day. Is there any way to correct this? Many thanks
Attached Images
File Type: jpg screen snapshot for graph issue.jpg (235.5 KB, 22 views)
Attached Files
File Type: xlsx example sheet 1.xlsx (26.8 KB, 7 views)
Reply With Quote
  #2  
Old 09-21-2020, 06:25 PM
Purfleet Purfleet is offline Date spacing on clustered line graph Windows 10 Date spacing on clustered line graph Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

I am sure that i have seen somewhere that there is a limit in the horizontal axis on a graph and i think it was 100.


In all honesty do you really want all the data points showing in a graph? after all a graph is not for details it is to show trends or to highligght a specific point


In my opinion the second one looks nicer
Reply With Quote
  #3  
Old 09-23-2020, 10:28 AM
oscarlimerick oscarlimerick is offline Date spacing on clustered line graph Windows 8 Date spacing on clustered line graph Office 2013
Advanced Beginner
Date spacing on clustered line graph
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default

For my purposes I need to have the graph show every date, I can make it not look so cluttered by just widening the graph. What do you know abo0ut powerpoint? If I were to instead make this graph in powerpoint instead of Excel would I be faced with the same 100 line restriction on the horizontal axis? Thanks
Reply With Quote
  #4  
Old 10-06-2020, 06:49 AM
kilroyscarnival kilroyscarnival is offline Date spacing on clustered line graph Windows 7 64bit Date spacing on clustered line graph Office 2010
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

What if you changed your dates to text rather than Excel recognizing them as date formats?
Reply With Quote
  #5  
Old 10-06-2020, 09:51 AM
oscarlimerick oscarlimerick is offline Date spacing on clustered line graph Windows 8 Date spacing on clustered line graph Office 2013
Advanced Beginner
Date spacing on clustered line graph
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default

Quote:
Originally Posted by kilroyscarnival View Post
What if you changed your dates to text rather than Excel recognizing them as date formats?
I probably can't do that because I have a formula that is extracting the date information from selected cells to tell me the dates certain data was entered into a cell. I haven't had time to look at powerpoint yet and see if it will let me graph and plot dates out past 100, but if it doesn't I will just have to live with this excel limitation. Thanks for replying.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date spacing on clustered line graph I cant find my clustered column line template? oscarlimerick Excel 6 09-16-2020 08:17 PM
Publisher 2010 refuses to hold change in Normal from 0.94 line spacing to 1 line spacing mkcsufi Publisher 0 11-28-2019 07:05 AM
Date spacing on clustered line graph More Than 3 Lines in a Line Graph JeffM Excel 1 12-22-2016 05:01 AM
Date spacing on clustered line graph column clustered bar graph with a line graph as secondary axis Alaska1 Excel 2 06-09-2014 07:13 PM
Priority of line graph vs bar graph in terms of front to back positioning on a chart DavePPointuser PowerPoint 1 04-30-2014 10:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:37 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