Skip to main content
Series configuration lets you override chart settings on a per-series basis. Each measure on a bar, line, area or scatter chart is one series:
  • On the Fields tab, set its mark type, its Y axis and its breakdown.
  • On the Style tab, under its Y axis, set its color, line style, point shape, interpolation and trend line.

Mark type override

Each series can use a different mark type, independent of the global chart mark. This enables composite charts — for example, plotting one measure as a bar and another as a line on the same chart. Available mark types per series:
  • Bar
  • Line
  • Area
  • Scatter (point)
To create a bar + line chart:
  1. Add two measures to the Y axis.
  2. Find the second measure on the Fields tab.
  3. Set its mark type to Line.
  4. Optionally set its Y axis to Right axis in the same place on the Fields tab (see Axes).

Series color

When no Color channel is assigned (single-color charts with no color-by dimension), each series has an individual color picker. On the Style tab, click the color swatch to open the picker and set a custom color for that series. This setting has no effect when a Color channel is active — in that case, colors are managed by the palette in Color & stacking.

Trend line

A trend line summarizes the series with a dashed line. To add one, go to the Style tab and turn on the Trend line toggle below the series’ style controls. The toggle is available when the X axis shows a time or numeric dimension. When the trend line is on, select its model: Logarithmic and Power need a numeric X axis. On a time X axis, they are not available, and a saved Logarithmic or Power trend line shows as Linear. Exponential and Power need values above zero. A series with a zero or a negative value shows no trend line. Logarithmic and Power also need X values above zero. Click the Confidence band (95%) toggle to show the 95% confidence interval of the fitted curve as a shaded band. The band is not available for Moving average. When a series has a breakdown, each value of the breakdown gets its own trend line and band, in its own color. When the chart has small multiples, each panel gets its own trend line and band.

Y axis assignment

For charts with a dual Y axis, assign each series to either the Left axis or the Right axis on the Fields tab. This controls which axis scale the series uses. See Axes for configuring the right axis title, labels, and scale.

Data labels per series

Enable data labels for an individual series without enabling them globally. Configure label position, font, and format independently for each series. See Data labels for the full configuration reference.

Stacking override

On charts with multiple Y-axis series, you can set stacking behavior per series rather than globally. This lets you create grouped clusters where each cluster is internally stacked. On the Fields tab, set the series’ Break down by field, then pick a placement with the icons next to it: Stacked, Side by side (bars only), Overlaid (areas only) or Stacked to 100%. The placement is available for bar and area series, and only when the series has a breakdown.