how to plot a graph in excel with two lines

The chart generated by the above data are shown below.The box and whisker plot, sometimes simply called the box plot, is a type of graph that help visualize the five-number summary.

Dates of Data Collection: enter the dates of data collection optional, if printed will appear in the lower left-hand corner of the chart.

Enter Title and Labels: enter the title, y-axis label, and x-axis label there is no default title, but the default for the y-axis is 'Y' while the default for the x-axis is the first cell in the column containing the x values.

Enter range: enter the worksheet range containing the data and the headings the data must be in columns with the x values in the first column followed by the y values in adjacent columns the default is the range selected on the worksheet.

The default is the range selected on the worksheet. The following input box is used to enter the range containing the data and the headings. Select the 'Plot Multiple Y Variables Against One X Variable' option and then OK.ĥ.

Select 'Correlation' from the 'Statistical Tools' panel on the SPC for Excel ribbon.Ĥ. Select the data and the column headings.ģ.

Enter the data into a worksheet as shown below. The data can be downloaded at this link.Ģ.

The experimenter wants to compare the measured amps to the theoretical amp.ġ. An example of how to create this chart is given below for plotting two Y variables against the X variable.Īn experiment has been to do to measure the amps from a process over time. The Y variables must be in adjacent columns. The data for this chart must be in columns with the X variable in the first column. The program will plot multiple Y variables against one X variable.

How to plot a graph in excel with two lines