+ Reply to Thread
Results 1 to 2 of 2

Pies of Pie chart

  1. #1
    Registered User
    Join Date
    08-03-2007
    Posts
    12

    Pies of Pie chart

    is this possible. I have this data

    Labels: 1 - 30, 31 - 60, 61 - 90, >90
    1: 10 100 5 1
    2: 15 40 10 5
    3: 20 30 5 0
    4: 30 50 3 0
    5: 40 80 20 4
    6: 50 90 9 10
    Total: 165 390 52 20

    I want to create a pie graph with 1-30, 31-60, 61-90, >90 as the 4 main categoris in the pie and the using the total amount have percentages shown in the pie (so 1-30 would be 26% of the pie, 31-60: 62%, 61-90: 8%, >90: 3%). Then for each 1-30, 31-60, 61-90, >90, i want to break that section out into its own pie and have 1-6 broken out as percentages. So the graph to break out 1-30 would have 6 inputs (1 = 10/165, 2 = 15/165, 320/165 and so on and 31-60 would have its own breakout pie and so on to >90.

    Is this possible and if so how do i go about doing this if it can be explained, that is if i even made sense

    Thanks
    Last edited by grant862; 05-12-2008 at 06:18 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,437
    Have a look at this article.
    http://pubs.logicalexpressions.com/P...cle.asp?ID=471

    About half way down is a section "Central Pie with Smaller Satellite Pies" which maybe something you could use.
    Cheers
    Andy
    www.andypope.info

+ 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