Automatically create graphs based on specific data

Hi

I have range of data showing the scores on 4 different fields of multiple parties over a certain time span. Is there a way to create a macro which provides me with following two things?:

1. An overview graph which shows a scoreline per party, based on the average score of the 4 fields per day.
2. A sheet per party (which can be variable) which then shows 4 graphs which show the score per day on each separate field.

Maybe it is easier to work with a Pivot table and a pivot chart, but is there a way to include this in a macro? This because I will need to do the same update every day.

Kind regards,
Tino XXL