How yo combine multiple series in a line graph

Hi!

I am trying to make a single line graph for multiple data.

I have 14 samples (columns) and about 30 entries of dates (rows), so 420 data pieces in total. I would like to make a graph where I can get a single graph that combines all data into one line, to see overall trend of the data.

When I try to make a graph, it makes 14 different series, and I can only see trendlines of each individual sample. I can get around this, by copying the 30 date rows 14 times and posting the entire data set in two columns. This gives me one single line, which can let me analyze the data as a whole, however it is time consuming.

Is there any way to do this with my original 14 columns?

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

OK, bit tedious and there may be a better way of combining the ranges but here you go:

Formula:

Please Login or Register  to view this content.

Then chart the columns where you output the combined range.

Please see the updated sample file

You're welcome. Thanks for the rep.