Excel Chart Gap in line

swjtx99
swjtx99 used Ask the Experts™
on
I have a several charts on a sheet and one of them has a gap. All the charts get the data from another sheet and on days where there is no data (weekends) all the other charts just draw a line from the last data point to the next data point......except this one. I've looked at the settings and formatting and googled but can't figure out why this chart has a gap.

Example attached (pic in a word document of the chart in question).

Any help would be appreciated.

swjtx99
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
don't see anything attached...
attachment is missing, however check your axis.  It could be that you are set to text, when date would be a more appropriate setting.

-SA

Author

Commented:
I'll attempt attachment again

I looked at the axis format. It's set to Auto, I tried text, & Date but that didn't help.
Gap-Chart.docx
Oh!  You need to change how your handling your hidden or empty cells on your dataset:

See this image below:

Screenshot of where to click

Author

Commented:
Wow, pretty simple but I missed it again and again. Thanks!!

swjtx99

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial