Fill in a chart with a zero (0) value if a record does not exist for every date
I have a table that has a date of an event, type of event (up to 100+ different types) , and summary count of each event type. On a chart I need to have every day since the first of the year shown across the X axis, and the count of events on the Y axis. This is not a big issue, however, I DON'T have a record for each date for each type of event and I need to chart a zero value for each event type if there is no corresponding record for that event type.
Without creating a script to add records for each date and event type that would have a zero value, is there a way t fill in the dates on a chart so that it would show every date (YTD) and a zero value if there is no related record with a count? So I need to show Jan 1, 2014 - July 14, 2014 on each chart. See the result I currently have in the attached screen shot.