Microsoft Excel chart query

Post by **Louey** » 19 Apr 2008, 15:26

A bit off normal topic I know

If I've got a column of data containing YES and NO answers. How do I create a chart from it without having to create a COUNTIF statement???

Post by **Dan Wood** » 19 Apr 2008, 19:47

I've been using Excel for years, and COUNTIF is the way I do it too!

You would have thought that you could do it easily in the newer versions, but I've never really looked. I 'cut my teeth' on Excel 97, so I still use all the tricks I had to with that...

COUNTIF doesn't take too long to do, luckily!

Post by **Louey** » 19 Apr 2008, 21:15

Cheers Dan

I've worked out how to do it using Pivot tables/chart BUT its a bit too complex along with COUNIFs for 11 yr old kids - a few will get the idea but it will over the head of most

Post by **ambivert** » 20 Apr 2008, 10:04

The simplest way is to put the YES and NO's into separate columns.
Then you can use COUNTA on each column - it counts the non-blank cells.

TIP: the quickest way to separate YES/NO column into 2 is to copy the column and then do a Find & Replace on each column to remove the YES from one the NO from the other.

Post by **Louey** » 20 Apr 2008, 11:48

Cheers Ambi, OK for us oldies to use functions like that but believe me a lot of year 7 (11 yr olds) would struggle.