Put Sample Data into the Excel Template for Charts
When the data is prepared, you can start defining the charts. Before, defining the chart, there must already be some sample data available in the Excel sheet. Such sample data contains a subset of the real export data, and is required because Excel does not allow defining a chart without adding data to it.
The best practice is to export now with the scripts you defined in the previous step. Then, pick a part of the export data and copy it into the Excel template.
The sample data is not needed in the final Excel export and should be removed from the final result. To remove that, you should wrap the sample data in a <jt:if test='false'> condition, like this:
|<jt:if test="false">|...sameple data|</jt:if>
A screenshot as illustration:
 |