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!

Copy the chart area of one chart, select another, and use Paste Special to
paste the formats. Note that this paste not just formats, but also the text
contents of chart and axis titles and data labels.

If you use the F4 key, you have to select the same chart element. Formatting
the font properties of the Chart Area will affect all fonts in the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Chris Mark" <Chris (E-Mail Removed)> wrote in message
news:874B98F0-130E-454D-A8BE-(E-Mail Removed)...
> 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!

Thanks! That will save me a lot of time

"Jon Peltier" wrote:

> Copy the chart area of one chart, select another, and use Paste Special to
> paste the formats. Note that this paste not just formats, but also the text
> contents of chart and axis titles and data labels.
>
> If you use the F4 key, you have to select the same chart element. Formatting
> the font properties of the Chart Area will affect all fonts in the chart.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "Chris Mark" <Chris (E-Mail Removed)> wrote in message
> news:874B98F0-130E-454D-A8BE-(E-Mail Removed)...
> > 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!
>
>
>