Plotting data from a pivot table

J

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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get two different grouped pivot tables from the same datatable? 6
Pivot Table Help! 1
Export Pivot table 1
Reversing Dates Sequence along X axis in a chart 3
Resize a Pivot table Pie Chart 1
Possible to use pivot table on non-mumeric fact data withoutcalculating? 3
Excel 2007 graphs/charts automatically populate with new data 1
Pivot table report invalid 0

Top