Need some complicated help with MS excel?

Question

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

Answer 1

you would be wise to ask this question in a excel user group forum.... goto the websites below and join the forums

try the links below,