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

John Peltier
http://peltiertech.com/

has a lot of information on charts - whether it applies to pivot charts or
not, I can't say.

Debra Dalgleish has written a book on pivot tables and has a lot of code
related to them:
Debra Dalgleish
http://www.contextures.com/tiptech.html

Until someone comes along with a more specific reference for you.

--
Regards,
Tom Ogilvy


"Tim" wrote:

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

Tom... you're a constant source of useful information!

Many thanks,

Tim

"Tom Ogilvy" wrote in message
...
John Peltier
http://peltiertech.com/

has a lot of information on charts - whether it applies to pivot charts or
not, I can't say.

Debra Dalgleish has written a book on pivot tables and has a lot of code
related to them:
Debra Dalgleish
http://www.contextures.com/tiptech.html

Until someone comes along with a more specific reference for you.

--
Regards,
Tom Ogilvy


"Tim" wrote:

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