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?
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 --
I would:
1) Define a named range for the table. For our purposes here, I call it
"test".
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.
"riomarde" wrote:
>
> 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: http://www.excelforum.com/member.php...o&userid=32882
> View this thread: http://www.excelforum.com/showthread...hreadid=526853
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks