Help with a chart with lots of data

Hello. I am currently working on a chart in excel for a psychology project in school. I had to get six people to fill out a paper with several different personality choices that they felt fit me best. They each picked 20 of the list, and I have to talley them up. I want to show them in a bar chart so that they are easily viewable in my report, and have been working at it for two days to get to the point I am at.

So, what I have is 2 columns to the left of my chart. In the "A" column, I have the word that is being counted, and in the "B" column adjacent to that word, I have that cell set up to count the number of instances the word appears in a results chart I made on another worksheet tab. I used the COUNT IF function in order to get my results, which worked well. EX: Cell A1 I have the text word "considerate". The formula in cell B1 is as follows: =COUNTIF(Sheet1!$A$6:$G$25,"suspicious") which gives me my results, going down a cell for each word, a total of 58 cells in each column. I then applied them to a bar graph as shown below. The chart shown below in this picture is the chart I need help with.

\1

My information came from this table below:

\1

Of course, because there is so much data, I need the chart to fit the entire page. I wanted a beautiful, interesting 3D bar chart to display, but unfortunately I do not know whether or not if it's going to actually be effective that way. 2D might be better and I may have to simplify and I am open to suggestions. I would like to keep this sort of color theme because it is matching with colors I have set up for my report in Word.

I was wondering if there was also a way that I could possibly separate this data...like imposing a line chart displaying the smaller amount of hits, like 3 and under, then the bar chart could display the larger amount of hits. I saw there's a way to do so by separating axes somehow but it has been next to impossible for me to find information that can show me how to accomplish this in a manner to which I can comprehend. I am willing to post whatever information it may be that anyone needs in order to help me...I have been working at this chart for two days now and I am so frustrated that I would appreciate any help at all.

Thank you very much.

Thank you for the link. I looked over what he had, and I think that I will most likely stick with the format of what I have so far.

Thanks also for the simplification regarding the COUNT IF. I am wondering if at this point, it would be best for me to simply make the chart the full printable size on the paper. Is there a way for me to hide the previous two columns, or just put that chart onto another worksheet, then blow it up to full size to print?

I have managed to find information on how to move/copy my table onto another worksheet by itself. I am now trying to change the size of the table so that it fills the entire print area, i.e. make the table as big as possible. Does anyone know how I can do this without just dragging the box size?

Oh, thank you. I will give that a try. I know how to set a print area so that should be easy for me. I will then go to page setup to control the size...is there a magnification option there that you are talking about when it comes to changing the size? I hope I am not being too frustrating...I know how that can be sometimes when you're trying to help.