Line graph - change colour if number decreases

[MrAWilks]

Good afternoon,

I have some data already in a combo chart, a mixture of stacked columns and a line.

The data for the line predominantly goes up in order, e.g. 1,2,3,4,5

However their may be some instances where the data will decrease, e.g. 1,2,3,2,1

I would like the line for the data where it decreases to be changed to a different colour than the rest of the line automatically, without having to manually go in and change it, as it could be at a different data point each time.

Any help would be greatly appreciated.

 

[mart37]

You can do a workaround with a double line.

Map6
	A	B	C	D	E
1		Col2	Col3	Col4	col5
2	item2	20	10	10	10
3	item3	22	15	11	11
4	item4	24	20	15	15
5	item5	26	25	11	#N/B
6	item6	28	30	10	#N/B
7	item7	30	35	9	9
8	item8	32	40	20	20
Sheet11

Cell Formulas
Range	Formula
E2:E8	E2	=IF(OR(D2>D1,D3>D2),D2,NA())

 

[MrAWilks]

Thank you for this, appreciate the reply.

It kind of did what I was looking for, however found it tricky getting the right line to take priority if that makes sense. Think it may be something I was missing with the Gaps, Zero, Connect option?