Graph with the number of voting...

[#1]

Goodmorning everyone,
I have the following table :

YEAR	QUAD.	Class	Sez.	ES	Ita	Sto	Geo
15/15	I	1	A	A	8	8	8
15/16	I	1	A	A	7	7	7
15/16	I	1	A	A	7	7	7
15/16	I	1	A	A	8	8	8
15/16	I	1	A	A	9	9	9
15/16	I	1	A	A	6	6	6
15/16	I	1	A	A	6	6	6
15/16	I	1	A	A	7	7	7
15/16	I	1	A	A	6	6	6
15/16	I	1	A	A	8	8	8
15/16	I	1	A	A	7	7	7

how can I get something like :

Disciplina	10	9	8	7	6	5
Ita	0	1	3	4	3	0
Sto	0	1	3	4	3	0
Geo	0	1	3	4	3	0

thank you

[swuehl · Accepted solution]

Maybe like this

In your LOAD script:

CROSSTABLE (Disciplina, Vote, 5)

LOAD YEAR, QUAD, Class, [Sez.], ES, Ita, Sto, Geo

FROM YourTable;

LOAD 4+Recno() as Vote

Autogenerate 6;

Then create a pivot table chart, two dimensions, Disciplina and Vote and one expression

=Count(Vote)

Pivot Disciplina to the top.

And disable 'suppress zero values' on presentation tab.