Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    Unanswered: chart and userform

    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

  2. #2
    Join Date
    Feb 2004
    Location
    Swindon, UK
    Posts
    86
    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
    "Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done."

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    Yes, you can put a chart in a UserForm. Check out this:

    http://j-walk.com/ss/excel/tips/tip66.htm
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  4. #4
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    charts and userform

    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.

  5. #5
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    I got it

    Disregard my last message. I got it!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •