Line Chart

Learn about Astrato line charts

Piers Batchelor avatar
Written by Piers Batchelor
Updated over a week ago

Introduction

This article looks at the line chart data objects available in Astrato. Line charts are best used with continuous axes like time dimensions, numeric dimensions, etc.

Line charts are best used to look at trends and compare trends between different periods or different entities.

A Line Chart data object displays chart data in a line or lines. Figure 1 shows an example of a line chart being added to a sheet in a workbook.

Figure 1: Line Chart

Line Chart Types

Astrato already supports multiple line chart types, with plans to add more in the future (these are greyed-out icons in the toolbar). You can display the data in a line or a line area, where the space between the line and the axis or the next value displayed is shaded. Line charts in Astrato can be created using one (or more) measures and one (or two) dimensions, depending on the chart type (Table 1). Adding a measure converts a line (or line area) chart to a multi-line (or stacked area) chart.

Table 1: Line Chart Types

Chart Icon / Type / Data

Description

Line / Line Area

1 Dimension, 1 Measure

Line and line area charts show how values change over time, or through a sequence.

Multi-Line

1 Dimension, 2 (or more) Measures

Show and compare how multiple values change over time, or through a sequence.

Stacked Area

2 Dimensions, 1 Measure

Compare the totals of values across categories over time, or through a sequence.

Line Chart Settings

  • Building a Line Chart

    In the data tab, you define the data to use in the chart and define all the settings for the measures.
    A line chart data can include:

    • Two dimensions and one measure

    • One dimension and up to 10 measures.

    • Measure Settings

      • Color- set the color and opacity of the line.

      • Format- set the number format for the measure

      • Line style- set the line style: solid or dashed

      • Line size- set the line width.

      • Shape- set the shape for the data points to display labels on the points a shape must be set.

      • Advanced calculation- apply advanced calculations in the chart, such as period-over-period, moving average, and more.
        to learn more, check out this article.

      • Axis- set the axis for the measure.
        ​

    • Trendlines

      • Select a measure to calculate the trendline and a type of trendline.

      • Customize the line look and feel.

      • Add multiple trendlines.
        ​

    • Reference Lines

      • Add a reference line on either axes to show goals or important timestamps.

      • Customize the reference line display.

      • A reference line can have a static or dynamic value set by a variable.
        Using a variable allows users to change the display interactively as part of their data exploration.
        To learn more about how to use variables, check out this article.
        ​

    • Forecasting

      • Add a forecast to the line chart using a selected measure.

      • Customize the display of the forecasting line.

      • To learn more about forecasting, check out this article.
        ​

  • Styling a Line Chart

    • Line- set the display as either line or area

    • Line type- select the desired line type.

    • Labels-

      • show- activate labels in the chart.
        Labels will be displayed only for lines with shapes.

      • Label density- select how many labels will appear on each line.

      • Colored label- Customize the label font and backdrop color.

    • Color- customize the coloring of the chart.

    • Legend- set the legend position and title.

    • Data gaps- set the approach to handle gaps in the lines.
      ​
      ​

Did this answer your question?