Yearly Totals in Separate Columns

[John Meyers 2]

Hello.

Let's say I have a dataset with different teamsby row and the annual wins by each of those teams in year-by-year columns... how do I plot this as a line chart with "year" on the x-axis, "annual wins" on the y-axis and three different lines (one for each team)

The issue I'm running into is creating the individual"year" columns into one continuous time series.

Team 2001 2002 2003 2004 2005

A 5 6 1 3 4

B 1 4 6 1 3

C 5 2 1 2 4

Thanks for your help!

[Kirsten Smith (she/her)]

You'll need to unpivot your data, so that you have a column with dates, a column for teams, and a column for wins. Then you can create your line chart using the team column for "Line By".

[John Meyers 2]

Hmm ... thanks for the response but I highly simplified the description of my dataset and it is just not possible to transpose my actual data.  Is there no other way to plot the (overly simplistic) dataset above as a line chart versus year without first modifying it