Currently, Microsoft Word Charts aren't supported by Document Generator for third-party limitations.
To export charts on a Microsoft Word template, you need to use Object Linking and Embedding (OLE) Microsoft Excel Chart. This chart can be inserted via 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 its data. You can export number fields from Jira to this second sheet to populate the chart.
Example 1
Export 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 shown below:
Note: It's important to go to Hidden and Empty Cells and change the Show empty cells as: option to "Zero". This will safeguard issues with no value defined on the fields.
Save and upload the template. Export it on a single issue or Bulk.
Example 2
Export a number of issues and their information. 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, all desired issue information will be exported and the issue values to the previously defined variables will be added.
At the end of the document, add a chart as in the previous example, but with the newly defined variables.
Save and upload the template
. Export it in Bulk.
Resources: |
---|
Template |
Bulk exportation |
Example 3
Use a Microsoft Excel Chart inside an iteration.
You can use a chart inside an iteration. You can 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 to compare totals of links with totals of subtasks.