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.
Create %ge performance of each department with category 1-5
select the data range by highlighting rows and columns of the data and press OK
Drag the columns as shown above
Right click on any row -> Show Value as -> % of Row Total
Click on any row and click Pivot chart as shown below.