Add curve to existing chart

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

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


In article ,
says...
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

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/...kChartVBA.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

daMike wrote:

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