+ 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