To Debra Dalgleish: Re My Previous Post Concerning Bar Chart Problem,

[Robert11]

Hi again Debra:



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.



a. Can you explain, please what I am accomplishing when I do this ?



b. When you say "select any cell in the table," does it have to one inside
the grouping that I have filled in ?



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

-------------------





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.

Robert11 wrote:
> 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
> 5
> 50
> 15
> 75
> 22
> 100
> 14
> 150
> 4
> 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 ?
>

[Debra Dalgleish]

a. The chart wizard works best when creating some chart types if the top
left cell is blank. It seems to help it identify which columns contain
data, and which contain labels.

b. Not sure what you mean. In the table of chart data, select a cell
that contains data or label text.

c. Not sure what you mean here either.

Jon Peltier has lots of charting information on his web site, including
a charting tutorial that may help you:

http://www.peltiertech.com/Excel/ChartsHowTo/index.html

Robert11 wrote:
> Hi again Debra:
>
>
>
> 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.
>
>
>
> a. Can you explain, please what I am accomplishing when I do this ?
>
>
>
> b. When you say "select any cell in the table," does it have to one inside
> the grouping that I have filled in ?
>
>
>
> c. 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
>
> -------------------
>
>
>
>
>
> 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.
>
> Robert11 wrote:
>
>>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
>>5
>> 50
>>15
>> 75
>>22
>> 100
>>14
>> 150
>>4
>> 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 ?
>>
>
>
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html