Chart question please help
 

I currently have a worksheet where I pull the data in from the
existing connections to several Access queries.

I then have to copy and paste the query information below to
reorganize it and then use the chart wizard to create the chart.

Then, I have to use text boxes to create custom labels.

Does anyone have suggestions on how to speed up this process? The
query fields can vary each time.