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