Display continious dates in Pivot Chart

Posted by Douglas on Stack Overflow See other posts from Stack Overflow or by Douglas
Published on 2010-05-13T16:10:32Z Indexed on 2010/05/13 16:14 UTC
Read the original article Hit count: 171

Filed under:
|

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.

(This question is similar to the unanswered question here, but I'd rather not generate a table of all the days in the last x number of years just to get a smooth plot!)

© Stack Overflow or respective owner

Related posts about excel

Related posts about pivot-table