Summary Chart

M

Mike

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Location Impact On Links When Copying To New Workbook 1
Charting macro for creating multiple charts on multiple sheets 0
help on vba macro to put multiple charts on multiple worksheets based on table in each worksheet 0
Employee Schedule not plotting properly - chart type / data series not correct 0
Live data capture and charting speed 0
VBA - Hyperlink Function Combined with Find 6
Auto update the chart range for new sheets 2
Identifying copied charts on a worksheet 1

Top