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.
|