software

I am working on a large spreadsheet file, I have 23 columns where the
cells within may be either A,B,C,D,E, or blank. I need a way to count
this and put it into a pie chart or bar graph. I can't figure it out,
help please?--
riomarde
------------------------------------------------------------------------
riomarde's Profile: www.excelforum.com/member.php...oamp;userid=32882
View this thread: www.excelforum.com/showthread...hreadid=526853Riomarde --
I would:

1) Define a named range for the table. For our purposes here, I call it
quot;testquot;.
2) Count the letters like this:
A B
1 a =countif(test,a1)
2 b =countif(test,a2)

etc. Then, you can use the data for a pie chart.

Another approach -- if you have activated the 'data analysis tookpak', you
can use it to make a histogram in roughly the same way.

HTH.

quot;riomardequot; wrote:

gt;
gt; I am working on a large spreadsheet file, I have 23 columns where the
gt; cells within may be either A,B,C,D,E, or blank. I need a way to count
gt; this and put it into a pie chart or bar graph. I can't figure it out,
gt; help please?
gt;
gt;
gt; --
gt; riomarde
gt; ------------------------------------------------------------------------
gt; riomarde's Profile: www.excelforum.com/member.php...oamp;userid=32882
gt; View this thread: www.excelforum.com/showthread...hreadid=526853
gt;
gt;