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
Bookmarks