How to Create a Frequency Chart in Excel: Step-by-Step Guide

This updated guide explains how to Create a Frequency Chart in Excel through clear steps, practical examples, and important checks that help prevent common errors.

Example

The following data sheet is available:

Create a Frequency Chart in Excel � Example screenshot 1

Draw a histogram to show the total score.

Step 1: Go to DATA tab -> Data Analysis .

Create a Frequency Chart in Excel � Example screenshot 2

Step 2: A dialog box appears, select Histogram -> OK .

Create a Frequency Chart in Excel � Example screenshot 3

Step 3: The dialog box appears:

- Input Range : Select the data area you may need to show on the chart.

- Output Range : Select the position you may need to show the chart.

- Tick 2 selected Cumulative Percentage and Chart Output items.

Create a Frequency Chart in Excel � Example screenshot 4

Result:

Create a Frequency Chart in Excel � Example screenshot 5

You can edit the chart on your own. Right-click the chart, select Format Chart Area -> The dialog box appears, select the chart color, font, chart style, effects.

Create a Frequency Chart in Excel � Example screenshot 6

FAQ

What is the easiest way to Create a Frequency Chart in Excel?

Start with the requirements in this guide, then follow each step in order. Check the result after every major change so problems are easier to identify.