I have to pieces of data, Used and Didn't Used - For the Used the data is
broken down further. I want to use a Bar of Pie Chart, but don't know how to
set it up. I have the Pie Chart Created but when I try to add the sub bar
chart data it adds it to the pie, how do I add the data for the Bar chart.

My data is as follows

Didn't Use = 91
Used = 34
Used Broken Out:
Clarification 3
Info Not in OLR 5
Navigation 2
Refer / Lookup 1
Verification 23

Hi,

Enter the following data in cells A1:B6

A1: =Didn't Use B1: =91
A2: =Clarification B2: =3
A3: =Info Not in OLR B3: =5
A4: =Navigation B4: =2
A5: =Refer/Lookup B5: =1
A6: =Verification B6: =23

Create a Bar of pie chart and the double click the pie.
On the options tab set the Split series by: = Position
and Second plot contains the last: = 5 values.

This will give you a pie with 2 slices, the others slice is
automatically calculated, and a stacked column of 5 items.

Cheers
Andy

Lisa wrote:
I have to pieces of data, Used and Didn't Used - For the Used the data is
broken down further. I want to use a Bar of Pie Chart, but don't know how to
set it up. I have the Pie Chart Created but when I try to add the sub bar
chart data it adds it to the pie, how do I add the data for the Bar chart.

My data is as follows

Didn't Use = 91
Used = 34
Used Broken Out:
Clarification 3
Info Not in OLR 5
Navigation 2
Refer / Lookup 1
Verification 23


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks that worked great.

"Andy Pope" wrote:

Hi,

Enter the following data in cells A1:B6

A1: =Didn't Use B1: =91
A2: =Clarification B2: =3
A3: =Info Not in OLR B3: =5
A4: =Navigation B4: =2
A5: =Refer/Lookup B5: =1
A6: =Verification B6: =23

Create a Bar of pie chart and the double click the pie.
On the options tab set the Split series by: = Position
and Second plot contains the last: = 5 values.

This will give you a pie with 2 slices, the others slice is
automatically calculated, and a stacked column of 5 items.

Cheers
Andy

Lisa wrote:
I have to pieces of data, Used and Didn't Used - For the Used the data is
broken down further. I want to use a Bar of Pie Chart, but don't know how to
set it up. I have the Pie Chart Created but when I try to add the sub bar
chart data it adds it to the pie, how do I add the data for the Bar chart.

My data is as follows

Didn't Use = 91
Used = 34
Used Broken Out:
Clarification 3
Info Not in OLR 5
Navigation 2
Refer / Lookup 1
Verification 23


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info