기본 콘텐츠로 건너뛰기

Line chart

이 페이지에서

관련 학습 자료

Line chart

The line chart is used to show trends over time. The dimension is always on the x-axis, and the measures are always on the y-axis. The orientation cannot be changed to vertical.

Line chart.

Your data set must consist of at least two data points to draw a line. A data set with a single value is displayed as a point.

If you have a data set where data is missing for a certain month, you have the following options for showing the missing values:

  • As gaps
  • As connections
  • As zeros

When a month is not present at all in the data source, it is also excluded from the presentation.

When to use it

The line chart is primarily suitable when you want to visualize trends and movements over time, where the dimension values are evenly spaced, such as months, quarters, or fiscal years.

Advantages

The line chart is easy to understand and gives an instant perception of trends.

Disadvantages

Using more than a few lines in a line chart makes the line chart cluttered and hard to interpret. For this reason, avoid using more than two or three measures.

Creating a line chart

You can create a line chart on the sheet you are editing.

다음과 같이 하십시오.

  1. From the assets panel, drag an empty line chart to the sheet.
  2. 차원 추가를 클릭하고 차원 또는 필드를 선택합니다.
  3. 측정값 추가를 클릭하고 측정값을 선택하거나 필드에서 측정값을 만듭니다.

When you have created the line chart, you may want to adjust its appearance and other settings in the properties panel.

In a line chart you need at least one dimension and one measure.

You can include up to two dimensions and one measure, or one dimension and up to 15 measures in a line chart.

Creating a line chart
Dimensions Measures Result
1 dimension 1 measure A simple line chart with a single line.
2 dimensions 1 measure A line chart with the first dimension on the X-axis, and a line for each value of the second dimension.
1 dimension up to 15 measures A line chart with one line for each measure.

Display limitations

Displaying large numbers of dimension values

차원 값의 수가 시각화의 폭을 초과하는 경우, 스크롤 막대가 있는 미니 차트가 표시됩니다. 미니 차트의 스크롤 막대를 사용하거나, 장치에 따라서는 스크롤 휠을 사용하거나 두 손가락으로 살짝 밀면 스크롤할 수 있습니다. 굉장히 많은 수의 값이 사용되는 경우는 더 이상 미니 차트에 모든 값이 표시되지 않습니다. 그 대신, 미니 차트의 요약 버전(항목이 회색으로 표시됨)에 값의 개요가 표시되지만 매우 낮은 값과 매우 높은 값은 여전히 표시됩니다. 

Line chart with a mini chart, since the dimension values exceeds the width of the visualization.

Line chart with mini chart.

Displaying out of range values

In the properties panel, under Appearance, you can set a limit for the measure axis range. Without a limit, the range is automatically set to include the highest positive and lowest negative value, but if you set a limit you may have values that exceed that limit. When a data point value cannot be displayed, due to the range limits, an arrow indicates the direction of the value.

When a reference line is out of range, an arrow is displayed together with the number of reference lines that are out of range.

Displaying large amounts of data in a line chart

When displaying large amounts of data in a line chart, the message "Currently showing a limited data set." is shown to indicate that not all data is displayed.

  • If the chart uses a continuous scale, 2000 data points are displayed.
  • If the chart uses a non-continuous scale, the number of data points displayed is in the range of 2500 to 5000. The limit depends on if the chart has one or two dimensions, and if coloring is used.

Above that number, data points are neither displayed, nor included in selections made in the line chart.

Additionally, only twelve dimension values are displayed for the second dimension in a chart with two dimensions and continuous scale.

To avoid displaying limited data sets, you can either make a selection or use dimension limits in the properties panel.