I am working in a new company, they are using a excel with a 20 charts for a
report.
20 charts from different data sourse. But the problem is every month, I need
to delete the first column data and add the new column in the end for the new
data for the new month. Then I need to update the charts, each chart has 10
series, the old way to do it is to update every series manually. I am trying
to use the programme to update the chart automated.
Is there any one can help me on this.
Thank you.