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?