Edilitics | Data to Decisions

Line Chart

Track how a single measure changes over time or across an ordered sequence. Best when the trend, rate of change, or pattern over time is the question.

A line chart - also called a line graph or trend chart - connects data points with a continuous line to show how a single measure changes over time or across an ordered sequence. Drop one date or categorical field into Column and one numeric field into Row. Use it when the question is about trend, direction, or rate of change rather than the magnitude of individual values.

When to Use

The line chart is the default choice for any time-based question. It makes the shape of change visible - acceleration, deceleration, plateaus, seasonal patterns - in a way that a bar chart cannot. The connecting line implies continuity: each point is part of a sequence, not a standalone value.

A line chart implies continuity between points. If your dimension is categorical with no natural order - product names, regions, sales reps - connecting them with a line implies a relationship between adjacent categories that does not exist. Use a Bar Chart or Horizontal Bar for unordered categories.

Switch to a different chart when:

  • The dimension is unordered categories - use Horizontal Bar
  • You have multiple measures to compare over time - use Stacked Line or multiple line charts
  • You need to show volume under the line - use Area Chart
  • The question is about composition over time - use Stacked Area
  • You have two measures on different scales - use Combo Chart
ScenarioDimensionMeasure
Monthly recurring revenue over the past yearMonthSum of MRR
Daily active users over 90 daysDateCount of active users
Average support ticket resolution time by weekWeekAverage resolution hours
Conversion rate by weekWeekConversion rate %
Net promoter score by quarterQuarterAverage NPS

Required Inputs

FieldTypeCount
DimensionDate or Ordered CategoricalExactly 1
MeasureNumericExactly 1

For step-by-step build instructions, see Build Your First Chart.

Formatting Options

The Format tab unlocks after at least one field is assigned. Once your chart is rendering, use these controls to define how it looks and how viewers interact with it.

Style

Use the chart title to state the trend question. On a line chart, the title should say what is being tracked and over what period - viewers will read it before they look at the axis labels.

ControlWhat it does
Show Chart TitleShows or hides the title. The text is preserved when hidden so you can toggle it back without re-entering.
Enter Chart TitleTitle text. Maximum 50 characters.
Font familyFont applied to the title.
Font size5 to 30.
Bold / ItalicWeight and style.
AlignmentLeft, center, or right within the chart container.

Reach for Line Styles to change the visual character of the line - whether it curves, its color, and what marker sits at each data point.

ControlWhat it does
Smooth LineReplaces straight line segments with a curved spline. On by default. Use when the overall trend shape matters more than the exact path between specific points. Turn off when sharp peaks or drops need to be precisely visible.
Line ColorColor of the line.
Shape ColorColor of the marker symbol at each data point. Set to match or contrast the line color.
ShapeThe marker symbol at each data point: Circle, Rectangle, Triangle, Diamond, Pin, or Arrow. Circle is the default. If Symbol Type is also set in Symbol Styles, Symbol Styles overrides this selection - Symbol Styles Type takes precedence over Line Styles Shape.

Symbol Styles gives independent control over whether data point markers appear and how large they are. Use it when the line is dense and markers add clutter, or when you need larger markers for sparse data.

ControlWhat it does
Show SymbolsShows or hides the marker at each data point. Turn off when there are more than around 50 data points and markers clutter the line. Keep on when data is sparse and viewers need to locate exact points.
Symbol TypeThe marker shape: Circle, Rectangle, Triangle, Diamond, Pin, Arrow, or None. None hides markers without using the Show Symbols toggle.
Symbol SizeDiameter of the marker, 0 to 20. Default is 7. Increase for sparse data where each point needs to be individually readable. Decrease for dense data.

Data labels print the value next to each data point. Use them sparingly - on a line chart with more than 15 to 20 points, labels overlap and make the chart unreadable. They are most useful on short time series (monthly or quarterly) where each value needs to be visible without hovering.

