On Thu, 5 Jun 2008, in microsoft.public.excel.charting,
Rick said:

Thanks Shane - unfortunately finding out after the fact.

In Excel versions 2003 and earlier, you can lessen the pain by using the
F4 key. Make a single change in the first chart, then select the
equivalent feature in another chart and press F4. The last change you
made repeats. Go through all your charts, and start again with the next
little change. It can be faster that way.

This can be useless, as when you want to change the line of a bar but
not the color, and F4 changes both. That's why if I want to change the
color of bars I always edit the color palette and leave the bars on
automatic. F4 then selects "automatic" color, and only the line is
changed, as wanted.

It works differently in 2007, but I haven't used that version, so I
don't know what the differences are or whether they're an improvement.

Another tool might be Copy.. Paste Format, but that doesn't always work
well, and things like chart title are treated like Format when they're
obviously Content.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.