+ Reply to Thread
Results 1 to 2 of 2

Format color of Series in a chart

  1. #1
    Registered User
    Join Date
    01-04-2012
    Location
    Illinois
    MS-Off Ver
    Excel 2003
    Posts
    2

    Format color of Series in a chart

    Hello,

    I have a chart that has 3 different series. What i'd like to do is have a macro that goes through series 2 only of this chart and check all the values of this series in an excel range( lets say it's called "range2") and based on those values change the color of the series in the chart. So for example if the value in the range is positive then green and if it's negative then red.

    Can someone tell me how to do this ? This is all i have so far


    Sub Test()


    ActiveSheet.ChartObjects("Chart 2").Activate
    ActiveChart.SeriesCollection(2).Select

  2. #2
    Registered User
    Join Date
    01-04-2012
    Location
    Illinois
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Format color of Series in a chart

    I need to somehow loop through all the points of series 2 and change the individual points based on the value in a range to green or red

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1