I have attached twb file for your reference. When I opened , min,max and avg were already calculated using reference line. As far as coloring between min and max is concerned, you just need to provide the color in "Fill" when editing refrence line
Antarctic Sea Ice.twbx 140.8 KB
Thanks Nitin. I did manage to get the average, min and max lines, however, these are straight averages of the data. What I guess meant to say was I would like the average,min and max for each month within the filtered dataset. I assume this is how the average data has been computed on the link I provided (see below).
So instead of a 1981 - 2010 Median, I would like to compute a 2009 - 2018 arithmetic average.
The same would apply to the min and max lines.
Ok, I think I have managed to work out the calculations for min, max and average:
I am now having trouble getting them to display how I want them. Ideally, I would like them on the same chart as the yearly curves, but when I do that, it messes up the format.
I have, however, managed to get the data to plot on a second chart, but when Min and Max are added to the same axis, it joins the points between Min and Max.
What would be the best way to get this all onto one chart, without min and max joining and adding shading between the min and max curves?
I have attached my updated workbook.
Antarctic Sea Ice.twbx 106.7 KB