Solution
If you are interested in using pivot tables in your ExcelTemplate reports, please refer to our documentation on Templates and Pivot Tables.
NOTE: Only use the above guide if you are using ExcelWriter 7.6 or later. There were several issues with using data markers with pivot tables that were resolved in ExcelWriter 7.6.
If you are using ExcelWriter 7.5 or later, please refer to Templates and Pivot Tables in Older Versions instead.