More Information

Line Charts

These charts display trends of values of data series over time or categories, or across sorted values of a numeric variable. Line segments connect the data points of each series, and the data series can be displayed by line properties or line plus marker properties.

In a horizontal style plot, data from each worksheet row have the same X coordinate and unique Y coordinates. In a vertical style plot, data from each worksheet row have the same Y coordinate and unique X coordinates.


X-Y Line Series Charts

  • X-Y line series (sort along X values)
  • X-Y line series (sort along Y values)
  • Line series (across X categories)
  • Line series (across Y categories)

An X-Y Line Series Chart (Sort Along X Values)

Breaking Series Lines for Missing Data

  • In an X-Y line chart, you have the option of breaking series lines for missing data, as shown in the image below:

Breaking Series Lines Across X Categories

Double Y, Double X, and Double X-Y Line Charts

  • Double Y line series (sort along X)
  • Double X line series (sort along Y)
  • Double Y line series (across X categories)
  • Double X line series (across Y categories)
  • Double X-Y line series (sorted along X1, X2)
  • Double X-Y line series (sorted along Y1, Y2)

In a double Y line chart, the X-axis of the graph can be a numeric variable, a variable of type date (see the image to the right), or a categorical variable (see the right-hand side image below).

In a double Y, double X line chart, data from the Y1 and Y2 series are plotted against the sorted values of X1 and X2 series; here, all axes are numeric (see the left-hand side image below).

A Double-Y, Single-X Line Chart With X-Axis Representing Date

A Double-Y, Double-X Line Chart

A Double-Y, Single-X Line Chart With X-Axis Representing Categories

Paired X-Y Line Charts

A paired X-Y line chart displays trends of values of one or more data series, each having unique X-Y coordinates (i.e., in each series, X and Y are paired).

  • Horizontal paired X-Y line
  • Vertical paired X-Y line

A Paired X-Y Line Chart