Basic graph with data on rows (not in columns)

[Nutella]

Hello,

I think it's not really complicated but I don't know how to do this.

I know how to trace a graph with data on columns but now my data are in rows.

Exemple:

Name     Surname     Score_September     Score_October     Score_November

Pierre      X                    15                                16                        12

Paul        Y                     12,5                             13                        15

Do you know how to trace a score graph with months on axis and name on legend?

Thank youuu !!! 🙂

Paul 🙂

[Christann · Accepted solution]

I think that to get the result that you want, you will have to unpivote the Month columns.

To do this you should choose Edit Queries on the Home tab.

Then got to the query in question and select all of the month columns.

Next, on the Transform tab choos Unpivote Columns.

Finally, hit close and apply.

Now you should be able to create the visual that you are looking for.

Is this what you were looking for?

Something like this?

[Nutella]

Yes thank you !! 🙂