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

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