Function that copies a charts format

[CalOTA]

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. Thanks alot

 

[Guest]

Try just turning on the Macro Recorder and then doing the copying manually
one time and shutting off the recorder.........there you will have a macro
that you can edit the sources on, and otherwise experiment with............

When you say you want the macro to "copy" a (any) chart and "output" it
somewhere, the macro has to know exactly where you want it, and also exactly
where the new source ranges are........

hth
Vaya con Dios,
Chuck, CABGx3