Simple Bar Chart Question

[Robert11]

Hello,

Boy, do I feel dumb in asking this, but, honest, I've been playing around
with this for hours, and just can't get what I want. I'm new at Excel
Charting, so
let me blame it on that. Tried in the Charting Group, but haven't received
any answer.
Using Excel 97 SR-1

Would be most appreciative for any help.

All I want to do is to create a very simple Column type of chart from two
columns of data.

What I have in Column B is "Suggested Yearly Dues, $" and in Column C
"No. Of Respondents".

So, it looks like this:

Suggested Yearly Dues, $ No. Of Respondents

0
2
25
10
50
12
75
22
100
7
150
2
200
1

I would like on the X axis Suggested Yearly Dues, and then bars going
vertically to show the number of respondents that selected that value.

e.g. if one went along the X axis to $25, there would be a vertical bar
going up to the Y value of 10 Respondents.

But no matter what kind of bar or column chart I select, it seems to treat
each column of data independently, and does not plot one against the other
which is
what I want.

I selected columns B and C prior to plotting.

What am I doing wrong ?
How do I do it correctly ?

Much thanks; really appreciate it.

Bob

 

[Debra Dalgleish]

The simplest way to create the chart is to temporarily remove the
heading that's in cell B1.

Then, select any cell in the table, and run the Chart Wizard, to create
a Column Chart, selecting the Clustered Column chart sub-type.