Page History

Currently, Microsoft Word Charts aren't supported by Xporter for JIRA for third party limitations.

To export charts on a Microsoft Word template, it's needed to used OLE (Object Linking and Embedding) Microsoft Excel Chart. This charts can be inserted by following the next steps:

...

This will insert an embedded excel book in your document, where the first sheet is a chart and the second sheet contains it's its data. It's possible to export number fields from JIRA Jira to this second sheet to populate the chart.

Example 1

Exporting three number custom fields (NumberA, NumberB, NumberC) from a single issue and compare them in a chart.

After inserting the Microsoft Excel Chart, change the chart data as show on shown in the next example image:

Note: it's important to go to "Hidden and Empty Cells" and change the option "Show empty cells as:" to "Zero". This will safeguard issue with no value defined on the fields.

Save and upload the template to Xporter for JIRA. Export it on a single issue or Bulk.

Example 2

Export a number of issues and their information, and at the end of the report present a chart with the sum of the number custom fields.

...

At the end of the document, add a chart as in the previous example, but with the new newly defined variables.

Save and upload the template to Xporter for JIRAJira. Export it on in Bulk.

Example 3

Use a Microsoft Excel Chart inside an iteration.

You cand can use a chart inside and an iteration. It's possible to export information about an issue, iterate all its linked issues or subtasks and present a chart for each iteration.

...

Using a set function as in the previous example, we can use a final chart comparing totals of links with totals of subtasks.

...

Example 4

It's possible to pass all issues context to a Microsoft Excel Chart using a for issues inside its data sheet.

...

In order to construct this type of chart (with for issues). its needed to set its series and categories values manually. Guide.