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

date posted 13th May 2008 16:39

Use countif
=countif(range_invited,"yes") and =countif(range_invited,"no"), add
headings and chart those 4 cells.

--
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Kathy
http://www.vendetta.co.uk
+44(0)7005 982 261
DNRC Minister for Useful but Irritating Information and Trivia
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

----- 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
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>