Thread: Pivot Chart

I have a pivot table recording multiple event types by month. How can I chart an event type showing the 12 months even if there is no event for a particular month?

eg if there is no event data for August how can I avoid the pivot chart ignoring August.

Thanks

Hi There,

From the top of my head I would say that it is not possible, because the pivotchart (and the same goes for the pivot table) cannot show something that is not there.

They only solution I can think of is adding a dummy entry in thedata on which the pivot chart is based.

J.