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 |