Widget items: bar and column charts

The Dashboard Builder has more than 50 built in charts and widget items for you to use. You can easily pick the items and insert them into your dashboards.


    Professional         
   Enterprise         
   ReportR         
   DistributR     

warning
WARNING


Dashboard Builder is an extra feature with an additional fee. 

Please contact sales@pointerpro.com. 





In this article, we will focus on the following bart and column chart widgets:

  1. Bar chart
  2. Grouped bar chart
  3. Stacked bar chart
  4. Column chart
  5. Grouped column chart
  6. Stacked column chart


1. Bar chart

One of the most commonly used chart widgets is the bar chart. It can provide you an answer on the question ‘how many’ for a specific time and for different categories at once. 


The classic bar chart uses horizontal bars to compare numeric values across different categories. The longer the bar, the higher the value, which is displayed on the horizontal axis. It is also possible to group data from one bar into subdivisions to give even more insights inside a category itself, which goes by the name stacked bar chart.


Use Cases:

  • Best for comparing categories with long category names, as the horizontal format provides more space for text.
  • Ideal for visualizing data where category labels need to be easily read.
  • Useful for comparing data across categories where the number of categories is large, avoiding clutter.


Example: Number of responses that select the answers from question 1.


Reminder: When you drag the answers data from the Responses dataset and drop it on the Category label on the bar chart, it automatically shows all the answers from all the questions. Therefore, you need to set a filter within this chart widget by clicking the table icon (for data) next to the widget and click Add filter (which shows 1 filter in the following screenshot). 



In the Manage filters pop-up, select question order and set it as equals to 1 (or the question number you want to display). And then click Apply filters.



Example: Number of responses per region


2. Grouped bar chart

A grouped bar chart, also known as a clustered bar chart, is a type of chart that displays multiple bars grouped together in clusters for each category. Each group represents a different subcategory, allowing for direct comparison within the same category. For example, in a grouped bar chart showing sales data, each group could represent different products (e.g., Product A, Product B) with subcategories for sales in different regions (e.g., North, South). This helps in comparing multiple datasets across various categories and subcategories at a glance.


Let's continue with our examples from the previous bar chart. Now I want to see a breakdown of responses from different regions that select the answers question one. Simply drag and drop the data from the regions to the "Group by" label.



In order to distinguish the regions better, you can change the colors in widget settings -> Theme.


3. Stacked bar chart

A stacked bar chart is a type of bar chart where different data series are stacked on top of one another in vertical or horizontal bars. Each segment of the bar represents a subcategory, and the entire bar shows the total value for that category. 


This format allows for easy comparison of total values across categories as well as the contribution of each subcategory to the total. It is particularly useful for showing the composition of a whole and comparing the part-to-whole relationships across different categories.


In the settings of the grouped bar chart, you can change it to 100% stacked or stacked.


Example: 100% stacked bar chart


Example: stacked bar chart

As mentioned earlier, this visualization shows the contribution of each sub category to the main categories. In the case of a risk assessment, I can have a good overview of their responses.



4. Column chart

One of the most commonly used charts is the column chart. It helps answer the question ‘how many’ for specific times and different categories simultaneously. You can also use time as a category, allowing you to track a metric over periods.


Use Cases:

  1. Suitable for time series data or sequential data where time or order is significant.
  2. Good for showing changes over time, with time periods on the horizontal axis.
  3. Effective for comparing values across a few categories, especially when emphasizing differences in height.


Example: Similar to a bar chart, you can show number of responses per category such as the following:


Example: You can also drop the dates/time data on the X-axis to see the evolution of response over time.



5. Grouped column chart

A grouped column chart, also known as a clustered column chart, is a type of bar chart that displays multiple data series in groups of columns side-by-side for each category. This chart allows for easy comparison of different data series across the same categories. 


Each group of columns represents a different category, and within each group, each column represents a different data series. This is particularly useful for comparing multiple variables across the same categories over a specific period.


In the following example, I want to see number of response per region over the time. To do this, I need to drag and drop the intro field data for regions on the Group by label on this widget.


We can also take it one step further: To show the average risk level per region over the time.


6. Stacked column chart

A stacked column chart is a type of bar chart where columns representing different data series are stacked on top of each other within the same category. Each segment of a stacked column represents a different data series, making it easy to visualize the total value for each category as well as the contribution of each data series to the total. 


This chart type is useful for comparing the cumulative value across categories while also showing the breakdown of each individual component.


Example: Distribution of responses per region over the time.




What's next?


Don't want to build it yourself? Contact our professional services team


S
Support is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.