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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
words as data for formula or chart
Thank You !
It worked ! Andy |
Thread Tools | |
Display Modes | |
|
|