+ Reply to Thread
Results 1 to 2 of 2

Graphical representation of multi-level data (pie of pie of pie)

  1. #1
    Registered User
    Join Date
    06-16-2014
    Location
    columbus, ohio, usa
    MS-Off Ver
    2010
    Posts
    2

    Graphical representation of multi-level data (pie of pie of pie)

    Hi, all…first post!

    I’ve searched (and searched, and searched), but can’t seem to find exactly what I’m looking for. Apologies if I've missed it.

    I have a series of hierarchical data that I’d like to represent graphically.

    Conceptually, it looks like this (with pretend percentages):

    -A represents 100%
    --Of A, 10% is B and 90% is C
    ---Of C, 20% is D and 80% is E
    ----Of E, 30% is F and 70% is G
    -----Of G, 40% is H and 60% is I

    In plain English, something like, “I have 100 A. Of those, 90% are C. Of those, 80% are E. Of those, 70% are G. Of those, 60% are I”.

    I thought that a multi-level exploded pie charts would be perfect (even if the sizes aren’t accurate). But, I’m having trouble creating it. I’ve tried various combinations of Pie of Pie and Bar of Bar charts, but they don’t allow multi-level nesting. The cascading pie charts on this page are similar to what I envision: http://chandoo.org/wp/2012/11/09/pie...-of-pie-chart/

    I’ve even thought about simply having dynamically-sized shapes (like circles within circles) based on the percentage values (Circle A is 100%, circle C is 90% of A, circle E is 80% of C, and so on…).

    But, I’m posting here, because thus far, I’ve failed.

    Any advice or help is appreciated. Thanks!

  2. #2
    Registered User
    Join Date
    06-16-2014
    Location
    columbus, ohio, usa
    MS-Off Ver
    2010
    Posts
    2

    Re: Graphical representation of multi-level data (pie of pie of pie)

    I put this together to show what one possible visualization might look like. Ideally, each pie size would be scaled to accurately show that it represents a subset of the previous pie.

    Thoughts? Should I pursue this way, or present the data in a different way, entirely? Thanks!
    Attached Images Attached Images

+ 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. Datewise graphical representation
    By durga_ikon in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-14-2014, 01:14 AM
  2. Bill of Materials conversion from multi level to single level
    By susmitpatel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-11-2013, 12:53 AM
  3. Graphical representation through line graphs
    By excelvba123 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-25-2013, 08:11 PM
  4. Graphical Representation
    By cityinday in forum Excel General
    Replies: 4
    Last Post: 03-19-2006, 12:44 AM
  5. Using macro to convert single level BOM to Multi Level BOM
    By andrew_chong in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2006, 04:57 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