Is there an easy way to create charts for individual rows in a spreadsheet and/or table?

I'm trying to compile and graph sales data for multiple locations over the latest 10 year period. The problem is that I need to save and present each individual graph separately, so the typical pivot chart won't help.

I need to graph individual sales numbers, as well as regional averages and averages based on size classifications (A,B,C,or D). I also need to update these numbers on an annual basis and have the charts update as well.

I have all of the data in a table format with the locations in rows and the yearly sales data in columns. I'm not very proficient with macros or VBAs.

Any suggestions?