ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAP
1
Drawing a Fan Chart Using Python in Excel
2
Between the Sheets: Duncan Williamson
#NAME?#NAME?#NAME?
3
4
DateActualForecastValuesLower 50%Upper 50%Lower 75%Upper 75%Lower 90%Upper 90%
5
1/1/20240.90.9
6
1/2/20240.80.8
7
1/3/20240.90.9
8
1/4/20242.72.7
9
1/5/20243.13.1
10
1/6/20243.73.7
11
1/7/20243.53.5
12
1/8/202455
13
1/9/20244.84.8
14
1/10/20246.36.3
15
1/11/20247.77.7
16
1/12/20248.48.4
17
1/13/20248.58.5 8.10 8.90 7.81 9.19 7.33 9.67
18
1/14/20248.68.6 7.79 9.41 7.22 9.98 6.26 10.94
19
1/15/20248.28.2 6.99 9.41 6.14 10.26 4.68 11.72
20
1/16/20247.67.6 5.99 9.21 4.85 10.35 2.91 12.29
21
1/17/20247.57.5 5.48 9.52 4.06 10.94 1.64 13.36
22
1/18/20247.37.3 4.88 9.72 3.17 11.43 0.27 14.33
23
1/19/20246.96.9 4.08 9.72 2.09 11.71 - 1.30 15.10
24
1/20/20246.66.6 3.37 9.83 1.10 12.10 - 2.77 15.97
25
1/21/20247.27.2 3.57 10.83 1.01 13.39 - 3.35 17.75
26
1/22/20247.57.5 3.46 11.54 0.62 14.38 - 4.22 19.22
27
1/23/20247.87.8 3.36 12.24 0.24 15.36 - 5.09 20.69
28
1/24/20248.28.2 3.36 13.04 - 0.05 16.45 - 5.86 22.26
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100