Graphing Linear Trend Lines

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 :us: (BOB member since 2004-11-29)