Copy and paste a chart using a macro

F

Flystar

I am trying to copy and paste a chart from one workbook to another and
maintain all formatting (including titles, font sizes, colors etc) using
an excel macro. So far I have something like this:

ActiveSheet.ChartObjects(1).Activate
ActiveChart.ChartArea.Select
ActiveChart.ChartArea.Copy
Workbooks("Chartbook.xls").Worksheet("Section A").Paste

Unfortunately, when I paste the chart the axes font size changes as does
the plot area.

::Win98SE, Excel 2000::

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and paste a chart to another worksheet 4
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Blank Charts and Paste Special 5
How to copy multiple objects from Excel to PowerPoint 0
Pasting a chart as object between instances of Excel 5
Copy chart to clipboard - VBA 11
Copy/paste range of rows between 2 dates... 1
Control size of chart - CopyPicture 0

Top