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

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 ?

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Robert11" <rgsros@notme.com> wrote in message
news:HMidnaCL0-QQd7zZRVn-ig@comcast.com...
> 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 ?
>
>
>