Bookmark and Share Share   

Bar Chart

Bar charts display numeric statistics as horizontal bars for a set of records. Bar chart views support desktop and mobile devices.

Bars can be rendered in two dimensions or three. Bars can also be stacked. For vertical "bars", use the Column Chart instead. For a reverse relationship between records and data points, see Sparkline Column.

There are two common patterns for data in bar and column charts:

  • Numerical data distributed by a frequency, such as time intervals.

    This is some times called a histogram. Although time is a common distribution, it isn't required. Any numeric distribution works.

  • Numeric data sorted into categories, such as expense categories.

    With categories, the order in which categories are presented is defined by the order it appears within results.



A set of repeating items with:

  • One field with a label that identifies what is on each tick of the Y axis. This is the category field. In the example shown above, the Month field is the category.

  • At least one field with numeric data. Each field with numeric data that you add as a series defines the bars that are graphed with one color. In the example shown above, there is one series for Division_a.

Published Events

element-click = user clicks on any of the graphic objects or areas that represent data in this chart

Mobile Views


Configure This View

Choose the Bar Chart view and:

  1. If needed, change the Select Repeating Element field to find the repeating items that contain the fields you want to chart. This must be the parent node to the fields you want to use and it must be a repeating node.

  2. Drag the column that contains the labels for the Y axis and drop this in the Category field.

    For best results, limit the number of categories to 15 or less.

    You can click Show Data to see the actual data and simply drag the appropriate column title. Hide Data closes this and shows just the column names.

  3. Drag at least one column that contains numeric data into the Series field. Each column you add to Series adds a set of bars in a different color to the chart.

    For best results, limit the number of series (the number of bars or columns per interval/category) to 12 or less. With stacked bars, limit the number of series to eight or less for best results.

    It is also best if the numeric data are distinctly different but within a similar range of values. One very large or very small value can skew the chart scale, making it difficult to see or understand other data.

  4. Optionally, change any of these properties:

    • Stack Series? to stack the series in one column for each category.

    • Chart Visualization to set this as two dimensional (2D) or three dimensional (3D).

  5. Click Next and set basic options for the chart in the Customize Appearance step:

    • Set a Caption or Subcaption for the chart.

    • Set captions, if needed, for the X and Y axes.

    • If needed, add a prefix or suffix for all numeric labels for this chart.

      Common examples might be $ as the prefix or % as the suffix.

  6. If needed, click Switch to advanced mode to set other visual properties for the chart. See Advanced Configuration Properties for details.

  7. Preview the chart at any time.

  8. Once you are satisfied, save the view:

    1. Click Finish.

    2. Give the view a name, and optional description.

    3. Click Save.