Multiple Charts
 

I need to make multiple charts in Excel from an Access query. I have no
problem converting the query to an Excel worksheet. It looks something like
this:

Location/Month/Job Title/Compliance Rate

Where each line is a different location. I need to create a chart for each
location and for each chart to be on a separate worksheet. Is there a quick
way to do this. Currently, I am making two copies of the full worksheet,
then using the second one to make the charts as I slowly make a chart from
one line, erase that line, then make a chart from the new first line. Over
and over again.

Help, please.