Hello. I am trying to create a trend line for multiple series of data. Is it possible to have trend lines for only a specific data series within the same chart? For example, in the chart below, I'd like to have a trend line for Student ELA, ELA CA, Student Math, and CA Math but the trend line only represent that specific data series.
When I add trend lines to the secondary axis data series (Student Math & CA Math), the trend line includes the cells with the primary axis series data. See below
I can change the data for the primary series of data to only include the data I want and have the trend line represent that set of data.
However, when I try to do that for the secondary set of data, I am not able to do the same where the trend line only includes that set of data. Here is what I get when I change the series of data to only include the 2nd set of data. It moves the data over to the left side of the graph instead of staying on the right
This is what I would like to happen (I added these lines manually via shapes)
Please let me know if I can provide any additional information to make this make sense. Thank you!
When I add trend lines to the secondary axis data series (Student Math & CA Math), the trend line includes the cells with the primary axis series data. See below
I can change the data for the primary series of data to only include the data I want and have the trend line represent that set of data.
However, when I try to do that for the secondary set of data, I am not able to do the same where the trend line only includes that set of data. Here is what I get when I change the series of data to only include the 2nd set of data. It moves the data over to the left side of the graph instead of staying on the right
This is what I would like to happen (I added these lines manually via shapes)
Please let me know if I can provide any additional information to make this make sense. Thank you!
