software

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 quot;select that cell (B1) down to the last
and
across to Cquot;.

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 quot;Suggested Yearly Dues, $quot; and in
Column C quot;No. Of Respondentsquot;.

So, it looks like this:

Suggested Yearly Dues, $ No. Of Respondents

25 5
50 15
75 22
100 18
150 8
200 2I 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

quot;Robert11quot; gt; wrote in message
...
gt; Hello again Mr. Liengme,
gt;
gt; I tried what you suggested, and it works just fine.
gt;
gt; But, I really don't understand what, exactly, I am doing when
gt; I do this cell deletion. And then quot;select that cell (B1) down to the
gt; last and
gt; across to Cquot;.
gt;
gt; a. Can you explain, please what I am accomplishing when I do this ? What
gt; happens or changes in the Formatting, or... ?
gt;
gt; b. Also, I thought I would be clever and formatted one column as text.
gt; This did not work. Why not ?
gt;
gt; Thanks again; really appreciate your time and help/
gt;
gt; Bob
gt;
gt; -------------------------
gt; Your x and y values are both numeric, so Excel plots both,
gt; Fortunately, there is a quick solution.
gt; At the top of the B column (lets say B1) you have a heading (Suggested
gt; Yearly Dues); delete this and select that cell (B1) down to the last and
gt; across to C. Now make the chart
gt; best wishes
gt; --
gt; Bernard V Liengme
gt;
gt; ----------------------------------------
gt; Hello,
gt;
gt; Boy, do I feel dumb in asking this, but, honest, I've been playing around
gt; with this
gt; for hours, and just can't get what I want. I'm new at Excel Charting, so
gt; let me blame it
gt; on that.
gt;
gt; Would be most appreciative for any help.
gt;
gt; All I want to do is to create a very simple Bar (or perhaps it is actually
gt; called a Column) type of chart from two columns of data.
gt;
gt; What I have in Column B is quot;Suggested Yearly Dues, $quot; and in
gt; Column C quot;No. Of Respondentsquot;.
gt;
gt; So, it looks like this:
gt;
gt; Suggested Yearly Dues, $ No. Of Respondents
gt;
gt; 25 5
gt; 50 15
gt; 75 22
gt; 100 18
gt; 150 8
gt; 200 2
gt;
gt;
gt; I would like on the X axis Suggested Yearly Dues, and then bars going
gt; vertically to show the number of respondents that selected that value.
gt;
gt; e.g. if one went along the X axis to $25, there would be a vertical bar
gt; going up to the Y value of 10 Respondents.
gt;
gt; But no matter what kind of bar or column chart I select, it seems to treat
gt; each column of data independently, and does not plot one against the
gt; other.
gt; I selected columns B and C prior to plotting.
gt;
gt; What am I doing wrong ?
gt; How do I do it correctly ?
gt;
gt;
gt;