+ Reply to Thread
Results 1 to 2 of 2

Excel 2010 Pivot Table Chart not doslaying Grand Total

  1. #1
    Registered User
    Join Date
    06-30-2011
    Location
    Union, NJ
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    20

    Excel 2010 Pivot Table Chart not doslaying Grand Total

    Hi All, it has been a while since I posted in the forum, I have a bit of an issue with Pivot Table chart. I am trying to display data on a chart and dynamically change the items to display by manipulating the filters. What I cannot figured out is how to display the Pivot Table Grand Total column on the chart. This is the total that the pivot creates and there is no total field in the data. Hope this explanation I gave is clear. Thank you on advance for your help.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Excel 2010 Pivot Table Chart not doslaying Grand Total

    Pivot charts do not display the total column/row.

    http://www.contextures.com/xlfaqPivot.html#grand
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Is it possible to have both Grand Total and Grand Average in a Pivot Table?
    By ANS in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 10-16-2012, 05:15 AM
  2. Replies: 2
    Last Post: 07-23-2012, 09:48 AM
  3. Grand total excel pivot table help
    By busymantoday in forum Excel General
    Replies: 8
    Last Post: 07-12-2012, 12:16 PM
  4. Pivot Table - Sub Total & Grand Total Filter
    By ramki in forum Excel General
    Replies: 1
    Last Post: 08-07-2009, 11:40 PM
  5. [SOLVED] % of Running Total to Grand Total in Pivot Table
    By David in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2005, 04:05 PM

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