Format color of Series in a chart
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
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
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1