Pie of Pie help

  • Thread starter Thread starter cmcfalls
  • Start date Start date
C

cmcfalls

I would like to create a pie-of-pie chart based on more than one piece
What I mean is, lets say my main data contains 5 categories. I want
pie-of-pie based on the last 3 categories, splitting them all (treatig
them as one) into the cetegories that make up those areas.

I can only get a pie-of-pie based on 1 piece of the left pie and ca
add pieced to the right pie, but I want the right pie to be based o
more than 1 piece of the left.

Also, as an aside, can you create pie-of-pie-of-pie o
chart-of-chart-of-pie
 
It's not clear to me how you want to split three categories into more
than three categories. However, Andy Pope has some pie chart samples
that may help you.

http://www.andypope.info/charts/pies.htm

If not, maybe you can give an example of your data, and how you'd like
it displayed.
 
Ok, here's an example.

I work on a job with 10 "projects" (P1 through P10) and 3 "divisions
(D1-D3). 9 of these "projects" are charged to by only 1 of ou
"divisions" and 1 project is charged to by everyone (e.g., ONLY D
charges to P1-P3, ONLY D2 charges to P4-P6, and ONLY D3 charges t
P7-P9, while D1, D2, & D3 ALL charge to P10).

To further complicate, costs are made up of multiple elements (wages
overhead, burden, etc.).

What I want to do is split my job's costs by Project (which can als
double as divisional because of the charge structure) and then brea
the P10 costs up by D1, D2, & D3. THEN, I want to break up D3's cost
by the element (wages, overhead, burden, etc).

Does that clarify things
 
Back
Top