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. Any help on this would be appreciated. Thanks alot |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Functiono that copies a charts format | Excel Worksheet Functions | |||
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 | |||
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 |