With Excel Pivot Tables you can do a lot of stuff with your data! But did you know that you can even create a Frequency Distribution Table?

Let’s have some fun below! I’ll show you how easy it is to create your own Frequency Distribution Chart!

We will create a chart based on this table with Sales values:

Frequency Distribution with Excel Pivot Tables

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Let us insert a new Pivot Table. Select your data and Go to Insert > Tables > PivotTable

Frequency Distribution with Excel Pivot Tables

 

Select Existing Worksheet and pick an empty space to place your Pivot Table. Click OK.

Frequency Distribution with Excel Pivot Tables

 

STEP 2: Drag SALES into VALUES and ROWS and you’ll see your Pivot Table get updated:

Frequency Distribution with Excel Pivot Tables

Click on Sum of SALES and select Value Field Settings.

Frequency Distribution with Excel Pivot Tables

Select Count and click OK.

Frequency Distribution with Excel Pivot Tables

 

STEP 3: We are almost there! Right click on your Pivot Table and select Group.

Frequency Distribution with Excel Pivot Tables

Accept the suggested values. It will group our values by ranges of 10,000. Click OK.

Frequency Distribution with Excel Pivot Tables

Now it’s grouped together!

Frequency Distribution with Excel Pivot Tables

 

STEP 4: Go to Analyze > Tools > PivotChart 

Frequency Distribution with Excel Pivot Tables

Ensure Clustered Column is selected. Click OK.

Frequency Distribution with Excel Pivot Tables

Your awesome Frequency Distribution is now ready!

Frequency Distribution with Excel Pivot Tables

 

How to Create a Frequency Distribution

Frequency Distribution with Excel Pivot Tables

Helpful Resource:

Excel Pivot Table

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Slicer Connection Option Greyed Out For Excel Pivo... Sometimes when you create a Pivot Table and want to insert a Slicer you are unable to do this as the Slicer button is greyed.You try to click on the Slicer button but nothing happens.What gives??There are two things that can cause your Slicer connection to be grey...
Show The Percent of Parent Total With Excel Pivot ...  Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT TOTAL calculation.In the example below I show you how to get the Percent of a Product Total i.e The % Sales of each Product ...
Use An External Data Source To Import Data Into An... When creating an Excel Pivot Table, what happens if your data source is in another location?Would you have to copy your data into the same spreadsheet?Well, NO!  You can simply use the External Data Sources feature in your Pivot Table and Excel will magically import the d...
Sort an Excel Pivot Table Manually You have your Pivot Table ready, all sorted nicely both from a row and column perspective.  However you just need that one minor sorting tweak or two.Well, Excel seemingly has a lot of tricks and you can even sort an Excel Pivot Table manually!For our example, let's see t...