ControlWhat it does
Show Data LabelsShows or hides value labels at each data point.
Font familyFont applied to data labels.
Font sizeMaximum 18. Keep at 10 or below on any chart with more than 12 data points.
Bold / Italic / ColorText styling.
PositionVertical and horizontal alignment of the label relative to the data point. Top places the label above the point and is the most readable on a line chart.
Number TypeDefault, Scientific, Decimal, or Percentage.
Display UnitNone, Thousand, Million, or Billion. Match to the Y-axis Display Unit.
Decimal Places0 to 6. Available when Number Type is not Default.

Axes

The X-axis carries the time dimension; the Y-axis carries the measure. Name the Y-axis with the unit - "Revenue ($M)", "Users", "Rate (%)" - so viewers can read values without hunting for a legend.

Select X or Y before making changes. Settings apply to the selected axis only.

ControlWhat it does
Show Axis NameShows or hides the axis name label.
Axis name textLabel text. Maximum 20 characters. Defaults to the field name.
Font familyFont applied to the axis name.
Font size5 to 30.
Bold / ItalicWeight and style.
Offset (%)Distance between the axis name and the axis line. Increase if the axis name overlaps the axis labels.
AlignmentStart, center, or end along the axis.

Leave these at their defaults unless you are building a minimal dashboard layout.

Select X or Y before making changes.

ControlWhat it does
Show Axis LineShows or hides the axis line. Hiding it also hides ticks.
Line ColorColor of the axis line.
Line WidthThickness of the axis line, 0 to 5.
Line TypeSolid, Dashed, or Dotted.
Show TicksShows or hides tick marks on the axis line.
Tick ColorColor of the tick marks.
Tick LengthLength of the tick marks, 5 to 10.
Boundary GapWhen off, the line starts and ends at the chart edges. When on, padding is added so the first and last points sit away from the edges. Turn off for a clean edge-to-edge line on time series charts.

Select X or Y before making changes. Hiding axis labels also hides the axis name.

ControlWhat it does
Show Axis LabelShows or hides labels along the axis.
Font familyFont applied to axis labels.
Font sizeLabel font size.
Bold / Italic / ColorText styling.
RotationAngle of label text. Useful on X-axis when date labels are long and overlap.
Text caseTitle Case, Uppercase, or Lowercase. Available on the categorical axis (X) only.
Display UnitAuto, None, Thousand, Million, or Billion. Available on the value axis (Y) only.

Y-axis grid lines give viewers a horizontal reference to read values from the line. X-axis grid lines are rarely needed on a line chart - vertical grid lines add visual noise without helping viewers read the time axis.

Select X or Y before making changes.

ControlWhat it does
Show GridlinesShows or hides grid lines for the selected axis.
Grid ColorColor of the grid lines.
Left / Right / Top / BottomPlot area margins as a percentage. Increase Bottom when X-axis date labels are clipped. Increase Top when data labels above the line's peak are cut off.

Interactivity

Set Tooltip Trigger to Axis on a line chart - it snaps the tooltip to the nearest X position and shows the value for that date or category without requiring precise cursor placement on the line itself.

ControlWhat it does
Show TooltipShows or hides the tooltip on hover.
TriggerItem: tooltip appears only when the cursor is directly over a data point marker. Axis: tooltip snaps to the nearest X position across the full chart height. Use Axis - it is far easier to hover on a time series.
PointerWhen Trigger is Axis: Line, Shadow, Cross, or None. Line draws a vertical rule at the hovered position and is the clearest indicator on a single-series line chart.
Background ColorTooltip background color.
Headers / Values tabsSeparate styling for the dimension label row (Headers) and the measure value row (Values). The Values tab includes Number Type, Display Unit, and Decimal Places.

Keep animation on when the chart is first presented - the left-to-right draw reveals the trend progressively and draws attention to turning points. Turn it off on dashboards that auto-refresh.

