# How to create a chart in Excel when exporting a CSV file **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [August 27, 2024, 4:26am UTC](https://forum.inductiveautomation.com/t/how-to-create-a-chart-in-excel-when-exporting-a-csv-file/95183 "2024-08-27T04:26:05Z")\ **Posts on this page:** 1\ **Showing post:** 6
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [August 27, 2024, 11:38am UTC](https://forum.inductiveautomation.com/t/how-to-create-a-chart-in-excel-when-exporting-a-csv-file/95183/6 "2024-08-27T11:38:36Z")
Consider creating an Excel file that has space for data, plus a chart pre-defined to use that space for its data. Store that "Excel template" in some gateway-readable folder in your server. Then use the approach described here to fill in the data and deliver the file: > [@Writing data to a excel template](https://forum.inductiveautomation.com/t/writing-data-to-a-excel-template/92674/2): > > There are numerous examples on this forum showing how to perform custom operations with Excel files via the Apache POI libraries that are provided with Ignition: [https://forum.inductiveautomation.com/search?q=apache%20poi%20excel%20perspective%20order%3Alatest](https://forum.inductiveautomation.com/search?q=apache%20poi%20excel%20perspective%20order%3Alatest) Most of these topics perform one the two following general sequences: Read: Upload a workbook (Perspective) or read a local workbook file (Vision), then Extract desired information from the content of the workbook, and finally Save t… --- _[View the full topic](https://forum.inductiveautomation.com/t/how-to-create-a-chart-in-excel-when-exporting-a-csv-file/95183)._