Thread: different line color for different ranges

Hi I'm stuck at work with an urgent question

If i have data points B1:B100 and on my line chart i need the portion of the line corresponding to b1:b10 to be one color, b50:b80 in another color and rest of the points to be a distinct 3rd color what is the best way to do this??? I know i can change each data point manually but its far too slow and I have about 50 of these to do

any help is greatly appreciated

cheers