Chart on Userform
 

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

--
Message posted from http://www.ExcelForum.com

Chart on Userform
 

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.

--
Regards,
Tom Ogilvy


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

Thanks in advance.

Prasad Joshi


---
Message posted from http://www.ExcelForum.com/