I am having problems creating pivot table of data, January through to
December. For months where there is no data, no entry appears in the table -
Can I force it to display so that the resulting graph displays an accurate
trend?
I am having problems creating pivot table of data, January through to
December. For months where there is no data, no entry appears in the table -
Can I force it to display so that the resulting graph displays an accurate
trend?
In the pivot table, double-click the Date field button
Add a check mark to the 'Show items with no data' box
Click OK
wyman wrote:
> I am having problems creating pivot table of data, January through to
> December. For months where there is no data, no entry appears in the table -
> Can I force it to display so that the resulting graph displays an accurate
> trend?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks