Forum Discussion
Chart for blood glucose tracking
Two possibilities occur to me. It sounds, first of all, as if you have a basic database that includes dates and readings.
So one way to accomplish this is to have a Pivot Table that summarizes your data, and use year (etc.) as a filter to vary the data summarized in the Pivot Table. The chart could be derived from the Pivot Table and would automatically adapt to the filtered view chosen.
A second way would be to use the very recently released FILTER function to extract whatever limited view you want to a new but dynamic table and use that intermediate table, the result of the FILTER function, as the basis for your chart.
If you were to post a copy of the spreadsheet, I or somebody else could demonstrate that for you. If the data are all confidential, create a dummy copy with false data.....