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

Jan Vávra 256 Reputation points

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.

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,671 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emi Zhang-MSFT 23,661 Reputation points Microsoft Vendor


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

    User's image

    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.

0 additional answers

Sort by: Most helpful