how to modify address of data in chart

  • Thread starter Thread starter Mariusz
  • Start date Start date
M

Mariusz

Hi,
I've got problem with charts in vba.
I'd like to modifty data in the chart.
For example data of series1 are addressed "=CHF!A1:A5" and I'd like to
change it for "EUR!A1:A5". I've got to read first where the data of series1
are located.

I wanted to do it through:

dim strAddress as string
dim obChart as Chart

....

strAddress=obChart.SeriesCollection(1).Values

but it doesnt work because obChart.SeriesCollection(1).Values returns array.
How to read the address of series1?

Thanks for help
Mariusz
 
Hi Mariusz,

Try this ;
strAddress=obChart.SeriesCollection(1).formula

Michel
 
You must log in or register to reply here.

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

Similar Threads

Charts with Combobox 2
How to create a table of multiple combination 2
Creating Graphs + VBA 1
Data available for plotting vs already plotted data 4
How to add line at today's date in chart 7
Erroneous Error? re >32,000 data plots in 2D chart 3
Help modifying a macro to recognise user IDs 4
Using SeriesCollection.Extend for a specific Chart Data Series 0

Back
Top