Reference a range of values within a SeriesCollection, or use SeriesCollection in a range?

I'm trying to use a LinEst worksheet function in a calculation where the calculation is based off of the last 12 points in a chart from the previous week (so -1 to -13 from the last point). I want to compare the previous LinEst to the new LinEst and see if there was a positive or negative change when the new data was added.

I know a LinEst function can easily be programmed if I reference the actual data instead of a SeriesCollection, but I really want to use the SeriesCollection so all of my chart codes can reference the same procedure. I have 8 charts and they all do the same thing but with different data, so I gave all the series the same names across the charts and reference those series names in the reusable procedures.

Is it possible to reference a range of values within a SeriesCollection or use a Range and instead of Cells put SeriesCollection point numbers?

---

Please Login or Register  to view this content.

---

Thanks!!