Summary Chart

Hello, was hoping to find a solution for the following scenerio or the best
chart and process for:

1) Have 6 columns with survey results - the headers are (PQ, PA, PR, SP, DT,
CI).
2) The data rows under the headers are numbers from 1 - 6 (basically a
rating).

I am attempting to show a summary chart for each worksheets (each worksheet
has survey results from a particular location).

So I will create a chart in each worksheet for each location, and then one
worksheet will be a summary chart of all the other worksheets/locations
combined

Any idea how to do the chart inside each worksheet for each location and
also for all worksheets combined?