---
title: "Excel Templates Knowledge Base"
canonical: "https://docs.getxray.app/space/XRAYCLOUD/44570608/Excel%20Templates%20Knowledge%20Base"
format: markdown
---
# <span style="color: #ff0000">(delete this page as soon as this one </span>[<span style="color: #ff0000">Excel Templates</span>](https://getxraydocs.atlassian.net/wiki/spaces/XRAYCLOUD/pages/44570603)<span style="color: #ff0000"> goes live since the content here was moved to the other page)</span>


# Problem

Cannot create a chart in a sheet populated by exported data from a different sheet.

# Solution

## 1. Create a simple table with column titles to export your data

![image](media://2bf20bb0-4021-4254-84a9-4dd7d8c13fbf)

## 2. Create a named formula for each column in your table. This formula will have the following syntax:

| `=OFFSET(DATA!$A$1,1,0,COUNTA(DATA!$A:$A)-1,1)` |
| --- |

This formula will create a zone/range that will represent the column with all the exported data.

    * DATA!$A$1 -> This represents the starting cell: we'll start on the column title (Sheet 'DATA', Cell A1: 'Key', in this example)

    * 1 -> The vertical offset of the zone/range based on the sarting cell (start one cell below that one)

    * 0 -> The horizontal offset of the zone/range based on starting cell (we want to stay in the same column)

    * COUNTA(DATA!$A:$A)-1 -> This will count all cells with values on sheet 'DATA' and Column A (subtract one to remove the 'Key' title), defining the zone/range with all the rows exported

    * 1 -> Number of columns to define the zone/range (we only want the column we're on)

![image](media://a918cb25-23a3-4bfc-9d2a-183a612a640b)

## 3. Create a chart on a different sheet and "Select Data"

    * Add a new Series for each column you want to visualize in your chart:

        ** Series name: ="Estimated"

        ** Series values: =DATA!Estimated (sheet with data exported + name defined of the named formula)

        ** Series name: ="Spent"

        ** Series values: =DATA!Spent

    * Add a Horizontal (Category)

        ** =DATA!Keys

![image](media://73f0e808-8925-485a-a15f-be24d6b14464)

![image](media://057a6be5-e154-4a7f-91b6-689fb1886e23)

## 4. Save, upload to Document Generator, and then export issues with data.

![image](media://30162a2b-fb22-4971-8b89-842df58b07aa)

![image](media://5dc82c65-0f07-412e-84f0-a97e40fd4ee6)

| ### **Jira Reference:** | [**XPORTER-813**](http://jira.xpand-addons.com/browse/XPORTER-813) |
| --- | --- |