--- title: "Exporting Charts on Word Templates" canonical: "https://docs.getxporter.app/space/XPORTERCLOUD/460426/Exporting%20Charts%20on%20Word%20Templates" format: markdown --- > Macro (rw-ui-expands-macro) > > > Macro (rw-expand) > > > Macro (toc) ## Introduction Currently, Microsoft Word Charts isn't supported by [Xporter](https://marketplace.atlassian.com/apps/891368/xporter-export-issues-from-jira?tab=overview&hosting=cloud) for Jira Cloud due to third-party limitations. To export charts in a Microsoft Word template, you need to use [object linking and embedding](https://support.microsoft.com/en-au/office/linked-objects-and-embedded-objects-0bf81db2-8aa3-4148-be4a-c8b6e55e0d7c) Microsoft Excel Chart. This chart can be inserted using the Excel top menu: **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. Learn how to from the examples below. ## Example 1 > Macro (rw-ui-steps-macro) > > > Macro (rw-step) > > Export three number custom fields (Number A: Figure 1 - 1), (NumberB: Figure 1 - 2), (NumberC: Figure 1 - 3) from a single issue and compare them in a chart. > > > Macro (rw-step) > > After inserting the Microsoft Excel Chart, change the chart data as shown in Figure 1. > > ![Figure 1 - Example 1](media://950204b1-1291-4c46-aea8-f455a9ba2f0e) > > > ℹ️ Go to *Hidden and Empty Cells* (Figure 1 - 4) and change the *Show empty cells as *option to "Zero". This will safeguard issues with no value defined on the fields. > > > Macro (rw-step) > > Save and upload the [template](https://docsxporter.atlassian.net/wiki/download/attachments/460426/Example01.docx?version=1&modificationDate=1694008493076&cacheVersion=1&api=v2) to Xporter for Jira Cloud. > > > Macro (rw-step) > > Export it via [single issue](https://docsxporter.atlassian.net/wiki/download/attachments/460426/EPIC-6.docx?version=1&modificationDate=1694008492883&cacheVersion=1&api=v2) or [bulk exportation](https://docsxporter.atlassian.net/wiki/download/attachments/460426/issues.docx?version=1&modificationDate=1694008492973&cacheVersion=1&api=v2). > > > ℹ️ **Learn More** > > ℹ️ > > ℹ️ [Exporting issues](https://docs.getxporter.app/space/XPORTERCLOUD/558706/Exporting+Issues) ## Example 2 > Macro (rw-ui-steps-macro) > > > Macro (rw-step) > > Export some issues and their information. > > > Macro (rw-step) > >  At the end of the report, present a chart with the sum of the number of custom fields. > > > Macro (rw-step) > > Start by initializing a variable to each series on the chart. Using a `for issues` block (Figure 2 - 1), export all desired issue information and add the issue values to the previously defined variables. > > ![Figure 2 - Example 2](media://18c2be73-12f9-422a-be6b-1a7b181e725b) > > > Macro (rw-step) > > At the end of the document, add a chart as depicted in [Example 1](https://docs.getxporter.app/space/XPORTERCLOUD/460426/Exporting+Charts+on+Microsoft+Word+Templates#Example-1), but with the newly defined variables (Figure 3 - 1). > > ![Figure 3 - Newly defined variables](media://d7ddd742-f008-43d2-b0c2-be59212b73a1) > > > Macro (rw-step) > > Save and upload the [template](https://docsxporter.atlassian.net/wiki/download/attachments/460426/Example02.docx?version=1&modificationDate=1694008492687&cacheVersion=1&api=v2) to Xporter for Jira Cloud. > > > Macro (rw-step) > > Export it in [bulk](https://docsxporter.atlassian.net/wiki/download/attachments/460426/issues%20(1).docx?version=1&modificationDate=1694008492783&cacheVersion=1&api=v2). > > > ℹ️ **Learn More** > > ℹ️ > > ℹ️ [Exporting issues](https://docs.getxporter.app/space/XPORTERCLOUD/558706/Exporting+Issues) ## Example 3 > Macro (rw-ui-steps-macro) > > > Macro (rw-step) > > Use a Microsoft Excel 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 (Figure 4). > > ![Figure 4 - Example 3](media://4c643815-075d-48d6-b023-d625721ce843) > > > Macro (rw-step) > > The context passed to the chart has the same logic as in all iterations (Figure 5). > > ![Figure 5 - Iterations](media://9387ec33-2e59-4532-8350-adac8609ae5a) > > By using a [Set function](https://docs.getxporter.app/space/XPORTERCLOUD/526934/Functions#Set-Function) as depicted in [Example 2](https://docs.getxporter.app/space/XPORTERCLOUD/460426/Exporting+Charts+on+Microsoft+Word+Templates#Example-2), you can use a final chart to compare the totals of links with the totals of subtasks. > > > ℹ️ **Learn More** > > ℹ️ > > ℹ️ - [Template](https://docsxporter.atlassian.net/wiki/download/attachments/460426/Example03.docx?version=1&modificationDate=1694008492200&cacheVersion=1&api=v2) > > ℹ️ - [Single issue exportation](https://docsxporter.atlassian.net/wiki/download/attachments/460426/EPIC-6%20(2).docx?version=1&modificationDate=1694008492098&cacheVersion=1&api=v2) > > ℹ️ - [Bulk exportation](https://docsxporter.atlassian.net/wiki/download/attachments/460426/issues%20(3).docx?version=1&modificationDate=1694008492001&cacheVersion=1&api=v2) > > ℹ️ - [Exporting issues](https://docs.getxporter.app/space/XPORTERCLOUD/558706/Exporting+Issues) ## Example 4 > Macro (rw-ui-steps-macro) > > > Macro (rw-step) > > You can pass all issues' context to a Microsoft Excel Chart using a `for issues` block inside its data sheet (Figure 6 - 1). > > ![Figure 6 - Example 4](media://1a0d590c-9013-48e3-aae7-80c1ae41b59f) > > > Macro (rw-step) > > To construct this type of chart (with the `for issues` block), you need to [set its series and category values manually](https://docs.getxporter.app/space/XPORTERCLOUD/462070). > > > ℹ️ **Learn More** > > ℹ️ > > ℹ️ - [Template](https://docsxporter.atlassian.net/wiki/download/attachments/460426/Example04.docx?version=1&modificationDate=1694008491803&cacheVersion=1&api=v2) > > ℹ️ - [Bulk exportation](https://docsxporter.atlassian.net/wiki/download/attachments/460426/issues%20(3).docx?version=1&modificationDate=1694008492001&cacheVersion=1&api=v2) > > ℹ️ - [Exporting issues](https://docs.getxporter.app/space/XPORTERCLOUD/558706/Exporting+Issues)
Support/Troubleshooting If you have questions or technical issues, please [contact the Support team via the Customer Portal (Jira service management)](https://jira.getxray.app/servicedesk/customer/portal/2/user/login?destination=portal%2F2%2Fcreate%2F28) or [send us a message using the in-app chat](https://docs.getxporter.app/space/XPORTERCLOUD/18251779/In-App+Chat+Support).