Change a chart's series using VBA...

S

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
 
T

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
 
Top