ControlWhat it does
Enable AnimationTurns the draw animation on or off.
DurationHow long the animation runs, 0 to 3000ms. Default is 1000ms.
DelayTime before the animation starts after the chart loads, 0 to 2000ms.
Easing FunctionThe motion curve. Cubic Out (the default) gives a natural deceleration at the end of the draw.

Enable Data Zoom for time series with more than around 60 data points, or any chart where viewers need to focus on a specific date range without changing the underlying query.

ControlWhat it does
Show Data ZoomShows or hides the zoom control.
Zoom TypeSlider: a draggable range bar below the chart. Inside: scroll-to-zoom directly on the plot area. Use Slider for dashboards. Inside is useful on dedicated analysis views where the chart takes up most of the screen.
Slider Size (px)Height of the slider bar, 10 to 100.
PositionPosition of the slider relative to the chart.
AlignmentAlignment of the slider control.
OrientationHorizontal for a line chart - scrolls through the time axis.
Show Detail LabelShows the date or category values at the slider handles so viewers know what range they are viewing.
Background ColorSlider background.
Filler ColorColor of the selected range inside the slider.
Border ColorSlider border.
Handle ColorColor of the drag handles.
Brush SelectionEnables click-and-drag to zoom into a range directly on the slider.

Avoid Zoom Type "Inside" on dashboards that viewers scroll with a trackpad. Scroll events captured by the chart zoom the chart instead of scrolling the page, which is disorienting and hard to exit without knowing to click outside the chart first.

On a single-series line chart, Emphasis highlights the hovered data point. It is less critical than on multi-series charts but useful when the line is dense and viewers need to identify a specific point.

ControlWhat it does
Show EmphasisEnables or disables the hover effect.
Focus TypeItem: highlights the hovered data point and dims others. Series: highlights all points in the series - equivalent to Item on a single-series chart. None: no visual change on hover.
Enable ScaleScales the hovered marker slightly larger. Useful when markers are small and hard to hover precisely.
Scale SizeHow much the marker scales. Keep at 1.2 or below.

Enable the Toolbox when viewers need to export the chart or inspect the underlying data - any context where a viewer will question what a point on the line represents.

ControlWhat it does
Show ToolboxShows or hides the toolbox icon bar.
Save as ImageAdds a download icon that saves the chart as a PNG.
Data ViewAdds an icon that opens the underlying data table in the chart area.

Best Practices

Use a date dimension, not a text dimension. A line chart only makes sense when the X-axis has a natural order. Dates and ordered periods (Week 1, Week 2, Q1, Q2) are correct. Unordered text categories (product names, regions) produce a line that implies relationships between adjacent points that do not exist. Use a bar chart for unordered categories.

Set Tooltip Trigger to Axis. Hovering precisely on a thin line to get a tooltip is frustrating. Axis trigger snaps to the nearest date across the full chart height - no precision aiming required.

Turn off symbols for dense time series. More than around 50 data points with symbols on creates a line of overlapping dots. Set Symbol Type to None in Symbol Styles or toggle Show Symbols off. The line itself is the signal; markers are for sparse data where each individual point matters.

Use Smooth Line only when the trend shape is what matters. Smooth Line interpolates a curve through data points. On revenue trends and user growth curves it reads naturally. On data with genuine volatility - daily stock prices, support ticket counts - smoothing hides the peaks and troughs that are the actual story.

Null values break the line - handle them before publishing. A missing value produces a gap in the line. In the chart builder, a null detection prompt appears automatically when nulls are present - choose "Filter Data" to exclude those points entirely, or "Show data at default position" to treat nulls as zero. For more control (forward-fill, custom replacement), handle nulls in Transform before building the chart. If the gap is intentional (no data for that period), dismiss the prompt and leave the line broken.

FAQs

Need help? Email support@edilitics.com with your workspace, job ID, and context. We reply within one business day.

Last updated on

On this page