Bar Chart Report
A bar chart report is widely used for data visualization. Four types of bar charts can be created using the designer interface - simple bar chart, stacked bar chart, multi-series bar chart and multi-axis bar chart. This article explains how to create the different types of bar chart and provides a few examples.
Steps to Create Bar Charts
Click New report > Custom Report to open the Report Designer interface
Select page Type as Chart. Bar is selected as the default option
Simple Bar Chart - one Dimension field for the X-axis and one Measure field for the Y-axis, optional Dimension fields for filters
Add the Dimension fields from the left panel by clicking the drop-down sign next to the field name and selecting the appropriate destination (X-axis or Optional Filters)
Add the Measure field from the left panel by clicking the '+' sign next to the field name. It will get added to Y-axis automatically
Stacked Bar Chart - one dimension field for the X-axis, one Measure field for the Y-axis and one Dimension field for 'Segment By', optional Dimension fields for filters
Add the Dimension fields from the left panel by clicking the drop-down sign next to the field name and selecting the appropriate destination (X-axis, ‘Segment By’ or Optional Filters)
Add the Measure field from the left panel by clicking the '+' sign next to the field name. It will get added to Y-axis automatically
Multi-Series Bar Chart - one Dimension field for the X-axis and more than one Measure fields for the Y-axis, optional Dimension fields for filters
Add the Dimension fields from the left panel by clicking the drop-down sign next to the field name and selecting the appropriate destination (X-axis, ‘Segment By’ or Optional Filters)
Add more than one Measure field from the left panel by clicking the '+' sign next to the field name. It will get added to Y-axis automatically
Multi-Axis Bar Chart - one Dimension field for the X-axis of each added axes, one Measure field for the Y-axis of each added axes, optional Dimension fields for filters of each added axes. Adding multiple axes is most useful if all the X-axis fields are either ‘dates’ or if they represent the same field. Each axis can also have it own filter criteria
Add the Dimension fields from the left panel by clicking the drop-down sign next to the field name and selecting the appropriate destination (X-axis, ‘Segment By’ or Optional Filters)
Add more than one Measure field from the left panel by clicking the '+' sign next to the field name. It will get added to Y-axis automatically
Click “Add another Axis” and repeat the two above steps to get fields for the second axis
Click Run to view the results in the bottom pane (below is a screenshot of the multi-axis bar chart report)
Click Save to save the report for future use. Saved reports can be accessed via My Area → My Reports
Additional Details
Field Settings
Settings on each field can be set by selecting the gear icon on each added field. Listed below are some examples of the options that are available from field settings:
Change the label of the column
Apply filters on the column
Set date format
Set aggregation formula
Page Settings
Each page in a report can have a Page Title that will appear as the title of the page on the report. Page settings are also available for each page and differ based on the type of the report.
Sample Reports
Simple Bar Chart - Count of issues in specified statuses (issue types specified in Optional Filters)
Stacked Bar Chart - Count of Issues created last month, broken down by issue type
Multi-series Bar Chart - Sprint Story Points details for all sprints of a specific project
Multi-axis Bar Chart - Issues Created vs Issues Resolved for specified time interval
Related articles