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

Brett,

there are multiple posts in here on dynamic charts. Also see
http://www.tushar-mehta.com/excel/ne...rts/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

" wrote:

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