Data Total Notas Cxs volume peso

30-Sep 0 0 0 0
1-Oct 0 0 0 0
2-Oct 0 0 0 0
3-Oct 0 0 0 0
4-Oct 0 0 0 0
5-Oct 0 0 0 0
6-Oct 0 0 0 0
7-Oct 0 0 0 0
8-Oct 0 0 0 0
9-Oct 0 0 0 0
10-Oct 0 0 0 0
11-Oct 0 0 0 0
12-Oct 5757 575 575 4545
13-Oct 2 5 8 555
14-Oct 44 44 85 456
15-Oct 57 4900 76.57 26822
16-Oct 0 0 0 0
17-Oct 0 0 0 0
18-Oct 0 0 0 0
19-Oct 0 0 0 0
20-Oct 0 0 0 0
21-Oct 0 0 0 0
22-Oct 0 0 0 0
23-Oct 0 0 0 0
24-Oct 0 0 0 0
25-Oct 0 0 0 0
26-Oct 0 0 0 0
27-Oct 0 0 0 0
28-Oct 0 0 0 0
29-Oct 0 0 0 0
30-Oct 0 0 0 0
31-Oct 0 0 0 0
 Data Total Notas Cxs volume peso
Criei uma tabela dinamica para cada um dos itens que precisa mensurar (exemplo acima)
Selecione as tabelas, uma por uma e crie um tipo de gráfico diferente para cada.

Data2 Soma de Total Notas Data2 Soma de Cxs

30-Sep 0 30-Sep 0
1-Oct 0 1-Oct 0
2-Oct 0 2-Oct 0
3-Oct 0 3-Oct 0
4-Oct 0 4-Oct 0
5-Oct 0 5-Oct 0
6-Oct 0 6-Oct 0
7-Oct 0 7-Oct 0
8-Oct 0 8-Oct 0
9-Oct 0 9-Oct 0
10-Oct 0 10-Oct 0
11-Oct 0 11-Oct 0
12-Oct 5757 12-Oct 575
13-Oct 2 13-Oct 5
14-Oct 44 14-Oct 44
15-Oct 57 15-Oct 4900
16-Oct 0 16-Oct 0
17-Oct 0 17-Oct 0
18-Oct 0 18-Oct 0
19-Oct 0 19-Oct 0
20-Oct 0 20-Oct 0
21-Oct 0 21-Oct 0
22-Oct 0 22-Oct 0
23-Oct 0 23-Oct 0
24-Oct 0 24-Oct 0
25-Oct 0 25-Oct 0
26-Oct 0 26-Oct 0
27-Oct 0 27-Oct 0
28-Oct 0 28-Oct 0
29-Oct 0 29-Oct 0
30-Oct 0 30-Oct 0
31-Oct 0 31-Oct 0
Total Result 5860 Total Result 5524
 Esta forma representa uma
segmentação de dados.
Segmentações de dados têm
Data2 Soma de volume
suporte no ExcelData2
2010 ou Soma de peso
30-Sep versões
0 posteriores.
30-Sep 0
1-Oct 0 1-Oct 0
\Se a forma tiver sido
2-Oct 0
modificada 2-Oct
em uma versão 0
3-Oct 0 3-Oct
anterior do Excel, ou se a 0
4-Oct 0 de trabalho4-Oct
pasta tiver sido 0
5-Oct salva
0 no Excel 2003
5-Octou 0
versões anteriores, a
6-Oct 0 6-Oct 0
segmentação de dados não
7-Oct poderá ser usada.7-Oct
0 0
8-Oct 0 8-Oct 0
9-Oct 0 9-Oct 0
10-Oct 0 10-Oct 0
11-Oct 0 11-Oct 0
12-Oct 575 12-Oct 4545
13-Oct 8 13-Oct 555
14-Oct 85 14-Oct 456
15-Oct 76.57 15-Oct 26822
16-Oct 0 16-Oct 0
17-Oct 0 17-Oct 0
18-Oct 0 18-Oct 0
19-Oct 0 19-Oct 0
20-Oct 0 20-Oct 0
21-Oct 0 21-Oct 0
22-Oct 0 22-Oct 0
23-Oct 0 23-Oct 0
24-Oct 0 24-Oct 0
25-Oct 0 25-Oct 0
26-Oct 0 26-Oct 0
27-Oct 0 27-Oct 0
28-Oct 0 28-Oct 0
29-Oct 0 29-Oct 0
30-Oct 0 30-Oct 0
31-Oct 0 31-Oct 0
Total Result 744.57 Total Result 32378