Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a sheet that contains lots of information about jobs in a company. One of the columns is "city". That column contains values as such


Now i'd like to use this data and visualize it using a chart. However, the data is "ungrouped". What i'd actually like the charts to present, is the number of occurencies of each city. How can i accomplish this?

share|improve this question
up vote 2 down vote accepted

Create a "PivotChart" - and simply draw the "City" field both - to the x-Axis and to the data field. The Pivot table will automatically count the number of occurrences.

share|improve this answer
That's awesome, thank you. I tried using the "regular" chart tools... Is it possible to tell the pivotchart to use the same data filters as i apply to the source data? – Anton Gildebrand Mar 31 '13 at 22:29
Almost. You cannot link the filter - however, you can apply the same filter settings by dragging the fields to be filtered to the filter section of the pivot and then filter accordingly! – Peter Albert Mar 31 '13 at 22:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.