How can I create and display a chart dynamically on a UserForm wi.
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. |
I think it's an incredibly dumb idea to want to interface only with a
userform (and sacrifice the flexibility of direct access to a chart). Maybe, you can convince your client to work with a chart on its own sheet (rather than an embedded object in a worksheet). But, if you must, see John Walkenbach's http://j-walk.com/ss/excel/tips/tip66.htm -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... 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. |
All times are GMT +1. The time now is 10:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com