|
|
#5
01-21-2011, 03:29 PM
|
||||
|
||||
You can do this using a pivotchart.
If you make your column a table, the table will automatically expand if more data is added to it - you just have to refresh the pivot table. The great thing about this option is that the pivot table will automatically work out a unique list of states and their counts for you. Example attached. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Generate Folder | streng | Excel | 8 | 07-23-2025 11:13 PM |
| Generate tree structure, tool? | Troddel | PowerPoint | 0 | 10-13-2010 11:41 PM |
| text in 1 Org chart box will not print | mhinnes | Office | 0 | 08-05-2010 12:11 AM |
| Get list of text of a style | mavera2 | Word | 0 | 03-19-2010 01:59 AM |
| Fields controlled by List box values | farfromapro | Word | 0 | 02-11-2009 02:19 PM |
Generate chart from list of text values
Windows 7 32bit 
Office 2010 32bit
Threaded Mode