Hi,

i work with pivot charts quite a bit and am annoyed that they keep returning
to a default format when you change something. so i was going to make some
code to record the formatting of all series' in a chart, so i can (re-)apply
to a chart. but before i do, i wondered if someone has already written
something i can use or knows of some in-built function in excel that does
just this sort of thing... i often spend ages trying to re-invent the wheel!

thanks for any help,

Tim