Hi all,
Often, when exploring data, it's interesting to look at different lookback periods, i.e., last 10 days, last 100 days or last year.
In this thread, I was able to learn how to set up my tables such that I can calculate averages and other statistical values with a dynamic lookback period.
I have partly solved this for charts as well by making a frequency count based on intervals (0-2 points, 2-4 points, 4-6 points, ..., 98-100 points, etc.) and then have the frequency formula set up with OFFSET. Changing the reference cell then automatically updates the chart and as a result also the associated chart.
However, often, this is not quite ideal and I'd like to actually chart every value or not have to make intervals, etc.
Is there a (simple) way to set up my charts to have a dynamic lookback period?
I'm attaching one of my sheets.
This is not VERY important for me, so don't make any efforts for me at all. I'm just curious if this is at all possible without too much hazzle. I did find some stuff online, but it seemed to relate mostly to dynamic charts in the sense that they were updated when you add a new row.
Thanks in advance.
Elijah
Bookmarks