Selecting chartobject without index no.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jaylin - 23 Aug 2006 18:38 GMT

I have 25 worksheets each with 2 graphs.
I need to revise the source series for all the graphs in these worksheets.

I thought I can use VB language to auto change the series reference
but I do not know the index number for each of the chart

"ActiveSheet.ChartObjects("index").Activate

Hope I could have advice on how to activate each charts without useing the
chart index

Signature

Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******

Reply to this Message

Jon Peltier - 24 Aug 2006 02:09 GMT

Well, first of all, if the index is a number, make sure you don't put it in
quotes. Second of all, you can name the charts uniquely, either in code if
the charts are generated automatically, or by hand after the fact. This page
discusses chart names:

http://peltiertech.com/Excel/ChartsHowTo/NameAChart.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> I have 25 worksheets each with 2 graphs.
> I need to revise the source series for all the graphs in these worksheets.
[quoted text clipped - 6 lines]
> Hope I could have advice on how to activate each charts without useing the
> chart index

Reply to this Message

Jaylin - 24 Aug 2006 04:10 GMT

Dear Mr Peltier

Thank you very much for the useful advice.

I have problem activating a chart as I do not know the chart index number.
Would appreciate your additional advice.

Signature

Thanks a million for your time and expert advice :-)
Jaylin
*****Jaylin Message ended*******

> Well, first of all, if the index is a number, make sure you don't put it in
> quotes. Second of all, you can name the charts uniquely, either in code if
[quoted text clipped - 20 lines]
> > Hope I could have advice on how to activate each charts without useing the
> > chart index

Reply to this Message

Jon Peltier - 24 Aug 2006 16:30 GMT

To find out the chart object index, run this from the Immediate Widow, and
see what's activated:

ActiveSheet.ChartObjects(1).Select

Change the (1) to see what all the numbers refer to.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> Dear Mr Peltier
>
[quoted text clipped - 32 lines]
>> > the
>> > chart index

Reply to this Message

Jon Peltier - 24 Aug 2006 16:31 GMT

> Dear Mr Peltier
>
[quoted text clipped - 32 lines]
>> > the
>> > chart index

Reply to this Message