A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

words as data for formula or chart



 
 
Thread Tools Display Modes
  #1  
Old January 3rd, 2004, 05:52 AM
Andy_CYXU
external usenet poster
 
Posts: n/a
Default words as data for formula or chart

How can i crate a chart that would use words as data so
basically the charts formula would count words in column
to output value for example:

I have a column where there are words: YES, NO, MAYBE
etc... (all in one column)

and I like on the chart to show that there are so many
words YES, so many words NO, so many words MAYBE etc...
in that column..
It could show a bar besically the longest means there is
the most of these words ets...
Is it possible?

Thanks


  #2  
Old January 3rd, 2004, 03:27 PM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default words as data for formula or chart

You can create a pivot table from the list, to get a quick summary of
the data:

Add a heading to the top of the list (e.g. Response)
Select a cell in the list
Choose DataPivotTable and PivotChart Report
Click Next, select the cells with data, click Next
Click Layout
Drag the Response button to the row area
Drag another copy of the Response button to the Data area,
where it will become Count of Response
Click Next, choose a location for the Pivot Table, click Finish
Then, click the Chart Wizard button, to create a PivotChart
from the PivotTable.


Andy_CYXU wrote:
How can i crate a chart that would use words as data so
basically the charts formula would count words in column
to output value for example:

I have a column where there are words: YES, NO, MAYBE
etc... (all in one column)

and I like on the chart to show that there are so many
words YES, so many words NO, so many words MAYBE etc...
in that column..
It could show a bar besically the longest means there is
the most of these words ets...
Is it possible?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

  #3  
Old January 4th, 2004, 05:22 AM
Andy_CYXU
external usenet poster
 
Posts: n/a
Default words as data for formula or chart

Thank You !

It worked !

Andy
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:34 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.