Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Series Emphasising Chart (Excel 2000 >)

    Hi all,

    Could I get assistance with a way to emphasis the appropriate series on this chart in the sample file. If I choose a column from the dropdown, I would like the series plotting this data to turn red, and all other series' to turn grey.

    Tx for any assistance!
    Cheers
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Series Emphasising Chart (Excel 2000 >)

    Put the following code in the worksheet module:

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim cht As Chart
    Dim ser As Series
    If Not Intersect(Target, Range("F1")) Is Nothing Then
    Application.EnableEvents = False
    Set cht = Me.ChartObjects(1).Chart
    For Each ser In cht.SeriesCollection
    If ser.Name = Range("F1") Then
    ser.Border.ColorIndex = 3
    Else
    ser.Border.ColorIndex = 48
    End If
    Next ser
    Application.EnableEvents = True
    End If
    End Sub

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Series Emphasising Chart (Excel 2000 >)

    <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15> Hans...it works like a dream!
    ManyTX
    Regards,
    Rudi

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Series Emphasising Chart (Excel 2000 >)

    Here is a non-macro solution. It requires intermediate columns and the series will change the order (The highlighted is first in the legend)

    Steve

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Series Emphasising Chart (Excel 2000 >)

    Cheers Steve.
    It's only you who can come up with alternatives like this!
    TX
    Regards,
    Rudi

Posting Permissions

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