+ Reply to Thread
Results 1 to 2 of 2

Creating pie in pie charts

  1. #1
    Forum Contributor
    Join Date
    04-30-2008
    Posts
    105

    Creating pie in pie charts

    I'm trying to create a pie in pie chart. The main pie chart is supposed to break out the grand total of orders, revenue, and profit for the year. Each of these three categories is then supposed to be split into three separate secondary pie charts.

    In these secondary pie charts, it must break out how much each of the six employees contributed to orders, revenue, and profit.

    So basically this chart will have a primary pie chart summarizing grand totals of orders, rev, and profit. For orders, it will have a secondary pie chart showing how much of the total orders each of the six employees contributed, for revenue it will have its own secondary pie chart that will do the same, same goes for profit.

    I'm not sure how to go about doing this. I attached a table showing what my spreadsheet looks like thus far. Thanks in advance for the help!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075
    This article might help:
    http://pubs.logicalexpressions.com/P...cle.asp?ID=471
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ 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