Inserting chart into user form

Good Day

I have this userform whereby I want to insert a chart into, I have created the chart on a separate sheet.

I have tried the normal copy and paste which does not work.

I have attached my spreadsheet

You can't embed a chart in a userform, You have to save the chart as an image and load that file into an image control on the userform.

HI Cytop

I have knowledge on the image control part, how do I save chart as image?

Like every other general question on how to do something, a search engine is always the faster way to find information: http://www.google.co.uk/search?&q=ex...chart+as+image

http://stackoverflow.com/questions/3...excel-userform

Hi Logit

Thanks for the link. Had a look at it, not sure where in my userform do I paste this code ?

In the VB Editor, right click on the Form Name (left pane window), VIEW CODE.

Then paste the macro code there.

You will need to edit the code to fit your project.

HI Logit
I copied and pasted the link as advised, but no image appeears

Please Login or Register  to view this content.

If you post your workbook for review, it will be easier to troubleshoot for you. There may be other changes required than just those above.

Hi Logit

I have attached sample of file with code you suggested.
I am still not seeing any chart on the userform

Please Login or Register  to view this content.

Hi Logit

Sorry for the late response. Your assistance is greatly appreciated.
Thanks for your help. Worked....

You are welcome. Thank you.

Cheers