How to Create Jira Reports and Charts in Confluence

Popular Macros for Reporting on Jira in Confluence:

  1. Add a Jira Issue or Filter Macro to Confluence Pages
  2. Use the Jira report blueprint to create a change log or status report
  3. Use the Jira chart macro to display data as a chart, including pie charts, created vs resolved, and two-dimensional charts
  4. Use Jira gadgets to display detailed Jira reports and charts on pages
  5. Use Jira Charts for Confluence add-ons to customize and add features to your charts


Whether you’re sharing the progress of a sprint with the marketing department, senior management, or the whole company, you’ll probably want to share it in Confluence. If Jira is the collaboration tool for software teams, Confluence is the best place to share updates with everyone not using Jira day-to-day.

The following is a handy guide to the different options, tools, tricks, and best practice for Atlassian’s Jira and Confluence reporting integrations. We’ll start with the simplest of integrations and reports, and gradually get more complex. There are some significant differences between Confluence Data Center (DC) and Cloud functionality. In this blog we’ll be using Confluence Cloud for the screenshots, and adding notes to any differences found on Confluence Server/ DC.

Out of the Box Jira and Confluence Integrations

! Server and Data Center: Before you can use any of these macros, your Jira and Confluence applications must be connected via Application Links.

☁️ Cloud: Application links are automatically configured between Jira and Confluence, so you shouldn’t need to do anything.

Adding a Jira Issue/ Filter Macro to Confluence Pages

Adding a Jira Issue/ Filter Macro to Confluence Pages

You can display a list of issues or a single issue, based on whatever Jira Query Language (JQL) search, filter, or URL you put into the macro. You can also create a new Jira Issue from within the macro, without leaving the Confluence page. Here you’ll also have the option to select and display a recently viewed issue. Finally, there’s even the option to display a count of issues.

Display a count of Jira issues. Insert A Jira Issue/ Filter

To insert this macro, or any other macros onto a Confluence, you have a few options:

Select a macro from the quick links section

Insert a Jira macro into Confluence Pages

View all macros from the full menu

Insert Macros into Confluence Pages ⌘+⇧+A on Mac or Alt+⇧+A on PC

Top Tip: You can access the macros page directly with the keyboard shortcut ⌘+⇧+A on Mac or Alt+⇧+A on PC

