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
Bookmarks