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.
Resources: |
---|
Template |
Bulk exportation |
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.
Resources: |
---|
Template |
Bulk exportation |