メイン コンテンツをスキップする

Bar chart

The bar chart is suitable for comparing multiple values. The dimension axis shows the category items that are compared, and the measure axis shows the value for each category item.

In the image, the dimension values are different regions: Nordic, USA, Japan, UK, Spain, and Germany. Each region represents a dimension value, and has a corresponding bar. The bar height corresponds to the measure value (sales) for the different regions.

Bar chart visualization.

You can make more complex comparisons of data by using grouped or stacked bars. This requires using two dimensions and one measure. The two example charts use the same two dimensions and the same measure:

Grouped bars: With grouped bars, you can easily compare two or more items in the same categorical group.

Bar chart with grouped bars.

Stacked bars: With stacked bars it is easier to compare the total quantity between different months. Stacked bars combine bars of different groups on top of each other and the total height of the resulting bar represents the combined result.

Bar chart with stacked bars.

The bar chart can be displayed horizontally or vertically, as in the example below:

Two bar charts, one displayed horizontally and one vertically.

When to use it

Grouping and stacking bars makes it easy to visualize grouped data. The bar chart is also useful when you want to compare values side by side, for example sales compared to forecast for different years, and when the measures (in this case sales and forecast) are calculated using the same unit.

Advantages: The bar chart is easy to read and understand. You get a good overview of values when using bar charts.

Disadvantages: The bar chart does not work so well with many dimension values due to the limitation of the axis length. If the dimensions do not fit, you can scroll using the scroll bar, but then you might not get the full picture.

Creating a bar chart

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

次の手順を実行します。

  1. From the assets panel, drag an empty bar chart to the sheet.
  2. [軸を追加] をクリックして、軸または項目を選択します。
  3. [メジャーを追加] をクリックし、メジャーを選択するか、項目からメジャーを作成します。

In a bar chart you need at least one measure.

You can include up to two dimensions and one measure, or one dimension and up to 15 measures in a bar chart. Each bar corresponds to a dimension, and the values of the measures determine the height or length of the bars.

You can also create a bar chart with no dimension and up to 15 measures. In this case, one bar is displayed for every measure. The value of the measure determines the height or length of a bar.

Creating a bar chart
Dimensions Measures Result
1 dimension 1 measure A simple bar chart with one bar for each dimension value.
2 dimensions 1 measure A grouped or a stacked bar chart with one bar for each value of the two dimensions.
No dimension up to 15 measures A simple bar chart with one bar for each measure.
1 dimension up to 15 measures A grouped or a stacked bar chart with one bar for each value of each measure..

When you have created the bar chart, you may want to adjust its appearance.

For more information, see ビジュアライゼーションの外観の変更.

Adding custom tooltips

You can add measures as custom tooltips that appear as additional tooltips over the bars. You can add a measure from a field, or you can add a measure using an expression.

Styling the custom tooltip

You can change the way the tooltip is displayed.

  • You can change the label of the tooltip with Label.
  • You can set the formatting with Number formatting.

Limitations

Custom tooltips cannot be used with set expressions, expressions using total, or charts with calculated dimensions. In snapshots, basic tooltips will be shown instead of customs tooltips.

Display limitations

Displaying large numbers of dimension values

軸の値の数がビジュアライゼーションの幅を超えると、スクロール バーの付いたミニ チャートが表示されます。ミニ チャートのスクロール バーを使ってスクロールするか、デバイスによってはスクロール ホイールを使うか 2 本の指でスワイプします。大量の値が使用されている場合は、ミニ チャートにすべての値が表示されなくなります。その代わり、圧縮されたミニ チャート (アイテムはグレー) に値の概要が表示されますが、非常に低い値と高い値は表示されます。 

Bar chart with mini chart.

ヒント: You can exchange the mini chart with a regular scrollbar, or hide it, with the Scrollbar property.

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. A bar that exceeds the limit will be cut diagonally to show that it is out of range.

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 stacked bar chart

When displaying large amounts of data in a stacked bar chart, there may be cases when not each dimension value within a bar is displayed with correct color and size. These remaining values will instead be displayed as a gray, striped area. The size and total value of the bar will still be correct, but not all dimension values in the bar will be explicit.

A stacked bar chart with the remaining values displayed as a gray, striped area.

To remove the gray areas, you can either make a selection or use dimension limits in the properties panel.

The approximate limit for how many stacked bars that can be displayed without gray areas is 5000 bars, assuming that each bar consists of 10 inner dimension values and one dimension value and one measure value for the whole bar.

初期データ ロードは、500 個の軸の値、または軸の積み上げです(500 という値は、積み上げ内の各軸の値ではなく、外側の軸の値を指します)。それら過去 500 個の値をスクロールすると、増分ロードが実行され、現在のビューまたはスクロール位置に基づいて値が代わりにロードされます。