+ Reply to Thread
Results 1 to 3 of 3

Pivot pie chart work % of total of company and total profit

  1. #1
    Forum Contributor
    Join Date
    09-02-2014
    Location
    England
    MS-Off Ver
    2013
    Posts
    116

    Pivot pie chart work % of total of company and total profit

    Hi
    Im trying to create a pie chart from a pivot table that shows the following

    There are two companies SEL & TSTHS each has three workers in each. Im trying to to find out

    Worker % of profit from each company total in each tax year
    Worker % of profit from overall total (both companies) in each tax year

    Can anyone show me how

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-02-2014
    Location
    England
    MS-Off Ver
    2013
    Posts
    116

    Re: Pivot pie chart work % of total of company and total profit

    Hi
    Can anyone help with the above?

    Thanks
    Dave

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    15,076

    Re: Pivot pie chart work % of total of company and total profit

    If I understand correctly then one way would be to produce two pivot tables.
    The first is populated as in the file attached to post #1 and the second (modeled on the PIVOT2 sheet) excludes 'company' from the legend field.
    The data labels on each pie chart are formatted to display category name and percentage.
    Use the filters at the bottom of either pie chart to display the tax year.
    There is also a company filter at the bottom of the pie chart on the PIVOT sheet.
    Let us know if you have any questions.
    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. How to add a profit margin to a total?
    By scottc72 in forum Excel General
    Replies: 7
    Last Post: 08-22-2017, 09:41 PM
  2. Replies: 6
    Last Post: 06-24-2016, 12:40 PM
  3. Pivot Table Total doesn't match data total
    By CNL.Excel in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-31-2013, 07:40 PM
  4. how to work out rate based on total time and total amount
    By lisaathers in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2013, 06:44 AM
  5. Pivot Chart Running Total - Removing Current Year Future Total
    By car3489 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-27-2013, 03:35 AM
  6. Replies: 0
    Last Post: 02-07-2013, 08:42 PM
  7. [SOLVED] Pivot Tables - Calc % using Sub-Total, not Grand Total as base
    By sandi in forum Excel General
    Replies: 1
    Last Post: 12-19-2005, 05:59 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