In this guide I'll present how to make an Excel template for exporting data into. One possible use is to have plots in the template and it will automatically add data exported to this template to the graph. I will use an existing template where one 1 graph is plotted, and edit it so it will draw a graph for 2 data columns instead of 1.  

First copy the existing template by clicking on it and using the + button. You will need to properly name like for example:
Setup name: 2 graphs 
Description: [for channel 1,2] 
as we did.


 

Now press "Edit" while the new template is selected to open it. We'll now edit the template so that the graph on "Results" sheet will also display the third column from "Data1" sheet. 


How it functions is that when pressing the export button it will take this template, copy it into an new .xlsx file and write new data to the "Data1" sheet.  
The graph in "Results" sheet will still be reference to the same cells, but there will be new data there.
 

Let's now add also the third column to the graph. Edit the graph as presented in the gif below. 



After that we need to properly save this template. Name it the exactly the same as initial template ("2 graphs" in our case) and save it in to the scripts folder (normally: C:\Users\Public\Documents\Dewesoft\System\Scripts). File ending must be .xltx.



When saving be sure that it gives you the prompt pictured below, asking you if you want to overwrite an existing file. 

You need to overwrite an existing file as the helper .xps file is referencing the .xlsx template made when we pressed the + button.
 
 

The new template is now read, let's use it. I've set up 2 simple AI channels and selected our new template. 



Now we are exporting to a new .xlsx file to export folder named test.xlsx. Pictured below is "Data1" sheet of this file where the exported data is located.


In "Results" sheet the graph is reading these columns and displaying them: