Excel line graph not showing all data

12-03-2015, 12:24 PM #1
Table of Contents Show
Forum Contributor
Chart not showing all data
Good Afternoon
I'm not sure what I am missing but I have a chart within the following attached workbook but its not showing all the stats, I have tried to format this axis but to no avail.
its most probably something really simple.
Any help would be appreciated
Meeting Stats.xls
12-03-2015, 12:34 PM #2
Re: Chart not showing all data
Hi,
What precisely do you mean by 'not showing all the stats'?
It is showing all the plots and the last one of 762. Do you mean it's not showing all the dates and appears to stop at 29/11/2015?

If so in the format axis pane just change the maximum date to 3/12/2015 - the day after the last plot.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon
below the post.
12-04-2015, 08:59 AM #3

Forum Contributor
Re: Chart not showing all data
Apologies Richard yes I meant that dates stopped at the 29/11/15, your suggestion worked fine however I still seem to have an issue as I have it set to show every day but there seems to be 4 day gaps for example it jumps from the 17/05/15 to the 21/05/15 but there are figures for every day between those dates!
12-07-2015, 10:31 AM #4
Forum Contributor
Re: Chart not showing all data
bump, anyone have any ideas as I have changed the axis to show everyday!
12-07-2015, 01:28 PM #5
Re: Chart not showing all data
Hi,
I think this is all associated with the physical space on the axis. It seems Excel is doing its best to get as many dates in as possible and prefers to have gaps rather than overlap one date with another and make them unreadable. See the attached where I've resized your chart widthways in order to give more room. All dates now show but of course the chart is larger.
12-07-2015, 01:30 PM #6

Forum Contributor
Re: Chart not showing all data
10-04-2021, 12:32 PM #7
Registered User
Re: Chart not showing all data
Please I also have same problem with my excel worksheet. All my charts are not showing maybe due to horizontal axis display.I tried but no success.
please someone with an idea can do step by approach so i can follow
thank you
10-05-2021, 12:20 AM #8

Re: Chart not showing all data
Originally Posted by Jakpa
Please I also have same problem with my excel worksheet. All my charts are not showing maybe due to horizontal axis display.I tried but no success.
please someone with an idea can do step by approach so i can follow
thank you
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see
Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford

How do I get Excel to show all graphs?

On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look. If you don't see a chart you like, click All Charts to see all the available chart types. When you find the chart you like, click it > OK.

How do I fill data gaps in Excel?

Method 1.

Select the empty cells..

Press F2 to enter a value in the active cell..

Type in the number or text you want..

Press Ctrl + Enter..

How do I fix the graph in Excel to stop drawing the line when data ends?

rRght click the data series on the chart|Select data|In the Popup bottom left click 'Hidden and Empty cells| Select show empty cells as Gaps. OK Out. If the cells contain a formula returning "" if there are no data then make the formula return NA() and Excel won't plot those cells.