+ Reply to Thread
Results 1 to 4 of 4

Pie of Pie Help

  1. #1
    Registered User
    Join Date
    06-19-2012
    Location
    Belfast
    MS-Off Ver
    Excel 2013
    Posts
    21

    Pie of Pie Help

    Basically I am looking as to how I would write the data into excel in order to make a pie of pie chart, no way I have tried has currently been successful.

    I want the primary pie to be Yes = 32 and No = 11

    Secondary pie I want to be a breakdown of Yes where:

    U= 16
    V = 8
    W = 6
    X = 3
    Y =2
    Z = 1

    note: the totals of U, V, W, X, Y and Z are more than the 32 of yes as more than one option was allowed to be picked, im not sure if that is where the difficulty lies.

    Any help would be greatly appreciated

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Pie of Pie Help

    you can't do that without rescaling the data so that the sub-pie adds up to its parent slice.
    btw, pie charts are generally bad at representing information (the human brain is not well equipped to work with the relationships involved) and one of the few things worse than a pie chart is a pie of pie. ;-)
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Rocester, New York, USA
    MS-Off Ver
    Excel 2007:10
    Posts
    2,019

    Re: Pie of Pie Help

    Two points.

    1) We cast a suspicious eye upon pie charts around here. Could you do like a column chart instead???

    2) "No way you have tried is successful"... did you try the official instructions for creating a pie-of-pie chart? That's basically how I was going to tell you to do it, only more completely written out.

    EDIT: BTW those instructions are for Excel 2003. I dunno what kind of support Excel 2010 has for pie charts.

  4. #4
    Registered User
    Join Date
    06-19-2012
    Location
    Belfast
    MS-Off Ver
    Excel 2013
    Posts
    21

    Re: Pie of Pie Help

    Ok, thats fine. I may go for a stacked bar instead. Thanks for the help anyway

+ 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