+ 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
    7,860

    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)

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