+ Reply to Thread
Results 1 to 2 of 2

I am having problems creating pivot table of data

  1. #1
    wyman
    Guest

    I am having problems creating pivot table of data

    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?

  2. #2
    Debra Dalgleish
    Guest

    Re: I am having problems creating pivot table of data

    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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1