Re: FN-FORUM: Simple Open Office calc or excel problem: I must be stupid

date posted 12th May 2008 18:01


----- Original Message -----
From: "Duncan Glendinning" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Monday, May 12, 2008 5:56 PM
Subject: FN-FORUM: Simple Open Office calc or excel problem: I must be
stupid


>
> Good afternoon guys...
>
> This just shows when the last time was that I used excel (or in my
> case open office calc).
> I have a column called invited? and each entry is a row in the table,
> with either a "yes" or a "no" in that particular column. I am simply
> trying to get it to draw a pie chart showing the split between the
> number of yes's and the number of no's. It just won't do it though, so
> I must be missing a trick here.
> Any ideas?
>
> Thanks,
> Duncan


I can't see an easy way to do this.

In the following example I have either a Yes or a No in column B, cells:
B1:B18

Add another column with the formula

=IF(B1="Yes";1;0)

where B1 is a reference to the column with Yes or No in it. This goes in
column C in my example and is then copied to all the other rows. It displays
a 0 for No and a 1 for a Yes

At the bottom of the table add more columns

=SUM(C1:C18)

- gives the sum of Yesses (the number of rows with a Yes)

=COUNT(C1:C18)-C20
- gives the sum of Nos. i.e. The count of all the rows minus the number of
Yes rows.

Where, C is the column with the IF formula in

C20 is the cell with the Yes sum in
C1:C18 is the range of cells containing the IF forumlas.


Select only the cells containing results (C20:C21) in my example
Insert, Chart, ...