Skip to main content Skip to complementary content

Creating bar charts

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.

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

  1. In a sheet, click to add a new visualization.
  2. Under Visualization, select one of the following kinds of bar charts:
    • Vertical grouped bar chart
    • Horizontal grouped bar chart
    • Vertical stacked bar chart
    • Horizontal stacked bar chart
  3. Click and drag a field or master item under data as a dimension.
  4. Click and drag a field or master item under data as a measure.

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 presentation.

Presentation properties

You can also change the styling in the advanced edit mode.

Changing the appearance of a visualization.

Related learning:

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!