You could copy the first chart, select the second, and use Paste Special -
Formats. Keep in mind that contents of titles and data labels are considered
format and not data, so pasting formats will wipe out your axis titles and
so forth.

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


"F. Lawrence Kulchar" wrote in
message ...
Is it possible to exactly duplicate the formatting of a chart into a new
chart...

I wish only to change the data series...the formatting (colors, size,
type,
axes, fonts, etc.) ALL REMAIN THE SAME.

I guess I could first copy and paste the whol chart...then change the data
series.

PLEASE ADVISE.

Thanks,

FLKulchar