Hi there,
I am looking to chart a variable which peaks and troughs consistently through the year, just like rainfall i.e. with a high, low and mean value for each month.
I can easily chart this in Excel and Medcalc but I would like to show a polynomial trend line connecting jan-dec, effectively "wrapping" the chart as, no guessing (D'uh), January usually follows December. I don't need to compare year on year, just a smooth rolling trendline would do.
I can "cheat" by simply adding six-months data before and after but then the chart is twice as wide as it needs to be.
Does anyone know of a way to do this?
Thanks for all the help,
Chris.
I am looking to chart a variable which peaks and troughs consistently through the year, just like rainfall i.e. with a high, low and mean value for each month.
I can easily chart this in Excel and Medcalc but I would like to show a polynomial trend line connecting jan-dec, effectively "wrapping" the chart as, no guessing (D'uh), January usually follows December. I don't need to compare year on year, just a smooth rolling trendline would do.
I can "cheat" by simply adding six-months data before and after but then the chart is twice as wide as it needs to be.
Does anyone know of a way to do this?
Thanks for all the help,
Chris.