select all series

[khickey]

G'day

Is there a way in V.Basic to select all series in an Excel chart so that I can make all line formatting identical?

thanks in advance

Cheers
ken

 

[jrnyman]

I ended up using a quick loop to apply the same formatting to each series.

hth

 

[khickey]

Thanks.... but I am a bit new to all VB, how do I write the loop so that it does all the series (there are 100 of them)

Thanks