#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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
|
#4
|
|||
|
|||
What if you changed your dates to text rather than Excel recognizing them as date formats?
|
#5
|
|||
|
|||
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.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
More Than 3 Lines in a Line Graph | JeffM | Excel | 1 | 12-22-2016 05:01 AM |
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 |