using the easy chart to display data using the dbpens method. I was wondering if it was possible to have the export process use the pen name in lieu of Dataset 1, Dataset 2, etc for the sheets in the excel workbook?
here is an example of an export.
just wanted to update this in case someone runs into the same issue. Not quite what I requested, but this will work. It looks like you can use column aliasing for the column name where the value comes from. so if your column is trendvalue, you can use trendvalue as ‘pressure’. Now your column header inside of the excel document will be whatever you set the alias as, as opposed to just the column name.