Create Summary Report in Excel Using PivotTable and PivotChart

PIVOT Table
Excel can help you by recommending and then automatically creating PivotTables, which are a great way to summarize, analyze, explore, and present your data. Make sure your data has column headings or table headers, and that there are no blank rows.

Scenario : Create a line chart from the available data of a school where the performance of all students are available in excel sheet.  This will enable the school head to measure the department wise performance  and also the overall performance.

data1

Task 1:

Create %ge performance of each department with category 1-5

View the complete video tutorial here in Youtube.

httpv://www.youtube.com/watch?v=g_iGJ1gjQ9Y

 

snip1

snip4

select the data range by highlighting rows and columns of the data and press OK

snip5 snip6

Drag the columns as shown above

snip7

Right click on any row -> Show Value as -> % of Row Total

snip8

Click on any row and click Pivot chart as shown below.

 

snip9

Download the sample excel data file from here.

 

 

 .