(Excel) Plotting data series and a subset of that series on one chart
Please see the picture below how you can split your data. Also I've applied a date horizontal axis to make regression sense.
Related videos on Youtube
Lurco
Updated on September 18, 2022Comments
-
Lurco over 1 year
I have a data series associated with text labels. I'm trying to fit a line to the second half of my data. I read that in order to do so I have to make a second data series consisting of the subset of data that I wish to plot.
However if I try to add new data series (the second half of the original series), Excel puts them at the beginning of my chart. The "horizontal axis labels" are just numbers 1-6 (the original data series has the list text labels, for simplicity's sake let's say A-L). However if I try to add a subset of my labels to the second series (say: G-L), Excel changes the labels in the original series as well. And so my plots are still misaligned, and now labeled G-L, instead of A-L.
Can you suggest me a workaround on any of my steps?
EDIT: Here are screenshots to illustrate my problem (sorry for the polish language, I hope everything is clear). I should note that in my original problem I use dates instead of labels A-K. These are just for the sake of simplicity.
The data and the plot, before adding anything for the fit:
Here I add the second half of my data as a second data series for the plot:
And this is the result of trying to add the labels G-K to the second series:
-
Máté Juhász almost 9 yearsI think easiest way would be do duplicate your data already in the source (only the part for what you need to fit the line) and insert the chart after. Have you tried it already?
-
Some_Guy almost 9 yearsWhat type of chart are you using, a scatter? Could you provide a screenshot or text mockup of the arrangement of data currently? Am I to understand it is 2 separate tables with text column headers with 1 row of numerical data underneath.
-
Lurco almost 9 years@MátéJuhász I'm afraid I don't understand, I'm not very handy with Excel charts. Could you please explain what you are suggesting exactly?
-
Lurco almost 9 years@Some_Guy I added the screenshots. Yes, the text data are in fact dates.
-
-
Lurco almost 9 yearsThanks this works! Although I'm mildly annoyed that this works automatically like above, but there seems to be no simple way of adding the second series later on. Excel charts to have a lot of great ways to automatically create charts, but not a lot of ways to "manually" tinker with them.