Page 1 of 1
Microsoft Excel chart query
Posted: 19 Apr 2008, 15:26
by Louey
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???
Posted: 19 Apr 2008, 19:47
by Dan Wood
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!
Posted: 19 Apr 2008, 21:15
by Louey
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
Posted: 20 Apr 2008, 10:04
by ambivert
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.
Posted: 20 Apr 2008, 11:48
by Louey
Cheers Ambi, OK for us oldies to use functions like that but believe me a lot of year 7 (11 yr olds) would struggle.