How to Create a Line Chart

Data Format

One row per data point.

X	Y
Jan	1.2
Feb	2
Mar	2
Apr	3.5

X (required): position along the horizontal axis. Can be a category name (e.g. a month) or a number, the axis adapts automatically.
Y (required, numeric): the value plotted at that point.

Add a second Y column to plot a second line. Column headers become the legend labels once there are two or more.

Chart Elements

Every part of the chart maps to a section in the style panel.

Line

The line connecting each point.

Color - single color, or a per-series color row once there are multiple Y columns.
Dash - Solid, Dashed, or Dotted, set per series.
Width - line thickness.
Smooth curve - toggles curved (spline) vs straight-segment lines. This also affects the area fill's curve.

Area Fill

The shaded region under the line, visible by default.

Color - one row per series, defaults to the same color as its line unless overridden.

Can be hidden entirely, turning this back into a plain line chart with no fill.

Point Labels

The Y value shown above each point. Hidden by default.

Color - text color.
Font / Font Size - text styling.

Axis

The Y axis is numeric with its own range and tick count, and starts at 0 by default rather than auto-fitting to the data. The X axis only has color and visibility, even when its values are numeric.

Y Min / Y Max - override the default 0-to-auto Y range.
Y Ticks - how many ticks appear on the Y axis.
X Color / Y Color - axis line color.
X Axis / Y Axis - show or hide each axis line independently.

Gridlines

Line charts have both vertical and horizontal gridlines, unlike bar and waterfall charts. Color and thickness apply to both at once, but visibility is independent per axis.

Color / Thickness - applies to both X and Y gridlines.
X Grid / Y Grid - show or hide each independently.

Axis Tick Labels

The labels along each axis share one color and font, but number formatting is set independently per axis.

Color - applies to both axes.
Font / Font Size - applies to both axes.
Prefix / Suffix - set independently for X and Y.
Rotation - set independently for X and Y.
X Labels / Y Labels - show or hide each independently.

Legend

Appears automatically once there are two or more Y columns.

Position - Top, Bottom, Right, or Direct (labels placed at the end of each line instead of a legend box).
Color - legend text color.
Font / Font Size - legend text styling.

A chart with the area fill turned on by default and emphasized is the same chart with different starting styles, see the Area Chart guide.