---
title: "Exporting Charts on Microsoft Word Templates"
canonical: "https://docs.getxray.app/space/XRAY/301678144/Exporting%20Charts%20on%20Microsoft%20Word%20Templates"
format: markdown
---
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:

![image](media://ec4f8f27-8de4-491f-89db-685d6038ced4)

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.

| **Resources:** |
| --- |
|  |
|  |
|  |



**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.

![image](media://5f8b16e1-d637-42d3-844b-14e7a1138926)

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

![image](media://10352e49-e5ec-4839-88da-c4770ebfae02)

Save and upload the template

. Export it in Bulk.

| **Resources:** |
| --- |
|  |
|  |



**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.

![image](media://0bac384d-b911-436d-b084-3ad06e0a0971)

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

![image](media://e332b67a-a54d-49d5-b4a3-580c8cfc986e)

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

| **Resources:** |
| --- |
|  |
|  |
|  |