I am having problems creating pivot table of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

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

Pivot Table: deleted source data 1
How do I keep formatting when creating a chart from a pivot? 1
Pivot table creates stacked column 2
Pivot Table with Zero Values for Month 1
Pivot using 250,000 rows of data in Excel? 1
Pivot Chart Data Table 1
Pivot table charting 3
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0

Back
Top