+ Reply to Thread
Results 1 to 2 of 2

Showing two levels of data in pie chart

  1. #1
    Registered User
    Join Date
    04-06-2016
    Location
    UK
    MS-Off Ver
    MS Office 2010
    Posts
    4

    Showing two levels of data in pie chart

    Hi,

    I have two customers.
    I am doing multiple jobs for each customer.
    Each job has a different value.

    I would like to create a single pie chart in which the colored slices show the relative total income from each customer.
    Within each slice I would like subdivisions (just lines, no need to confuse with different colors) showing the contribution of each job to the total for each customer. This will also show the number of jobs for each customer as a consequence.

    As a simple example;
    Total income (whole pie chart) - $100,000
    of which
    Customer A (red slice) - $75,000
    Customer B - (blue slice) - $25,000
    of which
    Customer A's orders are composed of 3 jobs at $10,000, 1 job at $40,000 and 2 jobs at $2,500.
    Customer B's orders are 2 jobs at $12,500

    It is the last part of this that I can't work out how to do. Its driving me crazy, it feels like it should be simple to put dividing lines onto each slice.
    I do not really want to use a pie of pie chart, I have tried playing around with Pivot Charts and sunburst charts (I'm using Excel 2016) to no avail.
    Any help HUGELY appreciated.
    Thanks in advance.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Showing two levels of data in pie chart

    Hi,

    You could simply plot all 5 jobs and colour the A ones red, and the B ones blue.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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] Chart not showing all data
    By dave1983 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 10-05-2021, 12:20 AM
  2. [SOLVED] Dont want zero data showing in bar chart
    By scudo in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-01-2016, 11:47 AM
  3. [SOLVED] Line Chart Axis showing 260 instead of 100 - all data is under 100???
    By CHillFL in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-05-2016, 02:00 PM
  4. Replies: 3
    Last Post: 07-30-2014, 01:39 PM
  5. Help with a chart showing 2 types and sets of data
    By capricorn77 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-04-2010, 12:34 PM
  6. chart issues not showing the right data
    By cardenmf in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-03-2008, 01:42 PM
  7. [SOLVED] Data not showing on my chart
    By kalyhan in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-03-2005, 06:06 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