CONTEST - Make This Code More Efficient (winner gets bragging rights...) :)

I don't wish to participate in the contest.

Some tips follows...

1. If the code for both charts is same, you can do
for i = 1 to 2
with activesheet.chartobjects("Chart " & i )
your code
end with
next i

2: No need to select the series. Rather do
with seriescollection(n)
your code
end with

Not having read the code but Excel 4??????????

1) How long does your macro take to execute?
2) Does it do what you want?

Originally Posted by JBeaucaire

1) How long does your macro take to execute?
2) Does it do what you want?

Still awaiting answers.

Originally Posted by JBeaucaire

Still awaiting answers.

I think you will find that most senior members (I'm not) are not interested in competitions they are on the forum because they want to help / improve other posters knowledge.
Jerry has posted a couple of questions, if you answer those questions then you will probably find that there will be suggestions to improve your code if that is what you want.

Also. your Thread Title breaks Rule # 1

Thanks Roy.

K9-961,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.