This is an awesome tool, THANKS.
I have a question. When I try to use this for multiple years (in the same chart) the trend line starts over. In other words, it shows a trend for 2008, then the trend for 2009, etc.
Without the year, the trend line is straight as expected, but it is not when I add the year. In the example provided he used sections to display multiple years, can multiple years be shown in one chart?
What I want is to show 2008, all 12 months, 2009, all 12 months, etc with a single trend line showing a trend into 2010.
Any ideas how to modify this to do that?
trendlinesample.doc (27.0 KB)
REB01
(BOB member since 2004-11-29)