Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / January 2004

Tip: Looking for answers? Try searching our database.

words as data for formula or chart

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andy_CYXU - 03 Jan 2004 04:52 GMT
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
Debra Dalgleish - 03 Jan 2004 14:27 GMT
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 Data>PivotTable 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.

> How can i crate a chart that would use words as data so
> basically the charts formula would count words in column
[quoted text clipped - 9 lines]
> the most of these words ets...
> Is it possible?

Signature

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

Andy_CYXU - 04 Jan 2004 04:22 GMT
Thank You !

It worked !

Andy
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.