Dynamic Chart in VBA Form

[alion]

Dear Experts,
I am designing a VBA application for finance. It extracts data from the web and calculates certain index based on the information. I found a way to create a dynamic macro based chart in excel worksheet which incorporates new information but I want it to appear in user form. I tried using Microsoft Chart 11.0 but it is asking me to input data which makes it static. I want to make sure that user gets everything in useform rather then moving from excel to VBA and vice versa.

Can anyone please help?

Thanks in advance.

Ali

 

[Jon Peltier]

John Walkenbach shows on his website how to Display a Chart in a UserForm.

 

[alion]

Thanks man. I tried it but it is giving me runtime error 9, script out of range on

Set CurrentChart = Sheets("Sheet1").ChartObjects(1).Chart

I have one chart on sheet1 and i am using this code on a module under 'sub' and calling this module using command button. I know i suck at this. please let me know where is the mistake. thanks

 

[Jon Peltier]

That means that there is no sheet called "Sheet1" or no chart objects on Sheet1.

 

[alion]

guilty.... sheet name was incorrect. I thought changing caption wont matter. It works like charm now. Thanks alot.