- 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)
- Add two measures to the Y axis.
- Find the second measure on the Fields tab.
- Set its mark type to Line.
- 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.