Automatic Update of Chart

[brettmanning24]

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

 

[John]

Brett,

there are multiple posts in here on dynamic charts. Also see
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

If it works on your machine I would check to see if the other user has the
analysis tool pack addin installed...

hope that helps