Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Thanked 1 Time in 1 Post

    Data labels in scatter (Office 2003)

    I need to create 3 buttons that the user can click to see Series 1, Series 2 or both. I need the data labels and symbols to appear or disappear. I used JWalk tools to get the data labels to appear as they come from a different sheet than the source numbers. I don't know how to code the macro for the 3 buttons. Can anyone help me? Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Data labels in scatter (Office 2003)

    Actually hiding/showing the series would be a hassle. I'd create three charts - one for series 1, one for series 2, and one for both. Give the three charts exactly the same size and position. The code behind the buttons would set the Visible property of one chart object to True and that of the other two chart objects to False, for example

    With ActiveSheet
    .ChartObjects(1).Visible = True
    .ChartObjects(2).Visible = False
    .ChartObjects(3).Visible = False
    End With

Posting Permissions

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