How to Chart the Frequency of a Data Set on Excel. ... Click the "Design" tab. Click "Change Chart Type" in the Type group. ... How to Make a Graph on Excel With a Cumulative Average.

This involves constructing, interpreting and comparing pie charts and cumulative frequency diagrams. Part of Application of Maths Statistical skills. ... Drawing a bar graph for grouped data.

A cumulative frequency diagram is drawn by plotting the upper class boundary with the cumulative frequency. The upper class boundaries for this table are 35, 40, 45, 50 and 55.