Date Axis on line chart includes dates with no data under them, but text axis causes data to clump

		Microsoft Office Forums > Microsoft Excel > Excel
Date Axis on line chart includes dates with no data under them, but text axis causes data to clump

FAQ

Thread Tools

Display Modes

10-17-2018, 01:00 PM

jeffreybrown jeffreybrown is offline

Windows Vista Date Axis on line chart includes dates with no data under them, but text axis causes data to clump

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

Quote:

Originally Posted by jcyo233

I am trying to get my line graph to not display dates that are not associated with any data?

Can you explain with Point 1 Gap what you mean by dates without any associated data?

Do you mean not show 9/22 and 9/23 since they have no data?

The easiest solution, create a pivot chart.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
X axis graph all dates when date column contains specific dates..possible ?	DBenz	Excel	2	03-28-2018 04:59 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
Excel 2016 line chart shows 2 erroneous (zero) data points in x axis. How to remove them?	5434aw	Excel	4	07-31-2016 07:54 AM
Secondry Axis overlapping in bar chart dual axis in Powerpoint 2010	sharath_ms	PowerPoint	0	07-08-2013 10:06 PM
chart axis text line breaks	Saskabush	PowerPoint	1	09-12-2012 10:48 AM