Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    positioning different charts on same location in e (1)

    Hi there,

    I am trying to change between three different type of charts depending on what kind of inputs are selected in drop down menus. I have no problem using the different charts and performing the calculations.

    My problem is that I want the graphs to be on the same position on the excel-sheet, then depending on what is selected only that one is shown.

    I have been trying to use different macros and sending the chart that shall be viewed "to the front" by recording my actions, but it just doesn't do it.

    Summary: Trying to put three diagrams ontop of eachother and depending what is shown in the dropdown menu, only displaying one of the three.

    Thank you so much for your help.
    david froster

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: positioning different charts on same location in e (1)

    Use this code to hide a chart:

    ActiveSheet.ChartObjects("Chart 1").Visible = False
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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