ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can I graph the #of times a certain word is found in Excel? (https://www.excelbanter.com/charts-charting-excel/189041-how-can-i-graph-times-certain-word-found-excel.html)

STP

How can I graph the #of times a certain word is found in Excel?
 
For example I have a list of reasons of what brand of butter a group of
customers choose to buy.... How can I take the number of times "I can't
believe it's not butter" is listed as compared to "Brommel and Brown", etc.
and graph them accordingly onto one graph so if I have 512 occurances where
customers chose "I can't believe it's not butter" and 256 occurances where
customers chose "Brommel and Brown" - then I would like the graph is twice as
large for the "I can't believe it's not butter".

Dave Curtis

How can I graph the #of times a certain word is found in Excel?
 
Hi,

Just put in an extra column to count the number of times each one occurs and
plot a column chart appropriately, otr simply do a pivot table.

Dave

url:http://www.ureader.com/msg/10296106.aspx


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com