Guide to using the column chart visualization

A column chart is similar to a bar chart, but the bars are plotted vertically. Data is represented by vertical rectangular bars with lengths proportional to the values that they represent. The column chart can show up to 3 series at one time.

The column chart's discrete data is categorical data and answers the question of "how many?" in each category.

 

In this article:

 

When to use a column chart

A column chart can be used to facilitate all comparison-based analysis.

Column charts are suitable when the number of categories is higher than 4 and lower than 12.

In a bar chart negative values are displayed as bars on the left. However, we associate negative values more with downward direction (as used by the column chart) than leftward (as used by the bar chart). Therefore, we recommend using the column chart when you have negative values in your data set.

Back to top

 

Example uses

A typical use-case for a column chart is comparing values (i.e. a monetary value) over a period of time.

If you want to keep track of MRR added every month, the column chart could be a great alternative as you can see at a glance if March was a better month than February. Maybe you had a special campaign to drive sales in January and you want to know if it paid off.

The following example shows MRR added on individual months:

If your data labels aren't long, you could use column charts in the exact same cases that you would use a bar chart.

You can also use a column chart to plot up to three series of data and compare them against each other. As an example, you could track the MRR added every month and show multiple years of data.

 

Back to top

Anatomy of the column chart

The column chart is a diagram in which the numerical values of the different variables are represented by the height of bars of equal width. The bars are drawn vertically (along the y-axis) whilst the data labels that describe them are situated on the x-axis.

Back to top

Tips for creating column charts

Decide on a clear title. The title should be a brief description of the data that you want to show.

Use the column chart for a maximum of 10-12 data sets. When the number of data sets is larger than that, using a column chart is probably not the best way forward.

Use the Decimal Places feature to manually set the precision of numbers in your widgets, so that you can show the level of detail appropriate for your dashboard.

If needed, you can also override our automatic settings for what abbreviation and unit to show.

Abbreviation, Decimal Places and Unit are part of the "Fine-tune" settings

Abbreviation: Numbers can be shown in their raw state, or as Thousands (K), Millions (M), or Billions (B).

Unit: Allows you to manually enter any prefix or suffix up to 3 characters long. This means if you’d prefer to display your currency differently to our default option you now can. As examples you might want Swedish Krona to show as 100 Kr instead of SEK 100, or New Zealand Dollars to just have the $.

 

 Back to top

API and integrations

API

You can build column charts using the API (custom widgets).

For detailed information on how to display a column chart using custom widgets, please visit our Developer Documentation.

Integrations

The column chart visualization is available for most pre-built integrations. Notably, for the Spreadsheets and Salesforce ones.

Back to top

 
Was this article helpful?
👍

Thank you for your feedback!