Create a Pivot Table for the above sales data.
#HOW TO MAKE A HISTOGRAM IN EXCEL 2016 WITH CLASS BOUNDARIES HOW TO#
Now we will see how to use this using a pivot table with the following steps. One of the easiest ways to make excel frequency distribution is using the pivot table so that we can create graphical data.Ĭonsider the below sales data which has a year-wise sale. This example shows how to make excel frequency distribution using graphical data with the available sales database. Now using the Excel Frequency Distribution, we have grouped the student’s marks with mark wise which shows students has scored marks with 0-10 we have 1 student, 20-25 we have 1 student, 50-55 we have 1 student, and 95-100 we have 1 student as shown below.Įxcel Frequency Distribution Using Pivot Table