I have a range of data.
I can chart/plot it just fine but I want to do more.
I want the resulting plot to use different colors based on the actual value of the data.
The idea I have is to create a number of different data sources, and give each of them a different color.
Then I could do the following
Series1: all values less then 2
Series2: values >2 and <4
and so on.
But how do I do this?
I found the offset function, but I don't know how to produce a range based on a condition.
Also if anyone has any proposal to solve this problem, I'm all ears.
An example of the possible result (color smoothing is not required in my application) is attached.
Edit: also I would like to use standard functions if possible, instead of looping through all the data points in VBA and color each of them separately.
Bookmarks