Rearranging data to make a line chart with multiple series
I want to make a set of line charts with multiple series each with the following: Sampling Date is on the x-axis | SSILT63_2 (%) (or any variable from columns C-E) is on the y-axis, and each series in the chart is named after the different points in Column A.
I tried selecting Columns A-C to make the first chart, but instead of making multiple series, it made a single series instead.
It works when I transpose the data with the points as different columns and the dates as the rows, but the issue then is that I have to manually arrange it, which takes a lot of time for a single variable.
I am wondering if there is a function or feature to either:
* Have Excel recognise different series from Column A in image 1
* Quickly / automatically rearrange the data from image 1 to look like the table in image 2
Edit: I am using Excel for Mac, Version 16.108 (26041219)
[link] [comments]
Want to read more?
Check out the full article on the original site