software

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:
Clarification3
Info Not in OLR5
Navigation 2
Refer / Lookup1
Verification23Hi,

Enter the following data in cells A1:B6

A1: =Didn't UseB1: =91
A2: =ClarificationB2: =3
A3: =Info Not in OLRB3: =5
A4: =NavigationB4: =2
A5: =Refer/LookupB5: =1
A6: =VerificationB6: =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:
gt; I have to pieces of data, Used and Didn't Used - For the Used the data is
gt; broken down further. I want to use a Bar of Pie Chart, but don't know how to
gt; set it up. I have the Pie Chart Created but when I try to add the sub bar
gt; chart data it adds it to the pie, how do I add the data for the Bar chart.
gt;
gt; My data is as follows
gt;
gt; Didn't Use = 91
gt; Used = 34
gt; Used Broken Out:
gt; Clarification3
gt; Info Not in OLR5
gt; Navigation 2
gt; Refer / Lookup1
gt; Verification23
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Thanks that worked great.

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; Enter the following data in cells A1:B6
gt;
gt; A1: =Didn't UseB1: =91
gt; A2: =ClarificationB2: =3
gt; A3: =Info Not in OLRB3: =5
gt; A4: =NavigationB4: =2
gt; A5: =Refer/LookupB5: =1
gt; A6: =VerificationB6: =23
gt;
gt; Create a Bar of pie chart and the double click the pie.
gt; On the options tab set the Split series by: = Position
gt; and Second plot contains the last: = 5 values.
gt;
gt; This will give you a pie with 2 slices, the others slice is
gt; automatically calculated, and a stacked column of 5 items.
gt;
gt; Cheers
gt; Andy
gt;
gt; Lisa wrote:
gt; gt; I have to pieces of data, Used and Didn't Used - For the Used the data is
gt; gt; broken down further. I want to use a Bar of Pie Chart, but don't know how to
gt; gt; set it up. I have the Pie Chart Created but when I try to add the sub bar
gt; gt; chart data it adds it to the pie, how do I add the data for the Bar chart.
gt; gt;
gt; gt; My data is as follows
gt; gt;
gt; gt; Didn't Use = 91
gt; gt; Used = 34
gt; gt; Used Broken Out:
gt; gt; Clarification3
gt; gt; Info Not in OLR5
gt; gt; Navigation 2
gt; gt; Refer / Lookup1
gt; gt; Verification23
gt; gt;
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;