It might be the case that a Pivot Chart would be viable - which would aggregate by Date.

Perhaps best to post a sample file so people can see what you're working with in terms of source data (layout etc...).