Selecting Charts in a Macro

I have a worksheet which contains 7 charts:

1st Chart = Chart 12
2nd Chart = Chart 7
3rd Chart = Chart 11
4th Chart = Chart 13
5th Chart = Chart 24
6th Chart = Chart 16
7th Chart = Chart 26

I have a macro which copies the worksheet it over to a new worksheet
within the same workbook, the charts are then labelled:

1st Chart = Chart 9
2nd Chart = Chart 7
3rd Chart = Chart 13
4th Chart = Chart 10
5th Chart = Chart 2
6th Chart = Chart 12
7th Chart = Chart 15

The macro then tries to select each chart and change the source data,
what I don't know is how excel will treat the chart numbers for other
users on different PC's, will the chart numbers stay the same? Is
there any way I can name the charts and keep that named reference in
the Macro? Or is there a better way of doing this entirely?

Thanks


---
Message posted from http://www.ExcelForum.com/

Herman -

I think you'll find what you need on this web page:

http://peltiertech.com/Excel/ChartsH...ameAChart.html

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

Herman Merman wrote:

I have a worksheet which contains 7 charts:

1st Chart = Chart 12
2nd Chart = Chart 7
3rd Chart = Chart 11
4th Chart = Chart 13
5th Chart = Chart 24
6th Chart = Chart 16
7th Chart = Chart 26

I have a macro which copies the worksheet it over to a new worksheet
within the same workbook, the charts are then labelled:

1st Chart = Chart 9
2nd Chart = Chart 7
3rd Chart = Chart 13
4th Chart = Chart 10
5th Chart = Chart 2
6th Chart = Chart 12
7th Chart = Chart 15

The macro then tries to select each chart and change the source data,
what I don't know is how excel will treat the chart numbers for other
users on different PC's, will the chart numbers stay the same? Is
there any way I can name the charts and keep that named reference in
the Macro? Or is there a better way of doing this entirely?

Thanks


---
Message posted from http://www.ExcelForum.com/