You saw how you can group pivot table items, how you create Multi-level Pivot Table. This tutorial will show how you use frequency distribution in Excel. Frequency distribution is a counting of how many times numbers occur when you group them together. In order to create Histogram you need to have Analysis Toolpak installed in your computer.
Steps To create Frequency distribution in Excel is as follow:
Step 1: Insert a Pivot Table
Step 2: Drag the fields to the fields to the field area.
Drag salary to the row field area.
Drag salary or any other field to the value field area.
Note: We have taken salary in the value field area.
Step 3: Right Click anywhere in the value field area and go the Value Field Setting.
Step 4: Value Field setting dialog box appears. In the Summarize value by tab select Count.
Step 5: Click Ok
Step 6: Now, Right Click anywhere in the row field area and select Group. In the grouping dialog box type the value you want to start grouping with and type the end value of grouping as well. Also select by what difference you want to group value.
Here, we what to start grouping by 10000 and end grouping at 100000 with 100000 grouping difference.
Step 7: Click OK. Our Pivot table chart is ready with the frequency distribution in Excel.
Step 8: In order to compare this Pivot table we will create a chart.
Step 9: Click on Pivot table in the Insert Tab, Charts group. The Insert Chart dialog box appears.
Step 10: Click Ok
Note: Excel provides us with Frequency function with which you can use arrays to create frequency distribution
Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.