Newroad wrote:Hi Servodude.
That spinner/scroll-bar combination is interesting and likely helpful if it would work as hoped - which from your experience suggests so.
I watched the video - I'll need a little time to get my head around it (and it appears that one needs to build it up from scratch - doesn't seem, easily at least, to be able to be retrofitted to an existing chart
![Sad :(](./images/smilies/icon_e_sad.gif)
).
Regards, Newroad
OK as I find myself with nothing to do at the moment lets try an example:
I've mocked up some simple data and plotted it in the image below
I have also made an extra short series using indirect to extract a window of that data
Cell G3 contains
and H3 contains
these are then "filled down" beside the 1..12 numbers beside them in column F
(Those numbers are really just there to make the building of the indirect string as obviously done as possible)
it is just concatenating the letter with the result of that addition (incase anyone is not aware $ is used to keep that part of the cell reference constant)
Cell H1 is where I have told the scroll bar (via its "properties") to put its value (for the purposes of the calculations though this could just be a cell you type in)
I then select that window worth of data (both columns) and "paste special"->"new series" over the existing graph
Then add a trendline - extending by X days in to the future
And I can now drag that bar to see where the trend was for any 12 consecutive samples
![Image](https://i.imgur.com/ic9tdIp.png)
I hope that makes sense
-sd