Update charts
I am new in a company, this company is using a excel spreadsheet for a report.
There are 20 charts with 20 different source data. For the source data, every month I need to delete the first column and add the new column in the end for the new month's data. and then update the charts. every chart has 10 series, the old way to do it is to update very series manully. But it spends too much time and very easy to make mistake. I am trying to use programming to update the chart automated. Is anyone can help me on this? Thanks. |
All times are GMT +1. The time now is 08:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com