Frequency Distribution in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/frequency-distribution.

html

Excel Easy
#1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us

Frequency Distribution
Did you know that you can use pivot tables to easily create a frequency distribution in Excel? You can also use
Chapter
the Analysis Toolpak to create a histogram.

Remember, our data set consists of 214 rows and 6 fields. Order ID, Product, Category, Amount, Date and Pivot Tables
Country.

Learn more, it's easy

Group Pivot Table Items

Multi-level Pivot Table

Frequency Distribution

Pivot Chart

Slicers

Update Pivot Table

Calculated Field/Item

Download Excel File

frequency-distribution.xls

Follow Excel Easy

1 of 8 08-11 06:42 PM
Frequency Distribution in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/frequency-distribution.html

Invest in Mutual Funds

Browse the latest articles & videos on Mutual
Fund Investments. View!

Be Certified in Big Data

John Snow Data Viz

Bloomberg India
First, insert a pivot table. Next, drag the following fields to the different areas.

1. Amount Field to the Row Labels area.

2. Amount Field (or any other field) to the Values area.

2 of 8 08-11 06:42 PM
Frequency Distribution in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/frequency-distribution.html

3. Next, click any cell inside the Amount column.

4. Right click and click on Group.

3 of 8 08-11 06:42 PM
Frequency Distribution in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/frequency-distribution.html

4 of 8 08-11 06:42 PM
Frequency Distribution in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/frequency-distribution.html

5. Enter 0 for Starting at, 10000 for Ending at, and 1000 for By.

6. Click OK.

Result:

5 of 8 08-11 06:42 PM
Frequency Distribution in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/frequency-distribution.html

To easily compare these numbers, create a pivot chart.

7. Click any cell inside the pivot table.

8. On the Insert tab, in the Charts group, click Column and select one of the subtypes. For example, Clustered
Column.

Result:

6 of 8 08-11 06:42 PM
Frequency Distribution in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/frequency-distribution.html

Home loan @ 9.55%*

Get hassle free loan upto 85% and Low EMI only at DHFL. Apply Now!

Monthly SIP Investments

Download Application Form
Class 1 to Class 12
Start Download
Start Download
MDP on Business Analytics
Learn Excel VBA for free
Transparent graphene film
Vodafone Diwali Offer

Do you like this free website? Please follow us on Google+

7 of 8 08-11 06:42 PM
Frequency Distribution in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/frequency-distribution.html

Learn more about pivot tables, use the side menu >>
Go to Top: Frequency Distribution | Go to Next Chapter: Tables

COPYRIGHT (C) 2010-2015 WWW.EXCEL-EASY.COM. ALL RIGHTS RESERVED.

EXCEL 2010 TUTORIAL | HOW TO EXCEL | MICROSOFT EXCEL 2010 | EXCEL MACRO

8 of 8 08-11 06:42 PM