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

  • Thread starter Thread starter yefei
  • Start date Start date
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!
 
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
 
Back
Top