Chart Line Color - Blue when increasing and Red when decreasing

[LAAdams17]

I'm trying for find a way to show line chart in a manner that when the values are equal to or greater than the prior day the line color is blue and when the values are decreasing the line color is red. I've gotten part of the way there by overlaying two lines. Is there a simpler way to do this in Excel 365? If not, can anyone help get rid of the lines when my values are ""? Thanks in advance.

Riding the Waves development 230421.xlsx
	A	B	C	D	E	F
1	Date	yTwo		Date.	Up	Down
2	12/12/22	170.71		12/12/22		170.7125
3	12/13/22	168.99		12/13/22		168.9943
4	12/14/22	167.43		12/14/22		167.4271
5	12/15/22	165.80		12/15/22		165.8003
6	12/16/22	163.68		12/16/22		163.6842
7	12/19/22	161.14		12/19/22		161.1445
8	12/20/22	157.84		12/20/22		157.8355
9	12/21/22	154.45		12/21/22		154.4506
10	12/22/22	150.33		12/22/22		150.3322
11	12/23/22	146.44		12/23/22		146.4384
12	12/27/22	141.02		12/27/22		141.0163
13	12/28/22	136.67		12/28/22		136.6746
14	12/29/22	133.32		12/29/22		133.3248
15	12/30/22	130.39		12/30/22		130.386
16	01/03/23	125.92		01/03/23		125.9185
17	01/04/23	122.40		01/04/23		122.4009
18	01/05/23	118.74		01/05/23		118.7367
19	01/06/23	115.97		01/06/23		115.968
20	01/09/23	114.07		01/09/23		114.0663
21	01/10/23	112.36		01/10/23		112.358
22	01/11/23	111.38		01/11/23		111.3761
23	01/12/23	110.63		01/12/23		110.6293
24	01/13/23	110.05		01/13/23		110.0482
25	01/17/23	109.91		01/17/23		109.9074
26	01/18/23	109.77		01/18/23		109.7658
27	01/19/23	109.39		01/19/23		109.3892
28	01/20/23	109.27		01/20/23		109.2712
29	01/23/23	109.87		01/23/23	109.8739
30	01/24/23	110.05		01/24/23	110.0509
31	01/25/23	110.87		01/25/23	110.8744
32	01/26/23	113.25		01/26/23	113.2468
33	01/27/23	116.87		01/27/23	116.8712
34	01/30/23	119.79		01/30/23	119.7924
35	01/31/23	122.99		01/31/23	122.9883
36	02/01/23	126.70		02/01/23	126.7023
37	02/02/23	130.83		02/02/23	130.834
38	02/03/23	134.59		02/03/23	134.5866
39	02/06/23	138.74		02/06/23	138.7399
40	02/07/23	143.53		02/07/23	143.5256
41	02/08/23	148.61		02/08/23	148.6135
42	02/09/23	154.13		02/09/23	154.1286
43	02/10/23	158.69		02/10/23	158.6928
44	02/13/23	163.60		02/13/23	163.5994
45	02/14/23	169.64		02/14/23	169.6405
46	02/15/23	176.04		02/15/23	176.0413
47	02/16/23	180.95		02/16/23	180.9528
48	02/17/23	186.20		02/17/23	186.1998
49	02/21/23	190.30		02/21/23	190.2991
50	02/22/23	194.59		02/22/23	194.5905
51	02/23/23	199.14		02/23/23	199.1357
52	02/24/23	202.77		02/24/23	202.7746
53	02/27/23	206.91		02/27/23	206.9051
54	02/28/23	210.61		02/28/23	210.6106
55	03/01/23	214.01		03/01/23	214.0075
56	03/02/23	216.08		03/02/23	216.0791
57	03/03/23	218.58		03/03/23	218.5755
58	03/06/23	220.17		03/06/23	220.1674
59	03/07/23	221.14		03/07/23	221.1446
60	03/08/23	221.07		03/08/23		221.0717
61	03/09/23	220.07		03/09/23		220.0724
62	03/10/23	218.43		03/10/23		218.4344
63	03/13/23	216.87		03/13/23		216.8702
64	03/14/23	216.21		03/14/23		216.2068
65	03/15/23	215.24		03/15/23		215.2351
66	03/16/23	213.81		03/16/23		213.8111
67	03/17/23	212.12		03/17/23		212.1192
68	03/20/23	210.38		03/20/23		210.3812
69	03/21/23	209.69		03/21/23		209.6931
70	03/22/23	208.58		03/22/23		208.5752
71	03/23/23	207.34		03/23/23		207.3357
72	03/24/23	205.96		03/24/23		205.9578
73	03/27/23	204.54		03/27/23		204.5441
74	03/28/23	202.72		03/28/23		202.72
75	03/29/23	201.47		03/29/23		201.4664
76	03/30/23	200.07		03/30/23		200.0664
77	03/31/23	199.39		03/31/23		199.3913
78	04/03/23	197.79		04/03/23		197.7919
79	04/04/23	196.29		04/04/23		196.2913
80	04/05/23	194.13		04/05/23		194.1333
81	04/06/23	191.86		04/06/23		191.8631
82	04/10/23	190.09		04/10/23		190.0883
83	04/11/23	189.14		04/11/23		189.1386
84	04/12/23	187.23		04/12/23		187.2332
85	04/13/23	185.97		04/13/23		185.9736
86	04/14/23	184.94		04/14/23		184.942
87	04/17/23	184.33		04/17/23		184.3347
88	04/18/23	183.59		04/18/23		183.5867
89	04/19/23	182.75		04/19/23		182.7544
Sheet3

 

