I am having problems creating pivot table of data

W

wyman

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?
 
D

Debra Dalgleish

In the pivot table, double-click the Date field button
Add a check mark to the 'Show items with no data' box
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

Creating a Chart on form from selected data in query. 0
Help creating a search form in Access XP 0
Dealing with a Pivot Table (when I don't want to) 0
pivot table missing rows? 0
Excel does not accept text format! 0
Pivot table 0
Plotting Graph with dynamic table 3
Trend lines on data subsets 2

Top