Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Falun
Borlänge
Stockholm
Uppsala
Borlänge
Stockholm
Stockholm

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.