CODEWITHSUNDEEP
excelexcel-2010
Cenderze
Cenderze

Reputation: 1222

Excel: Adding a regression line into an existing graph with multiple lines

I'm having a line graph of production waste corresponding to four different production sites. However, I want to include a trend line (regression) in the same graph. This regression should conduct a trend line of the total production waste of the production sites.

I.e. if production site 1 through 4 has a production waste of 2 units each month, I want the regression to be a flat line at y = 8.

Is this possible? I'm using Excel 2010.

EDIT: I've realized that it is not possible to make a regression line without converting the regular graph into a scatter plot first (or is it..?). However the initial question remains.

Upvotes: 0

Views: 1102

Answers (1)

teylyn
teylyn

Reputation: 35915

Add the total of all sites as a data series to the line chart and then add a trend line for the total series. Format the total series to show no line and only the trend line will be visible. In the screenshot the dotted line is a polynomial trend line on the total series, which has been hidden by formatting with no line.

enter image description here

Upvotes: 2

Related Questions