Small Excel Project Report

I have a report that I run using a ACD call system for the Help Desk. Attached to this is the raw data which is pulled from the ACD report. I need to get this data in a chart for each of them. I would like but know if it can be done, to have all of the stats for each of them on ONE chart to basically show a trend etc. I want to be able to update this chart weekly by just copying over the same data in the spreadsheet and hitting the refresh button. So I assume that would be a macro of some sort?