View Single Post
 
Old 10-17-2018, 10:22 AM
jcyo233 jcyo233 is offline Windows 7 32bit Office 2016
Novice
 
Join Date: Oct 2018
Posts: 3
jcyo233 is on a distinguished road
Default Date Axis on line chart includes dates with no data under them, but text axis causes data to clump

I am trying to get my line graph to not display dates that are not associated with any data. When I change the axis to a text axis (or put apostrophes in front of the dates to make them text), the graph clumps up on the left side of the graph and is just a vertical line. All axis labels are piled on top of each other. Pictures are attached. Any suggestions?
Attached Images
File Type: png Gap Data.PNG (6.3 KB, 16 views)
File Type: png Gap Date Axis.PNG (8.2 KB, 15 views)
File Type: png Gap Text Axis.PNG (3.5 KB, 15 views)
Reply With Quote