Automate Chart Filtering

[JJas007]

I have medical data, BP, Pulse, o2 & weight that I chart using a basic line chart. The data is taken daily and I would like to automate the resulting chart to show either daily, or weekly or monthly over a specific period. I can do this manually using the filter. I would like to know if this can be done programmatically such that it doesn?t require much manual intervention or time.
I?m not a programmer, but I think that someone might know how best to accomplish this. Any suggestions and help greatly appreciated!
Thank you,
John

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.