Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. Thanks alot |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function that copies a charts format
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 "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. Thanks alot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy with format | New Users to Excel | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
HOW DO WE CHANGE THE FORMAT OF FUNCTION =BAHTTEXT( ) TO ENGLISH? | Excel Worksheet Functions | |||
Setting Cell Number Format With A Worksheet Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel |