Exporting Charts on Microsoft Word Templates

Currently, Microsoft Word Charts aren't supported by Xporter for JIRA for third party limitations (insert link to aspose thread here?)

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:

"Insert" -> "Object" -> "Microsoft Excel Chart"

This will insert an embedded excel book in your document, where the first sheet is a chart and the second sheet contains it's data. It's possible to export number fields from 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 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.

Start by initializing a variable to each series on the chart. In a for issues block it'll be exported all desired issue information and add the issue values to the previously defined variables.

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

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

Example 3

Use a Microsoft Excel Chart inside an iteration.

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

The context passed to the chart is the same logic as in all iterations.

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.