First, you should prepare the data that needs to be visualized in the chart. To do so, refer to the properties of items, using tags, or any similar method.

However, there is one requirement for the data export: in our example we are defining a pivot chart using named ranges to feed the charts with data. This means that the export data must have a header line, too, as highlighted in the following screenshots.