A column chart plots numeric values for levels of a categorical feature as bars. Levels are plotted on one chart axis, and values are plotted on the other axis. Each categorical value claims one bar, and the length of each bar corresponds to the bar’s value. Bars are plotted on a common baseline to allow for easy comparison of values.
The column chart and the stacked column chart both display data using rectangular bars. The length of these bars is proportional to the data value. However, in the column chart, data values are displayed side-by-side whereas in the stacked chart, they are stacked one over the other.
1. How to add and configure a column chart.
The following steps explain the data configuration of the bar chart:
- Drag and drop the column chart icon from the toolbox into the design panel.
- Resize the widget as required.
- Select your chart and in the properties section, you can name the chart and change any settings you wish.
- You can then select assign data and select your data source.
Please note that before adding a Grid component you will need to define a data source.
- Drag and drop the relevant columns into the value, column and row section.
2. Properties menu options
It is recommended that you check out the properties menu options to format your column chart in the way that best suits the data you are depicting.
The following screenshots show the various properties menu options based on the column chart section.
Naming the Component
Title – This allows you to set a name for the component
Subtitle – This allows you to set a subtitle for the component.
Description – This allows you to show additional information in the form of a tooltip. It’s beneficial as it gives the user additional information without affecting the visualization.
Icon – Sintel Forms and Sintel BI both have Font Awesome embedded. This enables you to add an icon to your component.
Title alignment – This determines the appearance and orientation of the component’s title. You can choose to align your text left, centre or right.
Look & Feel
Elevated Border – You can switch the elevated border on and off of your component depending on what you like best.
Background Colour – You can change the background colour of the component to any colour you like. If you have specific brand guidelines you are adhering to you can paste in the HEX code directly.
Show legend – A legend is an area of a chart describing each of the parts of the chart. You can switch on and off the visibility of the legend.
Legend position – You can choose the position in which the legend appears in relation to the chart. The options are Auto, Top, Left, Bottom and Right.
Legend shape – You can choose the shape of the bullet points of the legend. Your options are SeriesType (Which mimics the kind of chart you have added), Circle, Pentagon, Triangle and Rectangle,
Show value labels – You can switch on and off the visibility of the value labels for each individual column.
If you choose for the labels to become visible you can also choose the colour of those labels.
You can also decide the rotation of these labels: -90, -45, 0, 45, 90
Show empty values – You can choose whether or not to show empty values.
Show zero values – You can choose whether or not to show 0 values on your table.
Invert axes – Inverting the axis will change your columns from vertical to horizontal.
Show value axis – You can choose to show or hide the value axis on your chart
Value axis title – You can add a title to the value axis for example: ‘Number of Sales’.
Value axis min set to 10Value axis min – You can set a minimum value at which you would like to start displaying data on a chart. For example, you might want to display the weeks in which you had over 12 sales.
Value Axis min set to 12Value axis max – Similarly you can set a maximum value at which you would like to display data on a chart.
Axis type – You can set your axis to be: double, logarithmic or category.
If you set it to double you also have the option to enable Smart labels which when enabled abbreviate the numeric axis labels.
You can also choose to show or hide the category axis.
If you set your axis type to be logarithmic or category you have the option to show or hide the category axis.
Show tooltip – The tooltip will appear when you hover over one of the columns and it will show you the value for that column. You can choose to show or hide this column.
Within the series section, you can change the title that appears at the bottom of your chart, you can change the colour of your chart and you can also change the chart type.
Once you have added your Column Chart component and assigned data to it, make sure you save your work.
If you liked this article and would like to learn more about other components, click here.
If you would like to learn more about Sintel Forms or Sintel BI book a no-obligation demo.