how to create a histogram graph with times and frequencies in excel for mac

A frequency distribution shows just how values in a data set are distributed across categories.

A histogram shows the same information in a cute little column chart.

Heres an example of how all this works everything will become clearer if youre currently confused.

The histogram plots out how many times your data falls into each of these categories.

The bins information shows Excel exactly what bins (categories) you want to use to categorize the unit sales data.

The bins information shown in the worksheet range E1:E12, for example, create hundred-unit bins: 0-100, 101-200, 201-300, and so on.

In the case of the example worksheet, the bin range is E1:E12.

To place the histogram in the current worksheet, for example, select the Output Range radio button and then enter the range address into its corresponding Output Range text box.

Then, optionally, enter a name for the worksheet into the New Worksheet Ply text box.

To place the frequency distribution and histogram information in a new workbook, select the New Workbook radio button.

For example, select the Pareto (Sorted Histogram) check box, and Excel sorts bins in descending order.

Conversely, if you dont want bins sorted in descending order, leave the Pareto (Sorted Histogram) check box clear.

If you dont select this check box, you dont get the histogram only the frequency distribution.

Here is the frequency distribution along with a histogram for the example workbook data.

He is the author of more than 100 books, including QuickBooks For Dummies and Quicken For Dummies.

How To Create A Histogram Graph With Times And Frequencies In Excel For Mac