Help: Chart & data

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
 
D

Don Guillett

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

Why not just use SELF adjusting DYNAMIC named ranges such as:
insert>name>define name as desired such as
ch1cola
in the refers to box
=offset($a$1,0,0,counta($a:$a),1)
then in the series refer to the range
=yourfilename.xls!ch1cola
voila
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top