• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Why does my pivot chart exclude months for certain data items?

Why does my pivot chart exclude months for certain data items?

Problem

If you are plotting trends over time with a pivot chart, and there is no occurrence of a particular month, the pivot chart excludes that month all together. However, in most cases, you will want to show your audience a placeholder for that month, illustrating that there is no data there.

For example, the chart in Figure A.20 shows a trend from January through December, but you will notice that May through June is not shown.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint