Setting custom column names for exported chart data

Besides exporting charts to images and PDF, you can use our Export plugin for other things, like exporting it's data to CSV, Excel and other formats.

By default, column names will be exported using their "internal" field names - the same way they appear in data. I.e. "value", "volume", etc.

Using graph names to replace internal column names with user-friendly names

Probably the easiest way is to set export's option exportTitles:

"export": {
  "enabled": true,
  "exportTitles": true
}

Now the export will try to replace column names by using title of the graph that is attached to this specific column in data via valueField. Please note that the graph needs to have its title property set in order for it to work.

Setting completely custom names

If the above approach is not enough, or you have columns in your data that do not have graphs attached to them, but still wanted those to be exported, you can use export's option columnNames.

It's basically an object where it's property key is a field in data and the property value is a text how it should be named in exported data:

"export": {
  "enabled": true,
  "columnNames": {
    "value": "Selling price, $",
    "volume": "Volume of sales, $M"
  }
}

Working with multiple-dataset Stock Chart

Multiple-dataset Stock Chart can be trickier.

When exporting data on such chart, export names the fields for main selected data set just like for any other chart.

For compared data sets it is using the following syntax to construct column names: "[dataset id]_[field name]".

For example, "volume" field for data set with an id "ds2" will become "ds2_volume".

Luckily, you can use those "generated" names in columnNames just as well:

"export": {
  "enabled": true,
  "exportFields": [
    "value",
    "volume",
    "ds2_value",
    "ds2_volume",
    "ds3_value",
    "ds3_volume",
    "ds4_value",
    "ds4_volume",
    "ds5_value",
    "ds5_volume"
  ],
  "columnNames": {
    "value": "Data Set #1 (Price)",
    "volume": "Data Set #1 (Volume)",
    "ds2_value": "Data Set #2 (Price)",
    "ds2_volume": "Data Set #2 (Volume)",
    "ds3_value": "Data Set #3 (Price)",
    "ds3_volume": "Data Set #3 (Volume)",
    "ds4_value": "Data Set #4 (Price)",
    "ds4_volume": "Data Set #4 (Volume)",
    "ds5_value": "Data Set #5 (Price)",
    "ds5_volume": "Data Set #5 (Volume)"
  }
}