If you already know the name of the macro you want to use, the easiest way to insert it is to type the curly brace { on the page, and start typing the name of the macro.

☁️ Cloud: The new Cloud page editor users forward slash / to open the quick search ?

Insert Macro on Confluence Pages using brackets {}

Create a Jira Report Blueprint from a template

If you want to keep things simple, you can create a change log or a status report, without using Jira Query Language.

To create a Confluence page from a template, click create page, search for Jira, and then select Jira report.

Create a Jira Report Blueprint from a template

Creating a standard static change log couldn’t be easier, just select the Jira project you want, and give it a title.

Create a Jira project static change log in Confluence
Create a Jira Project Change Log in Confluence

As soon as you hit create, you’ll see a static list of Jira Issues displaying in the change log.

Change Log Jira Report View in Confluence

If you want to create a dynamic Jira change log, go back to the change log settings screen and Switch to advanced.

Then enter your JQL query, or paste in the URL of the Jira search (find out more about using JQL in the Jira Documentation). This creates a dynamic report page in Confluence, summarising the Jira Issues as defined by your Jira Query.

Dynamic Jira change log Report in Confluence

This dynamic Confluence macro will update automatically, whenever the relevant issues are updated.

Dynamic Jira Change Log Confluence macro update automatically

For a more detailed summary, check out the Atlassian documentation page for the Jira Issues macro.

Create a Jira Status Report in Confluence

As before, click create page, search for Jira, and select Jira report, but this time select Status report.

Create a Jira Status Report in Confluence

The Jira status report displays the progress of your chosen Jira project and the fix version in pie charts. You can chart by assignee, project, component, reporter, resolution, sprint, priority or issue type. The status report uses the Jira Chart macro, and is based on the information you enter. It’s also a dynamic chart, so your Confluence report will update whenever your Jira Issue tickets are changed.

Create a Dynamic Jira Status Chart in Confluence

To create your own charts, you can just edit a Confluence page and type:

{Jira Charts

Create {Jira Charts} in Confluence

This will give you a selection of charts to choose from:

  • Pie Chart: which we’ve covered.
  • Created vs Resolved: which compares the number of issues created with the number of issues resolved on a line graph.
  • Two Dimensional: which displays a grid of statistics. Choose from: status, fix version, assignee name, priority, component, and issue type and more.
Jira Charts Pie Charts, Jira Created vs Resolved Charts, and Jira Two-Dimensional Charts

Customizing Jira Charts in Confluence Reporting Blueprint Templates

Out of the box, the only customizations you can do to the blueprint templates are:

  • Move them around the page, or delete any chart you don’t want to be included
  • Set the width of each chart
  • Toggle the chart border on or off
  • Choose whether to display chart information
  • Change the name of some headings, and modify the instructional text

If those “customizations” seemed limited, there are a number of Macro Apps that offer many more customization options.

Custom Jira Charts for Confluence

Custom Jira Charts for Confluence offers the following customizations:

  • Choose the colors of Pie, Funnel, or Bar Charts using a color picker or hex code.
  • Rearrange the order of the segments with a click, or drag and drop in any custom order
  • Chart by assignee, project, component, reporter, resolution, sprint, priority or issue type and user-created custom fields
  • Show/hide segments you don’t want to see
  • Chart by count, average, sum, of issues, story points, time spent, or any scripted number field.

Once you’ve installed it, either type {Custom or search for “Charts” in the macro selector

Custom Jira Charts for Confluence

The Custom Jira Charts for Confluence editor

To get started and see it for yourself check out the Custom Jira Charts for Confluence Playground here. Available on Cloud, Server and Data Center.

Visit the Atlassian Marketplace for Custom Jira Charts for Confluence to find out more.

To make a Jira chart in Confluence for tasks resolved within a specific time

For this advanced report, you’ll need an app like Table Filter and Charts by Stiltsoft. First, combine their Chart from Table macro and their Pivot Table Macro.

Now you can visualise the distribution of tasks that were resolved within the dates you defined for the project.

Or you can find out the most active issue reporters for a specific project within some period of time and show their number of issues in the form of the bar chart.

Check out the video below for a demo:

This advanced combo move of macros allows a lot of customised reporting options for power users. If you know what you’re doing, you can quickly and easily apply the right filters, and choose the right data set all from within page view mode, with no need to hit the edit page button.

So as you can see, there is an abundance of options for reporting and charting of Jira Issues in Confluence, depending on your needs.

We haven’t even gotten into many excellent roadmap tools that link Jira with Confluence.

But that’s another story for another blog. For now, check out the Custom Jira Charts for Confluence playground, and see what you could do with some more customizable options in your Jira Charts Reporting.


In summary:

  • To insert a Jira Issue/Filter Macro, select the macro from ‘quick links’ or ‘view all macros’ or type the curly brace { if you know the name of the macro.
  • To create a change log or status report in Confluence, click create page, search for Jira, and select Jira report. Then select change log or status report.
  • There are some limited out-of-the-box customizations such as the ability to move charts around the page and toggling the chart border on and off.
  • If you want to choose colors, rearrange segments, chart by assignee, project, component etc, you’ll need Custom Charts for Confluence.
  • To make a chart for tasks resolved in a specific time, you’ll need Table Filter and Charts by Stiltsoft.

Morgan is a Seattle born and raised lover of rain and software, particularly software that isn’t a pain in the bum (like some Atlassian tools can be). This is why she’s a Custom Charts for Jira superfan and jumped at the chance to contribute to the solution herself. She specializes in Agile, Scaled Agile, and ITIL in the Atlassian app space, loves a cross-country road trip, and is on a mission to find the cutest coffee shop in every town she visits.