If you wish to create a a Pivot Table and Pivot Chart in Excel, ... Assume that you need the total of each student’s mark in all the subjects in the last row.