I have a spreadsheet containing the following values (slightly simplified): Date - day in number - Temperature - Windspeed - Hours of sun. Data example:
01-09-2000 - 01 - 20 - 15 - 9
02-09-2000 - 02 - 20 - 15 - 9
03-09-2000 - 03 - 20 - 15 - 9
....
01-09-2000 - 01 - 20 - 15 - 9
02-09-2000 - 02 - 20 - 15 - 9
etc
I have this for 15 consecutive years of the month september. I want to have a graph showing the following:
- On the X axis I want all days of september, 1-30.
- On the Y axis I want the mean for that day, a point/line for every variable (in case of my example 3, temperature, windspeed and hours of sun).
In other words, the graph will contain 3 variable values per day, which are all the mean of the relevant variables. Can anyone help me on my way? I have searched and for example found a subject on pivot tables but AFAIK that's not what I need.