+ Reply to Thread
Results 1 to 2 of 2

How to do a grand total using pivot chart

  1. #1
    Registered User
    Join Date
    11-20-2017
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    8

    How to do a grand total using pivot chart

    Capture.PNG

    Is there a way to use pivot chart to show the total hours and also at the same time showing the break down as per attached picture.

    Am stuck=C

    Best Regards,
    Gerald
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,634

    Re: How to do a grand total using pivot chart

    This Excel Forum thread seems to address the same question. There is a link provided to an article in the second post of the thread that doesn't work, however I believe that the update to the article is here.
    I don't know that it will be possible to do what you want, (since the OP of that thread never provided feedback) however it would be easier to at least make an attempt if you would upload a desensitized version of some of your source data and a corresponding pivot table.
    To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Calculated field using the Grand Total and Values fields of Pivot chart
    By krissysteen in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 02-01-2018, 04:25 AM
  2. Need help creating pivot - grand total and grand total as % of column value
    By obionenairobi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-18-2017, 08:00 AM
  3. Using Grand Total in Pivot Chart
    By eSmith313 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-13-2016, 06:37 AM
  4. Create Grand Total Pivot Chart
    By Moggzzz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-08-2016, 11:14 AM
  5. Add Grand Total Legend to Pivot Chart
    By Gblack686 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-04-2016, 04:20 AM
  6. Excel 2010 Pivot Table Chart not doslaying Grand Total
    By dimi1963 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-27-2014, 06:15 AM
  7. How do I show the Grand Total on a Pivot Chart?
    By Scott_F in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-26-2005, 12:05 AM

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