Function that copies a charts format
 

I would like to make a macro that takes a chart object as an input and
outputs a chart object that is the same format as the input chart in
every way except for the data inside of it. So each series in the
chart will be the same format and the format of the file and the legend
and everything will be the same as the input format. Any help on this
would be appreciated. Thanks alot

Function that copies a charts format
 

You could take the first workbook with the chart, and save it as a template.
Then create a new file based on the template and paste the new data on top
of the data in the template. If you can make a reasonable template you may
not need a macro, and if you still do, it is easier to implement than
creating a new chart from scratch and applying formats.

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


"CalOTA" wrote in message
ups.com...
I would like to make a macro that takes a chart object as an input and
outputs a chart object that is the same format as the input chart in
every way except for the data inside of it. So each series in the
chart will be the same format and the format of the file and the legend
and everything will be the same as the input format. Any help on this
would be appreciated. Thanks alot

Function that copies a charts format
 

Without the Macro Recorder you also have the option of clicking on the
source chart, Edit/Copy, and then select the target chart, and
Edit|Paste Special..., select format.

HTH
Kostis Vezerides


CalOTA wrote:
I would like to make a macro that takes a chart object as an input and
outputs a chart object that is the same format as the input chart in
every way except for the data inside of it. So each series in the
chart will be the same format and the format of the file and the legend
and everything will be the same as the input format. Any help on this
would be appreciated. Thanks alot