Bookmark and Share Share   

Column Chart

Column charts display numeric data points as vertical bars for a set of records. Columns can be rendered in two dimensions or three. Columns can also be stacked. For horizontal "bars", use the Bar 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.



Characteristics

Requirements

A set of repeating items with:

  • One field with a label that identifies what is on each tick of the X 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 columns that are graphed with one color. In the example shown above, there are three series for Division_a, Division_b and Division_c.

Published Events

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

Mobile Views

Yes

Configure This View

Choose the Column 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 X axis and drop this in the Category field.

    With large numbers of categories (greater than 10-12), use the Chart Scroll property for better visual results.

    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 columns in a different color to the chart.

    For best results, limit the number of series (the number of bars or columns per category) to 12 or less. With stacked columns, 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).

    • Chart Scroll set this to yes to allow the categories to spill over to additional pages when you have larger numbers of categories.

  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.