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