I have a sheet that updates daily by running a timed macro, this produces a currency value in for example cell A1.
As cell A1 changes to reflect the daily value I would like to capture this updated value and automatically add to a monthly line chart.
As cell A1 changes to reflect the daily value I would like to capture this updated value and automatically add to a monthly line chart.