D
danny tang
Hi,
are there any method to know the source data in chart via vba?
Actually, i have >60 charts were done. >10series in each chart.
However, the series will be increased day by day.
Now, I'm redo the plot (with macro already) every time.
If i can get the data source when i activate the chart, then i can add the new series in chart 1 by 1. Any ideas?
thanks.
br. Danny
are there any method to know the source data in chart via vba?
Actually, i have >60 charts were done. >10series in each chart.
However, the series will be increased day by day.
Now, I'm redo the plot (with macro already) every time.
If i can get the data source when i activate the chart, then i can add the new series in chart 1 by 1. Any ideas?
thanks.
br. Danny