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
>