Results 1 to 4 of 4

Multiple pie-in-pie charts

This is a discussion on Multiple pie-in-pie charts within the Excel Questions forums, part of the Question Forums category; Was wondering if possible to create multiple pies for pie-in-pie chart? For example if I have a pie broken into ...

  1. #1
    Board Regular
    Join Date
    Feb 2004
    Location
    Arlington, VA
    Posts
    56

    Default Multiple pie-in-pie charts

    Was wondering if possible to create multiple pies for pie-in-pie chart? For example if I have a pie broken into 3 items, can you create a pie for each item?

  2. #2
    MrExcel MVP
    Join Date
    May 2002
    Posts
    13,993

    Default

    don't use pie charts much, but see if the techniques outlinedhere:

    http://www.andypope.info/charts/pies.htm

    ...might point to a solution. post back if not & we'll work it out

  3. #3
    Board Regular
    Join Date
    Feb 2004
    Location
    Arlington, VA
    Posts
    56

    Default Re: Multiple pie-in-pie charts

    Nah, that wasn't what I was looking for. Say for instance, you have a pie broken into 3 sections: A, B, and C. I was wondering if it was possible to have (on the same page) smaller pie charts (or even bar charts) breaking down what A, B, and C consist of. I've seen bar-in-pie and pie-in-pie charts where one item of the pie is broken down into sections but was wondering if more than one, or all sections of the pie could have their own smaller pie (or bar) charts extending out from the primary, larger pie. Say, for instance, you have a pie chart giving you the percentages of Americans that are Democrat, Republican, or Other. Was wondering if, from that pie chart, you can have smaller pie (or bar) charts extending out from each section of the larger pie chart giving you, say for the Democrat section of the pie, the percentages of Democrats that are Christian, Jewish, Muslim, etc. and for the Republican section, a completely different chart giving you the percentages of Republicans that are male or female. Was wondering if it was possible to have this all on one page... any help is appreciated!

  4. #4
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    3,781

    Default Re: Multiple pie-in-pie charts

    Just make yourself a bunch of pie charts, resize them, and arrange them around each other. If you need them on a single chart sheet, make a chart sheet with the central pie, then make the other pies, right click on each, choose Location from the pop up menu, and choose As Object In, and pick the chart sheet as the parent sheet.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    http://PeltierTech.com/Excel/Charts/
    _______

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com