Put the data into a straight table in QlikView.
Import that chart as data into the Excel template
Populate an Excel pivot table from that data on a separate worksheet in the template
Format the Excel pivot table.
There's a tutorial here which shows you how to do it: