This thread seems to be parallel to what you are trying to accomplish. So, move one of the objects temporarily so they are not stacked on top of one another. Remove the conditional show so that you and Nprinting can see both of your objects. Build your Nprinting report and then restore the layout with the hidden charts after you have it set up.
The second question is a little more complicated. Anytime you are building dynamic objects in an Excel template, it is challenging to make calculations that span more than one sheet. So, my advice to you is to build another object in QV that calculates your desired total based on the two Pivot tables. Then you can just use the results from that chart in your NPrinting template. Again, you can hide this object after you have successfully added it to your template.