One of projects is to Copy one existing Charts and paste in another place in the same sheet of the source Charts. But i need to change the DataSource and SeriesCollection. I use ChartObjects(1) and to ChartObjects(2) to refer to the object source since they are the first two charts in the sheet. But when i Msgbox ChartObjects(1).Name, it is not the name as shown in the title when i click Chart Window. Why ?
And the data source is not changed even my codes have done that. ??? What are the possible problems when generating Charts.
Note: The charts are not Chart sheet. They are ChartObjects in a worksheet.
The data source is in another worksheet in the same workbook. When contents in data source sheet expands, the more charts will be generated by running a Macro.
regards
Andrew XJ
And the data source is not changed even my codes have done that. ??? What are the possible problems when generating Charts.
Note: The charts are not Chart sheet. They are ChartObjects in a worksheet.
The data source is in another worksheet in the same workbook. When contents in data source sheet expands, the more charts will be generated by running a Macro.
regards
Andrew XJ