My team has a spreadsheet in which we track counts of incidents of known issues from week to week. The sheet is organized with the issue title in column A and "Week 1" through "Week [N]" in columns B through [N].

```
           | Week1 | Week2 | Week3 | ...
-----------+-------+-------+-------+---------
 Issue1    |   50  |   40  |   30  |
-----------+-------+-------+-------+---------
 Issue2    |   10  |   30  |    0  |
-----------+-------+-------+-------+---------
 Issue3    |  100  |  200  |  150  |

```

It seems that every chart type assumes that you're going to place dates in a column and enumerate the issues across the first row. This doesn't work for our data, though, as we have hundreds of issues, and we're only trying to track the past 12 weeks or so.

The line graph I want has the weeks listed in the X axis, the counts in the Y axis, and the error titles as the various series. I was able to (almost) create the effect I want using a connected scatter plot, but I had to enter each series by hand, and (as I mentioned) there are a lot.

Is there a way to create a transposed graph without having to transpose my data?

Thanks.