Pinterest Pixel

Frequency Distribution with Excel Pivot Tables

Bryan
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?
Frequency Distribution with Excel Pivot Tables | MyExcelOnline Frequency Distribution with Excel Pivot Tables | MyExcelOnline

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

Want to know How to Create Frequency Distribution with Excel Pivot Tables?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch on YouTube and give it a thumbs up 👍

Frequency Distribution with Excel Pivot Tables | MyExcelOnline

Download excel workbookFrequency-Distribution.xlsx

 

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

 

Further Learning:

 

If you like this Excel tip, please share it
Frequency Distribution with Excel Pivot Tables | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Show Field and Value Settings in Excel Pivot Tables

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...