Line Charts

A line chart is a powerful data visualization tool that displays trends and changes over time, making it ideal for tracking metrics like sales, website traffic, or stock prices.

1. Line chart

Chart setup

1. Axis

- Drag a dimension to plot on the axis (e.g., Month).

Values parameter

- Drag measures to analyze (e.g., 2024 Plan, 2024 Actuals, 2023 Actuals, 2022 Actuals).

Chart type

- Select Line from the Line section of the Chart Type dropdown menu.

Line charts provide a clear and intuitive way to observe patterns and fluctuations in continuous data by connecting data points with straight lines.

Line charts can be converted into Spline and Stepped charts from the chart selection menu, without changing the configuration.

1. Customization & formatting options under Canvas settings

1.1. Category format

Customize the line and marker style, color, and size from the Category format settings.

2. Stacked line chart

Chart setup

1. Axis

- Drag a dimension to plot on the axis (e.g., Month).

Values parameter

- Drag measures to analyze (e.g., 2024 Plan, 2024 Actuals, 2023 Plan, 2023 Actuals, 2022 Plan, 2022 Actuals).

Chart type

- Select Stacked Line from the Line section of the Chart Type dropdown menu.

By stacking data series, these charts highlight the composition and progression of different categories, making them ideal for scenarios like tracking departmental contributions to total revenue or monitoring resource allocation across projects.

The stacked line can be converted into spline and stepped line variants by switching the chart type.

3. 100% Stacked line chart

Chart setup

1. Axis

- Drag a dimension to plot on the axis (e.g., Month).

Values parameter

- Drag measures to analyze (e.g., 2024 Plan, 2024 Actuals, 2023 Plan, 2023 Actuals, 2022 Plan, 2022 Actuals).

Chart type

- Select 100% Stacked Stepped Line from the Line section of the Chart Type dropdown menu.

By representing data in percentages, the 100% stacked line charts allow for easier comparison between categories.

We've used a 100% Stacked Stepped Line chart for demonstration, but it can be converted into spline and line variants by switching the chart type.

4. Clustered/ grouped line

Chart setup

1. Axis

- Drag a dimension to plot on the axis (e.g., Month).

Values parameter

- Drag measures to analyze (e.g., 2024 Plan, 2024 Actuals, 2023 Plan, 2023 Actuals, 2022 Plan, 2022 Actuals).

Chart type

- Select Grouped/clustered Line from the Line section of the Chart Type dropdown menu.

Grouped line charts display several series side-by-side on the same axis. They highlight similarities, differences, and trend patterns across categories.

1. Baseline

Chart setup

1. Axis

- Drag a dimension to plot on the axis (e.g., Month).

Values parameter

- Drag measures to analyze (e.g., 2024 Actuals).

Chart type

- Select Baseline from the Line section of the Chart Type dropdown menu.

A baseline chart incorporates a reference line - known as the baseline. This baseline can be a fixed value, such as zero, a target threshold, or a dynamically calculated value based on historical data. Baseline charts are particularly useful in highlighting deviations, trends, and anomalies relative to this reference point.

2. Variance line

Chart setup

1. Axis

- Drag a dimension to plot on the axis (e.g., Month).

Values parameter

- Drag measures to analyze (e.g., 2024 Actuals, , 2023 Actuals).

Chart type

- Select Variance line from the Line section of the Chart Type dropdown menu.

A variance line chart illustrates the differences between two comparable metrics over time, such as actual versus budgeted figures. By plotting measures as lines on the same graph, the chart highlights deviations, enabling quick identification of periods where performance diverged from expectations.