LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
yefei
 
Posts: n/a
Default how to create a chart based on the content of a column

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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create chart from series grouped by value in another column HarCo Charts and Charting in Excel 2 August 28th 05 01:53 AM
Format cell in column B based on value in the next cell (column c) Nicole Excel Discussion (Misc queries) 7 May 18th 05 10:19 PM
Column Chart Hans Knudsen Charts and Charting in Excel 1 May 6th 05 01:35 PM
To create a stacked column chart and group the stacked bars togeth Jacqueline Charts and Charting in Excel 1 February 17th 05 11:05 PM
How to create chart with 1 column and 3 lines agenda9533 Charts and Charting in Excel 1 January 28th 05 02:12 PM


All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"