How to create an excel graph with several series stored in rows not in columns

Question

I have an excel table (date, type, count) and I'd like to make a graph that will plot as much lines as there are different value of type. If the different values were in multiple columns, I can do it.

Imagine this table:

01/01/2023	A	10
01/01/2023	B	15
01/01/2023	C	12
02/01/2023	A	11
02/01/2023	B	14
02/01/2023	C	13

In this case there would be 3 lines because there are 3 different values A, B, C.

Answer 1

Hi,

You can try to create a Pivot Chart for the table:

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.