Choose , then select a line plot based on your data and how you want the plot to look.

Create a line plot that displays several series of short response patterns. The worksheet must include at least one column of numeric or date/time data and two columns of categorical data. Series are defined by values in a categorical variable.

For example, the following worksheet contains the strength measurements for synthetic fibers produced on four machines by three operators. Strength contains the numeric data. Operator and Machine contain the categorical data. The graph shows a series for each machine of the strength of fibers produced by each operator.

C1 | C2 | C3 |
---|---|---|

Machine | Operator | Strength |

1 | 1 | 109 |

1 | 1 | 110 |

2 | 1 | 110 |

... | .... | ... |

For more information, go to Create a line plot of one Y variable, with symbols.

Create a line plot that displays several series of short response patterns. The worksheet must include several columns of numeric or date/time data one column of categorical data. Series are defined by separate columns or by values in the categorical variable.

For example, the following worksheet contains the diameters of pipes produced each week for three weeks, on two machines. Week 1, Week 2, and Week 3 contain the numeric data. Machine contains the categorical data. The graph shows a series for each machine of the diameter of pipes produced each week.

C1 | C2 | C3 | C4 |
---|---|---|---|

Week 1 | Week 2 | Week 3 | Machine |

5.19 | 5.57 | 8.73 | 1 |

5.53 | 5.11 | 5.01 | 2 |

4.78 | 5.76 | 7.59 | 1 |

... | ... | ... | ... |

For more information, go to Create a line plot of multiple Y variables, with symbols.

Create a line plot that displays several series of short response patterns. The worksheet must include several columns of numeric or date/time data. The worksheet can contain one column of categorical data. Data are in a two-way table where each cell contains a summarized value for the column/row combination. Series are defined by separate columns or by separate rows.

For example, the following worksheet contains the number of tires with a specific type of tire damage, per quarter. Damaged Liner, Damaged Sidewall, Leak from Seating, Puncture, Valve Core Leak, and Valve Stem Leak contain the numeric data. Quarter contains the categorical data. The graph shows a series for each damage type of the number of defective tires for each quarter.

C1-T | C2 | C3 | C4 | C5 | C6 | C7 |
---|---|---|---|---|---|---|

Quarter | Damaged Liner | Damaged Sidewall | Leak from Seating | Puncture | Valve Core Leak | Valve Stem Leak |

Q1 | 25 | 53 | 29 | 73 | 63 | 109 |

Q2 | 34 | 63 | 35 | 94 | 43 | 103 |

Q3 | 50 | 39 | 19 | 158 | 35 | 98 |

Q4 | 23 | 54 | 17 | 89 | 43 | 87 |

For more information, go to Create a line plot of series in rows or columns, with symbols.

Create a line plot that displays multiple series of long response patterns. The worksheet must at least one column of numeric or date/time data one column and two columns of categorical data. Series are defined by values in a categorical variable.

For example, the following worksheet contains near-infrared (NIR) spectral data for four samples of soybean flour. Measurement contains the numeric data. Wavelength and Sample contain the categorical data. The graph shows a series for each sample of the measurements for each wavelength.

C1 | C2 | C3 |
---|---|---|

Wavelength | Measurement | Sample |

1 | -0.023460 | 1 |

1 | 0.004122 | 2 |

1 | -0.000544 | 3 |

... | ... | ... |

For more information, go to Create a line plot of one Y variable, without symbols.

Create a line plot that displays multiple series of long response patterns. The worksheet must contain multiple columns of numeric or date/time data and one column of categorical data. Series are defined by values in the categorical variable.

For example, the following worksheet contains the concentrations of nine elements in three samples of wine. Cr, Sr, Pb, and so on contain the numeric data. Sample contains the categorical data. The graph shows a series for each sample of the concentration of each element.

C1 | C2 | C3 | C4 | ... | C10 |
---|---|---|---|---|---|

Cr | Sr | Pb | B | ... | Sample |

0.063 | 0.192 | 0.777 | 5.56 | ... | 1 |

0.021 | 0.172 | 0.232 | 3.79 | ... | 1 |

0.021 | 0.358 | 0.035 | 4.34 | ... | 1 |

... | ... | ... | ... | ... | ... |

For more information, go to Create a line plot of multiple Y variables, without symbols.

Create a line plot that displays multiple series of long response patterns. The worksheet must include multiple columns of numeric or date/time data one column of categorical data. Data are in a two-way table where each cell contains a summarized value for the column/row combination. Series are defined by separate columns or by separate rows.

For example, the following worksheet contains the chromatogram profiles for samples of gasoline at various octanes. 900 through 1600 contain the numeric data. The octane column contains the categorical data. The graph shows the chromatogram profile for each octane of gasoline.

C1 | C2 | C3 | ... | C37 |
---|---|---|---|---|

900 | 920 | 940 | ... | octane |

0.213751 | 0.236162 | 0.211233 | ... | 84.9 |

0.221843 | 0.241514 | 0.216588 | ... | 91.7 |

0.220893 | 0.241153 | 0.215574 | ... | 91.2 |

... | ... | ... | ... | ... |

For more information, go to Create a line plot of series in rows or columns, without symbols.