such chart is possible in excel - the problem is creating the chart in the NPrinting template and making it work after the data is inserted to excel.
You have to create the chart in template using the whole rows. Then replace the first two lines with the nprinting placeholders. Uncheck the Expand range for the table. This way the values you have there will be replaced by data from QV and not pushed down.
Make sure you do not touch the chart after this step. Otherwise it will change the input range and you can start over.
My advice is to make sure there are no children or people easily offended by bad language when you try to do this