vba dynamic range for chart as new data gets added to rows

[excellol]

sorry the title should have been "vba dynamic range for sparkline as new data gets added to rows"

​

i have a range of data stored in range A3:A10 and i insert a line sparkline based on the data stored in this range.

a new datapoint is then added to this range daily where the new datapoint is added to the next row after the last data (ie added in A11).

at the end of next week, 5 new datapoints are added. the line sparkline will then be based on the range A8:A15.

what is the vba code to automate the selection of the new data range for the line sparkline?

 

[earthworm]

Convert your data into table format and then create charts it will automatically become dynamic