Hello,

I am looking for a way to update my chart's source data automatically
on a daily basis. Each day a new row is added to my chart, therefore
I have to change the source data every morning. A scheduled task runs
which emails the spreadsheet every day. I tried using the OFFSET and
COUNTA functions but when I email the spreadsheet the chart is empty.
Is this because of the named ranges?

If anyone can offer any other help I would be very grateful,

Thanks,

Brett