Change a chart's series using VBA...

[Sharon]

Hi all,

Can I dynamically change a chart's source (series) using VBA.
The Excel help is really no help with this subject.

also...Where can I find some good online Excel Charting/VBA help and tips?

Thanks,

Sharon

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;183446&Product=xlw
XL: Using Defined Names to Automatically Update a Chart Range


http://support.microsoft.com/default.aspx?scid=kb;en-us;157940&Product=xlw
XL97: How To Create a Dynamic Chart Using Visual Basic

http://support.microsoft.com/default.aspx?scid=kb;en-us;213780&Product=xlw
XL2000: How to Use Visual Basic to Create a Dynamic Chart

http://support.microsoft.com/default.aspx?scid=kb;en-us;146055&Product=xlw
Using Visual Basic to Create a Chart Using a Dynamic Range

 

[Tom Ogilvy]

Another: John Peltier's site

http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html#VBAcharts