Excel Charts
Hi,
I have created a userform using excel vba(macros) and am trying to display some charts on the form by dynamically changing the data. But could not do so..can any one help me on this? Actually there r 2 options available:) 1. To create a basic chart template and change the data dynamically and display it on the userform. Is there any way to display the chart on the form from the excel sheet!! I have tried image control..its not working 2. To use the excel automation classes for chart and dynamically create charts and put some data on it and display on the form..Actually i don't know how to do this!! Can anyone please help me on this or have any new ideas..please reply.. Thanks Sri |
Excel Charts
Go to John Walkenbach's Spreadsheet Page (http://j-walk.com), and look
in the developer tips for a way to put the image of a chart onto a user form. It involves exporting the chart as a gif, and using that gif as the source of a picture control on the form. Sounds kludgy, but it works well enough. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Srivathsa wrote: Hi, I have created a userform using excel vba(macros) and am trying to display some charts on the form by dynamically changing the data. But could not do so..can any one help me on this? Actually there r 2 options available:) 1. To create a basic chart template and change the data dynamically and display it on the userform. Is there any way to display the chart on the form from the excel sheet!! I have tried image control..its not working 2. To use the excel automation classes for chart and dynamically create charts and put some data on it and display on the form..Actually i don't know how to do this!! Can anyone please help me on this or have any new ideas..please reply.. Thanks Sri |
All times are GMT +1. The time now is 06:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com