I'm doing a data reduction project for excel and I need to draw a chart using given data. But the regression line should overlap the trending line.These data has taken from a machine which send out some fault data in the first few seconds and last few seconds when it runs.
Capture.PNG
What I needs to do is select the range for a graph neglecting those false data.Is this possible to do using macro?
Capture2.PNG
Bookmarks