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.