Hi,

Is there a way to build a chart in excel but make it appear only on a userform instead of the sheet? If so, then what are the basic steps?

Scenario:

Userform1
two buttons
one: OK
two: UserCharts
I click on UserCharts and the chart appear on the userform based on stats picked up from sheet5 in excel

If not, then how can I add a button on the chart itself that will, upon being clicked on, disappear and bring the userform back?

Thank you for help in advance and thank you to all who have helpped me so far. you guys are supper!

Alexxx

I don't think it is possible to add a chart on a UserForm. What you could try is having it so. when you click the button on the UserForm, it closes the form and goes to the sheet with the chart, then having a button on the chart sheet that re-opens the UserForm. this is the code.

'Code to open UserForm
Sub Button1_Click()
UserForm1.Show
End Sub

'Code behind UserForm to show chart
Private Sub CommandButton1_Click()
UserForm1.Hide
Sheets("Chart1").Select
End Sub

Yes, you can put a chart in a UserForm. Check out this:

http://j-walk.com/ss/excel/tips/tip66.htm

Hi,

I added a chart in your application, but it is not displayed. Did you hide the code behind the View Chart Button? If so, would you be kind enough to share it, I am a student of excel and I need all the tip I can get.

Disregard my last message. I got it!