To Mr. Liengme: Re My previous Post Concerning My Bar Chart Problem

[Robert11]

Hello again Mr. Liengme,

I tried what you suggested, and it works just fine.

But, I really don't understand what, exactly, I am doing when
I do this cell deletion. And then "select that cell (B1) down to the last
and
across to C".

a. Can you explain, please what I am accomplishing when I do this ? What
happens or changes in the Formatting, or... ?

b. Also, I thought I would be clever and formatted one column as text.
This did not work. Why not ?

Thanks again; really appreciate your time and help/

Bob

-------------------------
Your x and y values are both numeric, so Excel plots both,
Fortunately, there is a quick solution.
At the top of the B column (lets say B1) you have a heading (Suggested
Yearly Dues); delete this and select that cell (B1) down to the last and
across to C. Now make the chart
best wishes
--
Bernard V Liengme

----------------------------------------
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.

Would be most appreciative for any help.

All I want to do is to create a very simple Bar (or perhaps it is actually
called a 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

25 5
50 15
75 22
100 18
150 8
200 2


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.
I selected columns B and C prior to plotting.

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

 

[Bernard Liengme]

It is just the way Excel works: when it sees a label at the top of a column
of numbers Excel assumes (sometimes rightly, other times wrongly) that it is
a data series rather than the category data.
best wishes