I am trying to create charts dynamically using VBA and Excel. The data being
plotted will change frequently, and my client wants to interface only with
the user form, and not the worksheet itself. I know that you can use the
MSChart control to do this in VB6, but I was wondering if there is a similar
control for use with Excel and VBA. If so, any additional info on how to use
it would be much appreciated. Thanks.