Rearranging data to make a line chart with multiple series
Our take
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Stacked scatter plot with same y-axis for readabilityIm working with SCADA and pulling together data from a model to compare the 2 at a couple of different locations. Is there a way to stack 3 graphs in excel without completely manually doing it? the data is all for the same week in sub minute increments, so needs to be a scatter plot. and y-axis is all the same so its not a like a secondary axis is beneficial in this case. below is the plots with all the data, very hard to parse unless someone explains what's going on. https://preview.redd.it/cgyalit9wyzg1.png?width=1426&format=png&auto=webp&s=b03a3d9022a3efc482d6d3161a52186c1c745f36 below is what I'd like the graphs to look like, done in ppt. Kind of annoying to do manually and there's a couple of other locations I need to do this for, so if there's a better solution, let me know! https://preview.redd.it/9003h0vwvyzg1.png?width=848&format=png&auto=webp&s=e5af1d78cde58175ed5451fbb4e85f06a4f89815 submitted by /u/MyGoddamnFeet [link] [comments]
- I want to create a chart like on the first photo with the provided data on the second photo. How do I go about doing that?I want the chart to add all my amounts per month per year, but each month per year to be next to each other. The description from the table is not necessary in the chart. https://preview.redd.it/8e8eiva05ryg1.png?width=784&format=png&auto=webp&s=8f50f1ce1e5038aad458133ba165124f62acb6d9 https://preview.redd.it/qsn12va05ryg1.png?width=710&format=png&auto=webp&s=2e3a0ecd4c451f92fca07ddfc9e7aee1aaf5e308 submitted by /u/Xepherious [link] [comments]
- Why are my plotted graphs coming out different?Currently doing a chemistry report. For my x-axis I want to have cells B3,B4,B5,B6, with the axis title called 1/K, and my y-axis to have D3,D4,D5,D6 with axis title ln(Kx). But when I highlight these cells and click insert Line with markers chart is shows me 2 separate lines one for 1/k and another for ln(kx), but I just want 1 single line, I did this in the past with another line chart in which I used Time and Temperature and got a single line but now doing the same thing this happens. Any help? submitted by /u/Downtown_Movie_9218 [link] [comments]