Help Please!!! Error with my graph macro

[Excelme1]

I have searched the forum for similar questions but can’t seem to find anything that would help me. I’m new to VBA so apologies in advance for any obvious mistakes. Here is the Macro I recorded and I have over 25 graphs I need to make the same change as I made to this one. However, when I activate the next sheet the macro comes up with an error stating "Run time err. The item with the specified name wasn't found". Please help any advice will be appreciated. Thanks!!!

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o>Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+Shift+K
'
Sheets("Aged Corr Chart").Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(4).Name = "='Chart data'!$M$2"
ActiveChart.SeriesCollection(4).Values = "='Chart data'!$M$3:$M$80"
ActiveChart.SeriesCollection.NewSeries
ActiveChart.SeriesCollection(5).Name = "='Chart data'!$N$2"
ActiveChart.SeriesCollection(5).Values = "='Chart data'!$N$3:$N$80"
End Sub
</o>

 

[CharlesChuckieCharles]

Try Changing
Sheets("Aged Corr Chart").Select

to
Sheets("Aged Corr Chart").Activate

 

[Excelme1]

The same err message comes up

 

[CharlesChuckieCharles]

does "Chart 1" exist on that sheet?

 

[CharlesChuckieCharles]

I take it that the error is on the line in RED?


That you have stepped through the vba using F8

 

[Excelme1]

Yes. Chart1 is in sheet (Aged Corr Chart). I even tried changing the name "Chart 1" to "Chart1" since that is the way it's listed undet the list of excel objects,but so far no luck.

 

[CharlesChuckieCharles]

No... using ChartObjects it should be the name as it appears in below the ribbon on the left hand side of the workbook.
If you recorded the macro it should work on the sheet you recorded it on... does it?
What are the names of the other sheets?

 

[Excelme1]

Yes I did record the Macro and no it does not work on the recorded sheet.

 

[CharlesChuckieCharles]

remove
Sheets("Aged Corr Chart").Select


close



select the sheet first

Then run your macro so it runs on the currently selected sheet ( assuming said sheet as a Chart 1 on it)

 

[Excelme1]

Nope, it seems the problem is with this line. ActiveSheet.ChartObjects("Chart 1").Activate that line comes up twice and both times causes an error.