swjtx99
asked on
Excel Chart Gap in line
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
Example attached (pic in a word document of the chart in question).
Any help would be appreciated.
swjtx99
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
-SA
ASKER
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
I looked at the axis format. It's set to Auto, I tried text, & Date but that didn't help.
Gap-Chart.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Wow, pretty simple but I missed it again and again. Thanks!!
swjtx99
swjtx99