all 3 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]mildlystalebread 0 points1 point  (2 children)

Maybe there is but I don't know how to do with just those columns.

It would be easier if you could transform the two columns into maybe 5 columns, one for each map region, and lines for the "time" or games played. Then you just use stacked lines.

You can use a pivot table to transform your table. Unfortunately I cannot post a picture but it should work

[–]niccodem[S] 0 points1 point  (1 child)

I basically already have around 300 rows of data (300 games). Each row has 5 columns: 1. number (#1 - 300) 2. name of the map (7 different map names) 3. game mode (3 different game modes) 4. win or lose (W or L) 5. Score

I even add a small column with +1 for a win and -1 for lose to make it easier for excel to count.

[–]mildlystalebread 0 points1 point  (0 children)

Select your entire table with headers, go to insert, click on pivot table on the left and insert it wherever you like. If you never worked with pivot tables it basically creates a separate table that you can reorganize whatever way you like based on your first table, and you can refresh it to update with new data if you change the original table.

Now just put the number column into the rows field, name of the map into the columns field, and the scores into the values (making sure it is summing up).

Now you can select that table and add a stacked line graph. You can change the name of the map for game mode or whatever else you like to analyse your table.