how to plot a graph in excel with different slope lines

The two new tables of data can then be plotted on the graph as second and third series of data.To achieve this, some additional data must first be generated: Max/Min lines are created using trendlines to connect the lower limit of the first data point (i.e y value minus the error) to the upper limit of the last data point and vice versa.The data (and plot generated from it) for the example used to illustrate this procedure are given below. In some ways a preferred alternative to using regression to find errors in the gradient and intercept is to add max/min lines to a graph, since this determines the error in the gradient and intercept based on the measurement errors made during the data collection rather than just relying on the statistical distribution of the data.Īlthough there is no tool to create max/min lines in Excel, it is still possible to add them by plotting additional data based using the graph error bars/values. Then, anytime TLEq is empty, line 4 errors because it cannot carry out the CDbl(Mid()) an empty TLEq.PChem Teaching Lab | Excel 10 Using Excel 2010 - Add Max/Min Lines to a Graph The issue begins in line 2 where TLEq is inconsistently left blank during the loop some iterations all the trendline equation are extracted, sometimes only some are, and other times no equations are extracted. There has been no issues with graphing, trendlines showing up, or trendline equations displaying. In lines above these (not included), the series are added, trendlines inserted, and DisplayEquation is called for each trendline. The CDbl(Mid()) is used to trim TLEq to just the slope and convert to a Double.

TLEq is a string to temporarily hold the full text of the trendline equation (intercept set to 0 so simple y = mx equation). SelectedSheets is an array filled with the sheets the user selects to be analyzed from a multi-select userform listbox. ModulusArr(j) = CDbl(Mid(TLEq, 4, Len(TLEq) - 4))

I want to report the slope average of all the trendlines and I've written the code below to do this action: For j = 1 To UBound(SelectedSheets)

I've had success with everything except extracting the trendline slopes. I'm currently making a macro to extract raw data from multiple csvs, print it in different sheets, trim extraneous data, plot data from each sheet on a single graph with individual trendlines, and report some information for said trendlines and data.

How to plot a graph in excel with different slope lines