Producing a summary in excel?

Question

I have a number of charts showing evaluation feedback. I need to create a summary of these as a whole. Is there any easy way to combine these or do I have to create a new workbook and re enter the data as a whole?

Answer 1

What I do when I have a lot of data from different sources is to create a new tab in the worksheet and just copy and paste the data over to it.  This way you can summarize all of the data.  You wouldn't have to re-enter it per se, but the copy/paste will take a little bit of effort.  

Answer 2

Depends on what you have done.

If your data is seperated into cells and your charts are extracting the data, Just produce a summary of the data and apply a chart.