Help Setting up Bar of Pie Graph

[AC5FF]

I need to come up with a way to display a bunch of data so that it's easily understandable... I think the best way to display what I want to is to use a 'Bar of Pie' chart in Excel. I just can't seem to get things to work ... Everytime I try to edit or add series information things just don't work out like I am expecting them to.

I've tried to search online for some good setup examples, but nothing seems to make sense to me..

For Example, here is an example of data that I have:

Serviced Parts: 118
Condemned Parts: 38
Contracted Parts: 45
Contracted Met: 41
Contracted Repaired: 67

Now these values are coming from different areas in a huge spreadsheet, but I don't see where that should matter... The data for the graph will be in those same cells each month, so the chart will update on its own.

What I have envisioned is a main Pie chart that consists of Serviced Parts and Condemned Parts. The Serviced Parts would be broken down into two sections - contracted and non contracted. So, in this example the main pie chart would be approx 25% red, and 75% green; but the green area broken down into two sections approx 60/40 (Contracted/Non Contracted).

Then, out of the contracted section of the main Pie chart it would display to the right side the bar chart showing 41 as 90% of the full bar of 45.

I hope that makes sense...
It dang confusing to try and explain it. LoL

 

[Brianwarnock]

What I have envisioned is a main Pie chart that consists of Serviced Parts and Condemned Parts. The Serviced Parts would be broken down into two sections - contracted and non contracted. So, in this example the main pie chart would be approx 25% red, and 75% green; but the green area broken down into two sections approx 60/40 (Contracted/Non Contracted).

It would help, well me anyway, if you explained your figures and colours, I'm to thick to work them out.

brian

 

[Access_guy49]

What about a stacked Column? would that be esier to read?
It's basically the same thing minus the pie?

If not then i'm perhaps not understanding the problem your having with your current bar/pie chart.
Perhaps an example attachment?

 

[AC5FF]

Can't 'legally' attach the actual spreadsheet. Not to mention it is way over size limitations But in essence what I have in the first post is the data i need to disply.

Color explinations (Data values): Main PIE chart is going to be Red (38) and Green (67 and 51)
The Greed (67) is going to break down into a stacked bar. For this month's data 100% value would be 45 with 90% of that (for 41 parts) would be red.

I had a combination chart set up w/ stacked bar columns w/a line graph that would show a 12 month history. The stacked bars were Contracted and Contracted Repaired values. The line graph was the percentage of contracted/contracted met.

In my mind (as well as everyone else involved in the process) the current chart I have makes perfect sense. However, someone in upper management thinks it is too 'busy' and has asked us to change it. So I am stuck with trying to show all the above information in my first post, but in one concise and easy to read graph. No longer showing a 12 month history. So... I guess I'm open to suggestions. The Bar and Pie chart seemed to me an easy way to display what I wanted to. But if ya all have better ideas I'm open to em!

 

[chergh]

Do you mean something like this?

 

[AC5FF]

That is very close to what I am looking for...
I think some numbers are wrong, but I can deal with that. I added another graph below yours in the example. This is as close as I have been able to get things to display, but here is the problem as well. Look at my graph. The main PIE chart shows 4 sections. I need it to only have 3. Then the bar graph at the right won't be percentages, instead they need to be numbers. In this situation, they would be 42 and 41. But notice how it's drawing out of the one section of the PIE chart? In my situation I would want that side bar chart to be linked with the total produced section (67)...