how to create a chart based on the content of a column

Y

yefei

for example, i have a column
A1
strongly agree
agree
strongly disagree
neutral
agree
disagree
strongly agree

i need a present in a chart, how many "strongly agree", how many
"disagree", etc, based on how many occurance of them in the column, and
use the "strongly agree", "Disagree"...as the label.

what is the most suitable chart type, and how to set the labels?
and most important, how to get the counts?

as i am not very experienced in Excel, hope someone can save me!
 
N

NAVEEN

Hi,

Assuming your data is in "Sheet1!$A$1:$A$100", type the following two
columns of data in another sheet.

strongly agree =COUNTIF(Sheet1!$A$1:$A$100,Sheet2!A1)
agree =COUNTIF(Sheet1!$A$1:$A$100,Sheet2!A2)
neutral =COUNTIF(Sheet1!$A$1:$A$100,Sheet2!A3)
disagree =COUNTIF(Sheet1!$A$1:$A$100,Sheet2!A4)
strongly agree =COUNTIF(Sheet1!$A$1:$A$100,Sheet2!A5)


Select the above (two columns and five rows i.e., if it starts from A1, it
is A1:B5) and click on Graph button, which you can find it in standard tool
bar.

Regards,
NAVEEN
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I give a numerical value to a radio button? 4
Possible? Variable X and Y data sources and Auto Charting 0
Create a chart from a table in word thats dynamic 0
Creating a single bar chart showing proportional survey results 2
How can i see changes in answers from a pre test to a post test? 1
How to add up text record in the field of a report 3
Stacked bar chart for survey results (agree/disagree) 1
Automation of scanned file storage based on content 0

Top