Chart on a Userform

Hi All

I want to add a chart to a userform, and i have found a few codes and sites that offer help, but..... im having issues i just cant get it to work, currently i have this

Please Login or Register  to view this content.

Which wont work, then i have looked at this site.... http://www.j-walk.com/ss/excel/tips/tip66.htm

And cant get that to work either, could somone please explain where i should be putting these codes? in a module, or directly into the userform code

Thanks

Dan

Yes i have the tab called "Charts" where the chart is located, and the image control in the userform is Image1, my current code for the whole userform is very simple

Please Login or Register  to view this content.

Its literally a summary box, but i want to extend this now to include graphs, when i put the previously posted code into the module i get this error....

1. when all the code is in the module = variable not defined on Image2
2. when i remove the userform_initialize sequence and put it in with my current code = Sub or function not defined, (which i then add "Run" infront of updatechart) and then it works, but doesnt show the graph nor does it save the GIF in the file location

When i change it to this....

Please Login or Register  to view this content.

And keep the updatechart code in the module, there are no errors, but it still doesnt give me the chart in the userform, or save the GIF

Hi Andy

Sorry i had to remove alot of sensitive data, and then overwrite the formulas to give some form of example of what i am after, here is the example

Thank you, hopefully you may be able to help me, yet again

Brilliant thanks Andy Pope, i can only assume that i had another sheet open with userform1 in, as when i opened your returned sheet it wouldnt let me open the userform, when i closed all other sheets, it worked exactly how i wanted it too

Thanks again

Originally Posted by Andy Pope

I just incorporated the UpdateChart routine into your userform.

Hi Andy,
I know, it's a quite an old topic, I just found it. I tried to copy your code to mine, but I got runtime error.
Could you maybe check what the problem could be?

Tks