Automatic Update of Chart
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 |
Automatic Update of Chart
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 |
All times are GMT +1. The time now is 02:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com