Need to create a pie chart

  • Thread starter Thread starter carolinagirl
  • Start date Start date
C

carolinagirl

I need to create a pie chart, and I am running into some problems. I
has been a long time since I have last done this, and was hoping tha
someone could help me.

I have a column named COMPLETED.
I this column it either has a Y or N.

I need to have a Pie chart so that it shows the % of Completed Y and
of Completed N.

I am having some problems coming up with how to set this up. I hav
tried the Chart Wizard, however I am just too confussed.

PLEASE HELP!!!!!!:confused
 
If your data are in A2:A100 (with A1 as a header), then in some empty
range, say, C2:D3 do the following:

In C2 enter Y
In C3 enter N
In D2 enter the formula =COUNTIF(A2:A100,C2)
Copy D2 to D3.

Select C2:D3. Use the Chart Wizard to create a pie chart.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top