If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Add curve to existing chart
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 |
#3
|
|||
|
|||
Add curve to existing chart
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 |
Thread Tools | |
Display Modes | |
|
|