I'm working on a survey, i have the following data:

columns of counties in CA
Rows listing which city each person came from

IE:
Stanislaus Co. Merced Co.
Modesto Atwater
Modesto Merced
Turlock Merced

there's maybe 10 counties

I need a chart where there's a bar for each county and then that bar is broken up by how many from each city. is that possible in anyway? Maybe using pivot or something?? It's confusing me because there are different cities in each county. If it's not possible is there anyway i can get both the cities and the counties on one grpah and have it look good?

Thanks