Display continuous dates in Pivot Chart

Hello,

I have a set of data in a pivot table with date times and events. I've made a pivot chart with this data, and grouped the data by day and year, then display a count of events for each day. So, my horizontal axis goes from 19 March 2007 to 11 May 2010, and my vertical axis is numeric, going from zero to 140.

For some days, I have zero events. These days don't seem to be shown on the horizontal axis, so 2008 is narrower than 2009.

How do I display a count of zero for days with no events?

I'd like my horizontal axis to be continuous, so that it does not miss any days, and every month ends up taking up the same amount of horizontal space.

Any help appreciated, thanks!

Douglas

Enter data for date times and events of zero. This will pick up the date (as it will now exist), and should display a zero count on those days for you.