Add curve to existing chart

[daMike]

Hello,

I should add to an existing chart another curve with VBA.
The Charttyp is an XY-Plot! I work with WinXP and Excel 2002!

Hope somebody can help me!

Thanks in advance!
daMike

 

[Tushar Mehta]

Turn on the macro recorder (Tools | Macro > Record new macro...), copy
the data, select the chart, select Edit | Paste Special..., follow the
directions, and when done, turn off the recorder. XL will give you the
necessary code, which you can further adapt.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office

 

[Jon Peltier]

Mike -

The macro recorder is a pretty good tool for finding the code to perform
a task. Usually the recorded macro works fine. Unfortunately it
doesn't always give you very efficient code. I have some code samples
on this web page which can help you out:

http://www.geocities.com/jonpeltier/Excel/ChartsHowTo/QuickChartVBA.html

- Jon