Is there a 'format painter' equivalent to use on many charts?

Chris Mark · #1 09-03-2008, 02:00 PM

I'm trying to format a group of charts (roughly 40) so that they all have the
same formatting (font sizes, colors, alignment, etc.). Is there an easy way
to do this without having to change every axis and background on every chart?

I've tried the trick where you change something on one chart, click on
another, and press F4, but it was formatting all text on the chart in the
same way. I'm looking to have different fonts for the title, labels, and
axis.

Thanks!

**Andy Pope** · #2 09-03-2008, 03:34 PM

I see Jon gave you answer in the MS newgroups.

Please do not post your question in multiple places without having the courtesy to warning them that other may also be answering the same question.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting the Format of the Date	aki096	Excel General	3	05-29-2008 02:02 PM
Export chart format to VBA	danmak	Excel Programming	0	09-24-2007 06:41 AM
automatically update charts	slimjen	Excel Charting	3	09-04-2007 07:25 PM
Why won't my format painter work with conditional formatting???	dnnr	Excel Miscellaneous	1	07-14-2007 04:52 AM
cell format of numbers	joshtex	Excel General	3	03-23-2007 04:47 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)