[awoohaw]

this is definitely doable. You need to create two data series, one for the red, one for the blue. when a value changes direction from you need to put the value as NA() so it does not chart. Then format the two series with the different line color.

 

[awoohaw]

this is without a repeating value at the inflection point which would make the line continuous:

 

[awoohaw]

Here is the up down formulas with lines continuous::

mr excel questions 27.xlsm
	A	B	C	D				H	I	J
1	Date	yTwo		Date.				up	down
2	44907	170.7124936		2022-12-12				170.7125	170.7125
3	44908	168.9943049		2022-12-13				#N/A	168.9943
4	44909	167.4271287		2022-12-14				#N/A	167.4271
5	44910	165.8002813		2022-12-15				#N/A	165.8003
6	44911	163.6841635		2022-12-16				#N/A	163.6842
7	44914	161.1445163		2022-12-19				#N/A	161.1445
8	44915	157.8355051		2022-12-20				#N/A	157.8355
9	44916	154.4506115		2022-12-21				#N/A	154.4506
10	44917	150.332188		2022-12-22				#N/A	150.3322
11	44918	146.438353		2022-12-23				#N/A	146.4384
12	44922	141.016306		2022-12-27				#N/A	141.0163
13	44923	136.6745885		2022-12-28				#N/A	136.6746
14	44924	133.3247533		2022-12-29				#N/A	133.3248
15	44925	130.3859766		2022-12-30				#N/A	130.386
16	44929	125.9184941		2023-01-03				#N/A	125.9185
17	44930	122.4009412		2023-01-04				#N/A	122.4009
18	44931	118.7367292		2023-01-05				#N/A	118.7367
19	44932	115.9679525		2023-01-06				#N/A	115.968
20	44935	114.0663052		2023-01-09				#N/A	114.0663
21	44936	112.3579756		2023-01-10				#N/A	112.358
22	44937	111.3761406		2023-01-11				#N/A	111.3761
23	44938	110.6292696		2023-01-12				#N/A	110.6293
24	44939	110.0481877		2023-01-13				#N/A	110.0482
25	44943	109.9073645		2023-01-17				#N/A	109.9074
26	44944	109.7657644		2023-01-18				#N/A	109.7658
27	44945	109.3891525		2023-01-19				#N/A	109.3892
28	44946	109.271176		2023-01-20				109.2712	109.2712
29	44949	109.8738821		2023-01-23				109.8739	#N/A
30	44950	110.0509407		2023-01-24				110.0509	#N/A
31	44951	110.8744226		2023-01-25				110.8744	#N/A
32	44952	113.2467525		2023-01-26				113.2468	#N/A
33	44953	116.871199		2023-01-27				116.8712	#N/A
34	44956	119.7923993		2023-01-30				119.7924	#N/A
35	44957	122.9882817		2023-01-31				122.9883	#N/A
36	44958	126.702329		2023-02-01				126.7023	#N/A
37	44959	130.8339765		2023-02-02				130.834	#N/A
38	44960	134.5865878		2023-02-03				134.5866	#N/A
39	44963	138.7399288		2023-02-06				138.7399	#N/A
40	44964	143.5255756		2023-02-07				143.5256	#N/A
41	44965	148.6134575		2023-02-08				148.6135	#N/A
42	44966	154.1285875		2023-02-09				154.1286	#N/A
43	44967	158.6928463		2023-02-10				158.6928	#N/A
44	44970	163.5994109		2023-02-13				163.5994	#N/A
45	44971	169.6405402		2023-02-14				169.6405	#N/A
46	44972	176.0412936		2023-02-15				176.0413	#N/A
47	44973	180.9527518		2023-02-16				180.9528	#N/A
48	44974	186.1997638		2023-02-17				186.1998	#N/A
49	44978	190.2990808		2023-02-21				190.2991	#N/A
50	44979	194.5904928		2023-02-22				194.5905	#N/A
51	44980	199.1357406		2023-02-23				199.1357	#N/A
52	44981	202.7746354		2023-02-24				202.7746	#N/A
53	44984	206.9050592		2023-02-27				206.9051	#N/A
54	44985	210.6105658		2023-02-28				210.6106	#N/A
55	44986	214.0075073		2023-03-01				214.0075	#N/A
56	44987	216.0790596		2023-03-02				216.0791	#N/A
57	44988	218.5755059		2023-03-03				218.5755	#N/A
58	44991	220.1673647		2023-03-06				220.1674	#N/A
59	44992	221.1445891		2023-03-07				221.1446	221.1446
60	44993	221.0716714		2023-03-08				#N/A	221.0717
61	44994	220.0724243		2023-03-09				#N/A	220.0724
62	44995	218.434448		2023-03-10				#N/A	218.4344
63	44998	216.8702359		2023-03-13				#N/A	216.8702
64	44999	216.2068237		2023-03-14				#N/A	216.2068
65	45000	215.2350589		2023-03-15				#N/A	215.2351
66	45001	213.8110827		2023-03-16				#N/A	213.8111
67	45002	212.1192243		2023-03-17				#N/A	212.1192
68	45005	210.3811771		2023-03-20				#N/A	210.3812
69	45006	209.6930596		2023-03-21				#N/A	209.6931
70	45007	208.5752002		2023-03-22				#N/A	208.5752
71	45008	207.3356708		2023-03-23				#N/A	207.3357
72	45009	205.9577652		2023-03-24				#N/A	205.9578
73	45012	204.5440709		2023-03-27				#N/A	204.5441
74	45013	202.7199535		2023-03-28				#N/A	202.72
75	45014	201.4664482		2023-03-29				#N/A	201.4664
76	45015	200.066448		2023-03-30				#N/A	200.0664
77	45016	199.3913191		2023-03-31				#N/A	199.3913
78	45019	197.7919311		2023-04-03				#N/A	197.7919
79	45020	196.2913429		2023-04-04				#N/A	196.2913
80	45021	194.1332726		2023-04-05				#N/A	194.1333
81	45022	191.8631309		2023-04-06				#N/A	191.8631
82	45026	190.0882836		2023-04-10				#N/A	190.0883
83	45027	189.1386357		2023-04-11				#N/A	189.1386
84	45028	187.2331764		2023-04-12				#N/A	187.2332
85	45029	185.9736466		2023-04-13				#N/A	185.9736
86	45030	184.9419997		2023-04-14				#N/A	184.942
87	45033	184.3347052		2023-04-17				#N/A	184.3347
88	45034	183.5867284		2023-04-18				#N/A	183.5867
89	45035	182.7544456		2023-04-19				#N/A	182.7544
90
LLAdams17

Cell Formulas
Range	Formula
H2:H89	H2	=IF(AND($B2<$B1,$B2<$B3,$B2),$B2, IF($B2>N($B1),$B2,NA()))
I2:I89	I2	=IF(AND($B2>=N($B1),$B2>=$B3),$B2, IF($B2<=N($B1),$B2,NA()))

and here is the chart:

 

[LAAdams17]

THANK YOU. Helpful and appreciated!

 

[awoohaw]

My pleasure. I am happy you found a solution.

Best Wishes!