Chart on Userform

P

pgjoshi

I have Created a Chart in a Worksheet. Can I view this chart on Userfor
through the Image control or any other control ? The chart change
according to the selection of data by the user thru Userform. Dat
sheets are kept hidden. Can anyone help me ?

Thanks in advance.

Prasad Josh
 
T

Tom Ogilvy

Go to Stephen Bullen's site and look at the pastepicture workbook.

http://www.bmsltd.ie/Excel/Default.htm

You would have to update the picture on each change of data.

Otherwise, you can look at using the chart component of the office Web
components (xl2000 or later). I have never used it, but it might work as
well.
 
Top