How to create a frequency chart in Excel

Charts give you an overview of numbers and figures. You only need to look at the chart without looking at the original data to determine the necessary statistical criteria. Especially with the frequency chart you can determine the frequency of occurrence of the event, the variability . The following article gives detailed instructions on how to create frequency charts in excel.

Example: The following data sheet is available:

How to create a frequency chart in Excel Picture 1

Draw a histogram to show the total score.

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

How to create a frequency chart in Excel Picture 2

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

How to create a frequency chart in Excel Picture 3

Step 3: The dialog box appears:

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

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

- Tick 2 selected Cumulative Percentage and Chart Output items .

How to create a frequency chart in Excel Picture 4

Result:

How to create a frequency chart in Excel Picture 5

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

How to create a frequency chart in Excel Picture 6

Above is how to draw the frequency chart hoping to help you. Good luck!