graph with pivot table

Question

Hello!!

I would like to create a graph from a pivot table, however, I am not able to place the values ​​in the SQUAD column on the vertical axis, the result I would like to obtain is this:

example_1:

However, what I have achieved so far is this:

example_2:

Would it be possible for me to have a graph like I mentioned in example_1?

my pivot table:

my data selection for graph:

Tks!

Answer 1

I can't upload the file.

You can use the following table:

Squad;Month;LEAD TIME

Squad A;January;460,00

Squad A;February;0,00

Squad A;March;0,00

Squad B;January;0,00

Squad B;February;0,00

Squad B;March;207,00

Squad C;January;0,00

Squad C;February;48,00

Squad C;March;116,00

Squad D;January;19,33

Squad D;February;0,00

Squad D;March;0,00

Squad E;January;0,00

Squad E;February;118,00

Squad E;March;73,00

Squad F;January;159,50

Squad F;February;83,50

Squad F;March;0,00

Squad G;January;0,00

Squad G;February;50,00

Squad G;March;0,00

Squad H;January;51,67

Squad H;February;48,33

Squad H;March;35,50

Squad I;January;35,40

Squad I;February;52,40

Squad I;March;100,33

Squad J;January;0,00

Squad J;February;70,00

Squad J;March;0,00

Squad K;January;87,50

Squad K;February;0,00

Squad K;March;192,00

Squad L;January;125,78

Squad L;February;58,50

Squad L;March;92,00

and create a pivot table as below:

pivot table configuration

column ->  month

line -> Squad

values -> Sum LEAD TIME

Answer 2

The y-axis of a chart must be numeric, it cannot be a category axis.

Answer 3

We need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

Andreas.

Answer 4

It didn't work, SQUAD is in the caption

Answer 5

Try clicking Alternar Linha/Coluna