Charting Help Needed

[unit213]

I need a pie chart that will show percent of violations disputed.
Within disputed, how many disputed violations were won.

Can this be done in one chart?

Here's a sample data set.

Chart.xls
	B	C	D	E
1	Total	Disputed	Won
2	1	0	0
3	1	0	0
4	1	0	0
5	1	0	0
6	1	1	1
7	1	1	1
8	1	1	1
9	1	1	0
10	1	1	0
11	1	1	0
12	1	1	1
13	1	1	1
14	1	0	0
15	1	0	0
16	1	0	0
17	1	0	0
18	1	1	1
19	1	0	0
20	1	1	1
21	1	1	0
22	20	11	7
Sheet1

 

[andy3816]

It sort of can but you have to condition the data a little,
Create two columns like this
Column A
Not Disputed
Disputed
Won
lost

Then in column B put the data relevant to the labels in column A

Then highlite the whole table and use the chart wizard to pick a Pie cart then a Pie of Pie.

This will create one large Pie on the left and a smaller pie on the right, double click on the pie itself and pick options to reformat the data series and labels to get the right categories in each pie.

I hope this helps I know it is not quite what you wanted