Plotting data from a pivot table

[Jerome Ranch]

Hi
I'm plotting data from a pivot table in a bar chart.
The x axis is grouped is by months with years, and the y axis is a
simple count.
The problem is for some months there is no data, and the pivot leaves
that month out. Not good, especially if one is looking graphically at
a trend analysis. It looks like the data is continuous month after
month when its not (since somemonths are missing), and many years have
fewer months than others.
Any idea on how to get the empty months into the pivot?
The only way I can think of is to create dummy data in the data set.
Thanks
Jerry

[Debra Dalgleish]

In the PivotTable, right-click the Date field button
Choose Field Settings
Add a check mark to Show items with no data, click OK

Jerome Ranch wrote:
> Hi
> I'm plotting data from a pivot table in a bar chart.
> The x axis is grouped is by months with years, and the y axis is a
> simple count.
> The problem is for some months there is no data, and the pivot leaves
> that month out. Not good, especially if one is looking graphically at
> a trend analysis. It looks like the data is continuous month after
> month when its not (since somemonths are missing), and many years have
> fewer months than others.
> Any idea on how to get the empty months into the pivot?
> The only way I can think of is to create dummy data in the data set.
> Thanks
> Jerry


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[Jerome Ranch]

Debra
I am in your debt . it worked famously
Thanks much
Jerry


On Sun, 20 Nov 2005 13:11:58 -0500, Debra Dalgleish
<[email protected]> wrote:

>In the PivotTable, right-click the Date field button
>Choose Field Settings
>Add a check mark to Show items with no data, click OK