Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • Count rows that contain specific values in Excel
  • How to get address of named range in Excel
  • How to get last column number in range in Excel
  • How to get relative row numbers in a range in Excel

Data Analysis Examples

  • Managing Conditional Formatting Rules in Excel
  • Move chart to a separate worksheet in Excel
  • How To Insert and Customize Sparklines in Excel
  • How to perform a t-Test in Excel
  • How to count table columns in Excel

Data Validation Examples

  • Excel Data validation with conditional list
  • Excel Data validation no punctuation
  • Excel Data validation must contain specific text
  • How To Create Drop-down List in Excel
  • Excel Data validation exists in list

How To Create Frequency Distribution in Excel

by

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

Remember, our data set consists of 213 records and 6 fields. Order ID, Product, Category, Amount, Date and Country.

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

1. Amount field to the Rows area.

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

3. Click any cell inside the Sum of Amount column.

4. Right click and click on Value Field Settings.

5. Choose Count and click OK.

6. Next, click any cell inside the column with Row Labels.

7. Right click and click on Group.

8. Enter 1 for Starting at, 10000 for Ending at, and 1000 for By.

9. Click OK.

Result:

To easily compare these numbers, create a pivot chart.

10. Click any cell inside the pivot table.

11. On the Analyze tab, in the Tools group, click PivotChart.

The Insert Chart dialog box appears.

12. Click OK.

Result:

Post navigation

Previous Post:

Flash Fill in Excel

Next Post:

How to Create One and Two Variable Data Tables in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to create email address from name in Excel
  • SUBSTITUTE function vs REPLACE function in Excel
  • How to count number of characters of text in a cell in Excel
  • How to split text string at specific character in Excel
  • How to count total words in a range in Excel
  • YEARFRAC function: Description, Usage, Syntax, Examples and Explanation
  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • Convert date string to date time in Excel
  • NETWORKDAYS.INTL function: Description, Usage, Syntax, Examples and Explanation
  • Calculate series of dates by workdays in Excel
  • Calculate payment periods for loan in Excel
  • INTRATE function: Description, Usage, Syntax, Examples and Explanation
  • PDURATION function: Description, Usage, Syntax, Examples and Explanation
  • CUMIPMT function: Description, Usage, Syntax, Examples and Explanation
  • YIELDMAT function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles