How To Make A Histogram With Non Numeric Data

Histograms show the distribution of numeric data, and at that place are several different ways how to create a histogram nautical chart. Distributions of non-numeric data, eastward.g., ordered categorical data, look similar to Excel histograms. However, y'all cannot use Excel histogram tools and demand to reorder the categories and compute frequencies to build such charts.

In this instance, the histogram chart shows the distribution of birthdays past month for the more than 3000 employees of a visitor. Months are just one example of ordered categorical data. Others are categories of size (small, medium, large), weight (calorie-free, normal, heavy), etc.

To create a histogram nautical chart of not-numeric data in Excel 2016, exercise the post-obit:

   1. Set up the information for the chart:

   1.i. Add together the new information for the nautical chart:

Where:

• Cavalcade Calendar month repeats the data from the column Birthday and has the format "mmm" to show simply a calendar month name:

  = TEXT (<birthday>, "mmm")

• Cavalcade Number has the number ane (one person has this date of birthday).

   1.ii. Sort the additional data for the nautical chart:

Note : This step is optional. It is needed to come across the months in the chart in sorted order. Skip this pace if y'all have non-numeric categories that do not require sorting.

To sort the data derived from the other data, y'all tin can:

• Select and sort all the data, including the cells from which the formula calculates,
• Select only additional data, copy information technology to the Clipboard (past clicking Ctrl+C), and then paste it using the Paste Special options, see Paste results into cells without formulas.

   1.2.1. Select the data (in this example, D2:D3041 or select the column).

   1.2.two. On the Home tab, in the Editing group, click the Sort & Filter push button and so select Custom Sort...:

   one.2.3. In the Sort dialog box:

• In the Sort by list, choose the cavalcade for sorting,
• In the Club list, cull the sorting method (see Using a custom sort gild),
• Make sure that the option My data has headers is selected, if yous selected the columns with respective headers):

   ii. Create a histogram chart:

   2.1. Select the prepared data (in this example, D2:E3041 ).

   2.two. On the Insert tab, in the Charts group, click the Statistic push:

From the Statistic dropdown list, select Histogram:

Excel creates the incomprehensible histogram chart from the information:

   three. Format the histogram chart axes:

   three.1. Right-click on the horizontal centrality and choose Format Axis... in the popup card:

   3.two. In the Format Axis pane, on the Axis Options tab, under Bins, select the By Category option:

Excel changes the histogram chart:

Make any other adjustments y'all find appropriate.

How To Make A Histogram With Non Numeric Data,

Source: https://www.officetooltips.com/excel_2016/tips/how_to_create_a_histogram_chart_by_categories_in_excel.html

Posted by: gonzalesnowent.blogspot.com

Share this post