Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
To Mr. Liengme: Re My previous Post Concerning My Bar Chart Problem
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" wrote in message ... 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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Problem | Excel Discussion (Misc queries) | |||
Chart problem: values in column A don't show as labels on x-axis | Excel Discussion (Misc queries) | |||
Excel chart problem | Excel Worksheet Functions | |||
Chart and Data Problem | Charts and Charting in Excel | |||
Problem with Chart Title Formatting | Charts and Charting in Excel |