Pinterest Pixel

Frequency Distribution with Excel Pivot Tables

With Excel Pivot Tables you can do a lot of stuff with your data! But did you... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

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

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 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.

See also  Recommended Pivot Tables in Excel

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 itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

See also  The Ultimate Guide to Excel Pivot Table Slicers
Frequency Distribution with Excel Pivot Tables | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

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!