How to add a Jira bar chart to a Confluence page
By Jake Marsh · Updated
Confluence Cloud's built-in Jira chart macro offers pie, created vs resolved and two-dimensional charts, but no bar chart. To add one, install Chartmere, edit the page, type /Jira chart (Chartmere), enter your JQL, choose Bar (vertical or horizontal) or Stacked bar, pick the field to group by, and press Save. The chart is counted for each reader from the work items they can browse, with the numbers in a table underneath.
Steps
- Edit the Confluence page and type
/Jira chart (Chartmere). - Enter the JQL for the work items, such as
project = WEB AND sprint in openSprints(), or a saved filter withfilter = 12345. - Choose the chart type: Bar, vertical or horizontal, or Stacked bar.
- Pick the field for the bars. Any field with values works: status, priority, work type, assignee, components, labels, sprints, teams, select lists and more.
- For a stacked bar, pick the field to stack by, for example bars by component, stacked by status.
- Pick the measure: count work items, or sum or average a number field such as Story point estimate.
- Press Save, then publish the page.
If you're not sure of the JQL, our free JQL builder helps write the query.
Bar charts worth having on a page
| Question | Bars by | Stacked by | Measure |
|---|---|---|---|
| Where is the sprint's work? | Assignee | Status | Sum of Story point estimate |
| Which components have open bugs? | Component | Priority | Count |
| How is each team's backlog split? | Team | Work type | Count |
| Who has the most unfinished work? | Assignee | none | Count, with statusCategory != Done in the JQL |
| How big are the epics? | Parent | Status category | Sum of Story point estimate |
Horizontal bars suit long names, such as components or epic titles. Vertical bars suit short ones, such as priorities or months.
Reading the chart
- Under the chart, a table holds the numbers. Each number (except "Other") links to exactly those work items in Jira, so a reader can go from "Unassigned: 14" to the 14 work items.
- Work items with no value show as "No value" or "Unassigned". Turn that off in the settings to leave them out.
- Charts show the top 5 to 50 values, your choice, and fold the rest into "Other".
- A work item with two labels or two components counts under both, so the bars can add up to more than the total. The chart notes this under the numbers.
Letting readers narrow it
Add up to three reader filters in the settings, such as Component, Assignee or Team. On the published page, readers pick values to narrow the chart for themselves, and nothing they pick is saved.
Keeping the numbers for later
A live chart changes whenever Jira does. To keep the numbers as they were at a review, press Take snapshot on the published page. The snapshot shows the values, the date and who took it to everyone who can view the page.
Chartmere starts with Atlassian's 30-day free trial; prices are on the Chartmere page.
What it costs
Chartmere is From $11 a month for up to 10 users. Every plan and the install link are on the Chartmere page.
Chartmere: Work Item Charts and Reports for Confluence
Jira charts on Confluence pages: pie, bar, stacked, line, created vs resolved and 2D tables from any JQL, counted for each reader From $11 a month for up to 10 users.
Questions
Can I sum story points in a Jira bar chart in Confluence?
Yes. Set the measure to sum and pick the Story point estimate field, or any other number field. Time tracking fields are shown in hours.
Can the bars be sorted?
Yes. Pick Biggest first, Smallest first, A to Z, or Jira's order (for status and priority). Choose how many bars to show, from the top 5 to the top 50, and the rest are folded into Other.
Will the bar chart show in a PDF export?
Yes. PDF and Word exports carry the chart as a picture and the numbers as a table.
Does a reader see work items they can't open?
No. A live chart counts only what each reader can browse in Jira, issue security levels included.