Charting City & State

Hi!

So I have an excel sheet that I've created and it has Column A "Job Title"; Column B "City"; Column C "State".

My goal:

I want the graph to show we have this many of "BLANK" located in Ann Arbor, MI. - Just for example.

Is this possible? My data exceeds 1500 job titles, cities and states.

Please let me know!! Thank you

Show how?

My first-pass guess is that a pivot table would do the job for you.

Can you post an example spreadsheet with like 100 rows of data? Then other forumites could turn that around with examples.

Example Workbook.xlsxExample Workbook.xlsxExample Workbook.xlsx


Hi! Here is an example attachment.

Thank you!!

Alright, see the attached PivotTable + PivotChart; it's a bar chart with job titles as the x-axis and the count of job titles as the y-axis. Use the drop-downs in cells B1 and C1 to pick which combo states+cities you want to examine.

Wow! This is incredible! But how do you put it together? I'm sorry, because I literally am a novice to excel. So I don't have a CLUE how you just did that. I have an excel sheet that I would like to organize in the exact same way, but with SO much more data.

Well, stepwise what I did was:

1) Select the table-range that you want to work with (A1:C100 on the example tab),
2) Insert Ribbon => Tables Tab (farthest left) => Dropdown arrow under Pivot Tables Button => Pivot Chart
3) "Choose where you want the Pivot Table and Pivot Chart to be placed" => select "New Worksheet" radiobutton
4) In the Pivot Table Fields list, the pop-up dialogue on the right, from the "Choose Fields to add in Report" box:
4.1) Drag-and-drop "Job Title" into the "Axis Fields (Categories)" box
4.2) Drag-and-drop "Job Title" into the "Values" box
4.3) Drag-and-drop "Job State" into the "Report Filter" box
4.4) Drag-and-drop "Job City" into the "Report Filter" box
5) Re-size chart to be taller.

This was actually a pretty simple and straight-forward use of the powerful PivotTables tool, so I think it would be a good use to introduce you to them.

You can read more about Pivot Tables + Pivot Charts at:
Jon Peltier's using Pivot Tables and Pivot Charts
Microsoft Support's Create or delete a Pivot Table or Pivot Chart report
The excel-easy.com intro to pivot charts

That should give you plenty of guidance on Pivots.

This is great. You have been so helpful and I really appreciate it. This will do wonders for me!