Spreadsheet: 487495d1478108099-using-listbox-to-select-multiple-series-for-chart-dynamically-book1-41-
Sheet: Dynamic Chart

 | You can uncheck the test cases by selecting the graph and unmark the fields you do not want
 | (I do not mark the Test Case C neither the months set , out)
 | Valores
Date | Soma de Case C - 3 | Soma de Case D - 4 | Soma de Case A - 1
01-jan | 62.2 | 44.22 | 75
02-jan | 59.46 | 46.17 | 70.74
05-jan | 59.21 | 46.12 | 68.92
06-jan | 61.21 | 46.15 | 65.78
07-jan | 61.24 | 45.99 | 63.17
08-jan | 75 | 45.97 | 63.86
09-jan | 70.74 | 45.69 | 64.02
12-jan | 68.92 | 45.93 | 62.2
13-jan | 65.78 | 45.66 | 59.46
14-jan | 74 | 46.16 | 59.21
15-jan | 50 | 46.39 | 61.24
16-jan | 72.29 | 47.15 | 61.13
19-jan | 55 | 46.9 | 61.21
20-jan | 71.1 | 51.35 | 60.23
21-jan | 71.2 | 53.92 | 60.54
22-jan | 74.17 | 53.87 | 60.37
23-jan | 74.25 | 55.29 | 61.72
26-jan | 75.6 | 56.18 | 60.25
27-jan | 73.46 | 56.65 | 60.15
28-jan | 74.37 | 55.27 | 60.64
29-jan | 73.94 | 53.69 | 60.12
30-jan | 73.75 | 55.96 | 60.21
02-fev | 72.38 | 59.48 | 62.51
03-fev | 71.41 | 60.6 | 66.24
04-fev | 66.87 | 59 | 68.75
05-fev | 66.64 | 53.18 | 65.97
06-fev | 66.71 | 49.49 | 68.94
09-fev | 69.05 | 48.44 | 70.01
10-fev | 67.4 | 47.54 | 70.9
11-fev | 67.53 | 47.76 | 70.5
12-fev | 68.26 | 46.49 | 70.18
13-fev | 67.62 | 45.45 | 73.61
16-fev | 71.18 | 43.86 | 73.48
17-fev | 70.06 | 44.22 | 73.95
18-fev | 69.05 | 46.17 | 74
19-fev | 67.99 | 46.12 | 55
20-fev | 67.98 | 46.15 | 50
23-fev | 69.01 | 45.99 | 72.29
24-fev | 21 | 45.97 | 71.1
25-fev | 68.51 | 45.69 | 71.2
26-fev | 69.16 | 45.93 | 74.17
27-fev | 69.86 | 45.66 | 74.25
02-mar | 68.02 | 46.16 | 75.6
03-mar | 68.19 | 46.9 | 73.46
04-mar | 79.74 | 46.39 | 74.37
05-mar | 77.43 | 47.15 | 73.94
06-mar | 77.62 | 51.35 | 73.75
09-mar | 77.95 | 53.92 | 72.38
10-mar | 80.05 | 53.87 | 71.41
11-mar | 78.96 | 55.29 | 70.38
12-mar | 78.98 | 56.18 | 71.57
13-mar | 79.23 | 56.65 | 69.64
16-mar | 77 | 55.27 | 66.87
17-mar | 76.26 | 53.69 | 66.64
18-mar | 76.42 | 46.17 | 66.71
19-mar | 77.75 | 46.12 | 69.05
20-mar | 76.07 | 46.15 | 67.4
23-mar | 76.5 | 45.99 | 67.53
24-mar | 75.62 | 45.97 | 68.26
25-mar | 74.23 | 45.69 | 67.62
26-mar | 74.71 | 45.93 | 71.18
27-mar | 43 | 45.66 | 70.06
30-mar | 77.38 | 46.16 | 69.05
31-mar | 76.63 | 46.9 | 67.99
01-abr | 74.14 | 46.39 | 67.98
02-abr | 72.53 | 47.15 | 69.01
03-abr | 73.63 | 51.35 | 21
06-abr | 73.88 | 53.92 | 68.51
07-abr | 76.99 | 53.87 | 69.16
08-abr | 76.46 | 55.29 | 69.86
09-abr | 74.97 | 56.18 | 68.02
10-abr | 73.91 | 56.65 | 68.19
13-abr | 73.6 | 55.27 | 71.24
14-abr | 74.23 | 53.69 | 70.41
15-abr | 74.86 | 55.96 | 70.93
16-abr | 74.55 | 59.48 | 73
17-abr | 73.58 | 60.6 | 73.76
20-abr | 66.69 | 59.57 | 73.46
21-abr | 65.15 | 59.81 | 73.13
22-abr | 66.39 | 57.65 | 72
23-abr | 67.04 | 59.37 | 72.76
24-abr | 65.89 | 58.32 | 75.44
27-abr | 65.03 | 58.06 | 75.39
28-abr | 65.71 | 57.2 | 74.63
29-abr | 63.87 | 58.83 | 74.49
30-abr | 64 | 59.47 | 76.89
01-mai | 63.58 | 58.58 | 32
04-mai | 63.09 | 58.94 | 77.51
05-mai | 63.34 | 57.13 | 77.23
06-mai | 62.95 | 58.36 | 79.74
07-mai | 62.22 | 58.11 | 79.74
08-mai | 60.69 | 57.26 | 77.43
11-mai | 58.81 | 54.43 | 77.62
12-mai | 58.98 | 55.07 | 77.95
13-mai | 60.24 | 55.04 | 80.05
14-mai | 59.46 | 53.07 | 78.96
15-mai | 58.21 | 50.54 | 78.98
18-mai | 58.37 | 50.08 | 79.23
19-mai | 57.92 | 50.82 | 77
20-mai | 57.48 | 51.01 | 76.26
21-mai | 50 | 51.95 | 76.42
22-mai | 54 | 52.21 | 77.75
25-mai | 59.33 | 52.3 | 76.07
26-mai | 58.34 | 52.75 | 76.5
27-mai | 59.43 | 55.66 | 75.62
28-mai | 57.57 | 54.86 | 74.23
29-mai | 56.98 | 52.52 | 74.71
01-jun | 57.21 | 52.3 | 43
02-jun | 57.85 | 53.92 | 77.38
03-jun | 55.85 | 52.5 | 76.63
04-jun | 55.21 | 2 | 74.14
05-jun | 53.61 | 11 | 72.53
08-jun | 52.58 | 55.99 | 73.63
09-jun | 52.82 | 54.82 | 73.88
10-jun | 53.73 | 54.32 | 76.99
11-jun | 56.11 | 55.29 | 76.46
12-jun | 58.04 | 55.46 | 74.97
15-jun | 61.16 | 56.09 | 73.91
16-jun | 58.17 | 57.83 | 73.6
17-jun | 60.37 | 59.52 | 74.23
18-jun | 61.02 | 61.23 | 74.86
19-jun | 60.06 | 60.87 | 74.55
22-jun | 58.98 | 60.27 | 73.58
23-jun | 60.76 | 60.41 | 73.29
24-jun | 58.66 | 62.6 | 75.18
25-jun | 56 | 62.84 | 73.5
26-jun | 58.54 | 62.99 | 72.69
29-jun | 57.68 | 62.93 | 71.25
30-jun | 57.99 | 64.22 | 71.98
01-jul | 59.17 | 64.41 | 72.33
02-jul | 58.85 | 64.19 | 71.17
03-jul | 57.77 | 22 | 71.15
06-jul | 57.96 | 65.8 | 68.63
07-jul | 60.07 | 66.16 | 66.69
08-jul | 62 | 64.36 | 65.15
09-jul | 58.62 | 63.42 | 66.39
10-jul | 58.23 | 62.49 | 67.04
13-jul | 57.56 | 64.78 | 65.89
14-jul | 57.98 | 65.92 | 65.03
15-jul | 58.57 | 65.03 | 65.71
16-jul | 57.79 | 64.56 | 63.87
17-jul | 58.46 | 64.34 | 64
20-jul | 58.93 | 62.62 | 63.58
21-jul | 62.44 | 62.74 | 63.09
22-jul | 61.38 | 64.8 | 63.34
23-jul | 62.38 | 63.57 | 62.95
24-jul | 61.98 | 12 | 62.22
27-jul | 59.27 | 61.38 | 60.69
28-jul | 58.05 | 60.9 | 58.81
29-jul | 57.98 | 59.87 | 58.98
30-jul | 58.59 | 62.66 | 60.24
31-jul | 58.26 | 62.18 | 59.46
03-ago | 56.99 | 63.29 | 58.21
04-ago | 56.79 | 62.31 | 58.37
05-ago | 57.58 | 60 | 57.92
06-ago | 58 | 59.91 | 57.48
07-ago | 57.38 | 60.62 | 50
10-ago | 56.07 | 62.46 | 54
11-ago | 56.36 | 63.08 | 59.33
12-ago | 75 | 62.46 | 58.34
13-ago | 70.74 | 62.13 | 59.43
14-ago | 68.92 | 60.76 | 57.57
17-ago | 65.78 | 60.8 | 56.98
18-ago | 63.17 | 60.8 | 57.21
19-ago | 63.86 | 61.61 | 57.85
20-ago | 64.02 | 60.02 | 55.85
21-ago | 62.2 | 59.77 | 55.21
24-ago | 59.46 | 45.48 | 53.61
25-ago | 59.21 | 47.72 | 52.58
26-ago | 61.21 | 46.76 | 52.82
27-ago | 61.24 | 46.47 | 53.73
28-ago | 61.13 | 45.92 | 56.11
31-ago | 60.23 | 44.96 | 58.04