Selecting Charts in a Macro

  • Thread starter Thread starter Herman Merman
  • Start date Start date
H

Herman Merman

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
 
Back
Top