Your support helps wikiHow to create more in-depth illustrated articles and videos and to share our trusted brand of instructional content with millions of people all over the world.

He has over two years of experience writing and editing technology-related articles.

A histogram is a column chart that displays frequency data, allowing you to measure things like the number of people who scored within a certain percentage on a test.

Click Blank workbook in the upper-left corner of the window (Windows), or click File and then click New Workbook (Mac).

Bin numbers are what sort your data into groups in the histogram.

The easiest way to come up with bin numbers is by dividing your largest data point (e.g., 225) by the number of points of data in your chart (e.g., 10) and then rounding up or down to the nearest whole number, though you rarely want to have more than 20 or less than 10 numbers.

Now that you know how many bin numbers you have, its up to you to figure out the most even distribution.

Bin numbers should increase in a linear fashion while including both the lowest and the highest data points.

Starting in cell C1 and working down, type in each of your bin numbers.

Once youve completed this step, you can proceed with actually creating the histogram.

Its in the green ribbon thats at the top of the Excel window.

Doing so switches the toolbar near the top of the window to reflect the Insert menu.

Youll find this option in the Charts section of the Insert toolbar.

Click the left-most bar chart icon to select the Histogram model (rather than the Pareto model), then click OK.

Doing so will create a simple histogram with your selected data.

Right-click the horizontal axis (e.g., the axis with numbers in brackets), click Format Axis.

Type into the Bin width text box the value of an individual bin number, then press Enter.

Excel will automatically format the histogram to display the appropriate number of columns based on your bin number.

Press Ctrl S, select a save location, enter a name, and click Save.

Click the top value in cell A to select it, then hold down Shift while clicking the C cell thats across from the bottom-most A cell that has a value in it.

This will highlight all of your data and the corresponding bin numbers.

Before saving, make sure that your histogram looks accurate; if not, consider adjusting the bin numbers and redoing the histogram.

Amid the current public health and economic crises, when the world is shifting dramatically and we are all learning and adapting to changes in daily life, people need wikiHow more than ever.

Ni Histogram On Excel For Mac