macro to add horizontal lines to stock chart

[freak11]

Hi guys,
I have got several stock charts in my excel sheet and I recorded the modifcations on one stock chart as shown below. Now, I want these modifications to apply to every stock chart in my excel sheet. So for Chart 2 value 1 would be "='chart summary'!$AK$6:$BN$6", value 2 would be "='chart summary'!$AK$7:$BN$7" and so on

Please Login or Register  to view this content.

[freak11]

I have modified this code, but I need some help.
I need to change this line ActiveChart.SeriesCollection(5).Values = "='chart summary'!$AK$1:$BN$1"
ActiveChart.SeriesCollection(5).XValues = "='chart summary'!$B$1:$AE$1"

This line should be changed in such a way that AK2:BN2, B2:AE2; AK3:BN3, B3:AE3... and so on is picked each time a new chart is created.

Can anyone help me with this? Thanks.

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Try this code

Please Login or Register  to view this content.

[freak11]

It says compile error: syntax error

[freak11]

now it works

Please Login or Register  to view this content.