Problems with Pie Charts

  • Thread starter Thread starter NACHO
  • Start date Start date
N

NACHO

I have a long column (about 1000 cells) in my excel spreadsheet which
consists of Y (yes) and N (values). When I try to create a pie chart
telling me what percentage of N values are and how many values of Y
are I get a wrong chart, I do not know how to do this since I do not
want to count manually how many Y valuse and X values are in order to
do it that way. Is there a way by selecting a the whole column to do
this?
thanks
 
Hi

Try making use of Excel function =COUNTIF(RANGE,CIRTERIA)
to find out the number of Y and N, base on these results
to create a pie-chart.
 
I get a value of 0 when trying this =countif(range,criteria) am I
doing it right by range being my complete column and criteria being Y?
thanks
 
Back
Top