{"id":3445,"date":"2020-07-18T17:59:32","date_gmt":"2020-07-18T15:59:32","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3445"},"modified":"2024-05-20T20:13:28","modified_gmt":"2024-05-20T18:13:28","slug":"create-histogram-chart-excel-2016","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-histogram-chart-excel-2016\/","title":{"rendered":"Create an Excel 2016 Histogram Chart"},"content":{"rendered":"<p><strong>Excel 2016 Histogram Charts<\/strong> are one of the many new Charts available only in Excel 2016.<\/p>\n<p>They are\u00a0<strong>very visual<\/strong> as it can easily show you <strong>the distribution of numerical data<\/strong>, like seeing which <strong>numerical ranges are the most common<\/strong>.<\/p>\n<p>In this article, we will discuss the following:<\/p>\n<ul>\n<li><strong><a href=\"#what-is-a-histogram\">What is a Histogram?<\/a><\/strong><\/li>\n<li><strong><a href=\"#how-to-create-a-histogram-in-excel\">How to Create a Histogram in Excel<\/a><\/strong>\n<ul>\n<li><strong><a href=\"#using-the-built-in-option\">Using the Built-in Option<\/a><\/strong><\/li>\n<li><strong><a href=\"#using-the-data-analysis-toolpack\">Using the Data Analysis Toolpack<\/a><\/strong><\/li>\n<li><strong><a href=\"#using-the-frequency-function\">Using the Frequency Function<\/a><\/strong><\/li>\n<\/ul>\n<\/li>\n<li><strong><a href=\"#conclusion\">Conclusion<\/a><\/strong><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"what-is-a-histogram\"><\/a>What is a Histogram?<\/strong><\/h3>\n<p>Histogram is a graphical representation of data that <strong>shows frequency distribution<\/strong> i.e. count of data in a specified range.<\/p>\n<p>It looks like a column chart where each column or <strong>bar represents a specific range<\/strong> and its<strong> height determines the frequency<\/strong> or count of that range.<\/p>\n<p>For example, you can use the histogram to display the <strong>count of sales<\/strong> between different sales ranges like $0-$500, $500-$1000, $1000-$1500,\u00a0 $1500-$2000, and so on.<\/p>\n<p>This is how an Excel 2016 Histogram looks like this:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-306.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18652\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-306.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"432\" height=\"364\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-306.png 432w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-306-300x253.png 300w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/a><\/p>\n<p>Now that you are familiar with what a histogram is, let&#8217;s move forward and learn how to create a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/relative-frequency-histograms\/\" target=\"_blank\" rel=\"noopener\">Histogram in Excel<\/a> 2016.<\/p>\n<h3><strong><a id=\"how-to-create-a-histogram-in-excel\"><\/a>How to Create a Histogram in Excel?<\/strong><\/h3>\n<p>You can create a Histogram in different ways described below:<\/p>\n<ul>\n<li>In Excel 2016 using a <strong>Built-in Histogram Chart Option<\/strong>.<\/li>\n<li>In Excel 2013 or prior version, using a <strong>Data Analysis Toolpack<\/strong>.<\/li>\n<li>Using<strong> Frequency function<\/strong><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000\"><a id=\"using-the-built-in-option\"><\/a>Using Built-in Histogram Chart Option (In Excel 2016)<\/span><\/strong><\/p>\n<p>In this example, I show you How to Make a Histogram in Excel 2016.<\/p>\n<p>To upgrade to Excel 2016 you can use this link here: <a href=\"https:\/\/www.microsoftstore.com\/store\/msusa\/en_US\/cat\/categoryID.68155000?icid=en_US_homepage_whatsnew_2_OfficeCompare_160607\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Office 2016<\/a><\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/9rs6DV6IvGo?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><strong><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Histogram-Chart.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download excel workbook <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Histogram-Chart.xlsx<\/span><\/a><\/strong><\/p>\n<\/div>\n<p>Follow the step-by-step tutorial on How to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pie-chart-in-excel\/\" target=\"_blank\" rel=\"noopener\">Create a Histogram<\/a> in Excel 2016 with its built-in option available.<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span>Highlight your column with numerical data.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-3448\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-01.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"321\" height=\"429\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-01.png 321w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-01-224x300.png 224w\" sizes=\"(max-width: 321px) 100vw, 321px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong> <\/span>Go to <em><strong>Insert &gt; Recommended Charts<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-3449\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-02.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"451\" height=\"134\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-02.png 451w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-02-300x89.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> In the <strong>Insert Chart<\/strong> dialog box, Select <em><strong>All Charts &gt; Histogram\u00a0&gt; OK<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-3451\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-03.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"634\" height=\"600\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-03.png 634w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-03-300x284.png 300w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong><\/span>\u00a0Now you have your\u00a0<strong>Histogram\u00a0Chart<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-3452\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-04.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"543\" height=\"400\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-04.png 543w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-04-300x221.png 300w\" sizes=\"(max-width: 543px) 100vw, 543px\" \/><\/a><\/p>\n<p>You can easily change the way how your<strong> Histogram Chart represents\u00a0your data<\/strong>, by following the steps below:<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1: <\/strong><\/span><strong>Double-clicking<\/strong> on the <strong>horizontal axis<\/strong> containing our values.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-3453\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-05.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"542\" height=\"398\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-05.png 542w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-05-300x220.png 300w\" sizes=\"(max-width: 542px) 100vw, 542px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span>\u00a0In the\u00a0<strong>Format Axis\u00a0<\/strong>window,\u00a0pick the third option\u00a0<strong>Axis Options<\/strong>. Let us go through the options you can use:<\/p>\n<p>&nbsp;<\/p>\n<p><em><strong>Automatic &#8211;\u00a0<\/strong><\/em>Excel does the heavy lifting for you, and determines what the size of each bin would be.<\/p>\n<p><em><strong>Bin width\u00a0&#8211;\u00a0<\/strong><\/em>You tell Excel how many units each bin should be. In our example below, we are telling Excel that we want each bin to cover 9,984 units each.<\/p>\n<p><em><strong>Number of bins\u00a0&#8211;\u00a0<\/strong><\/em>Excel will automatically determine the size of each bin, however, you can modify the number of bins.<\/p>\n<p><em><strong>Overflow bin\u00a0&#8211;<\/strong><\/em><strong>\u00a0<\/strong>This\u00a0will set a threshold for your bins, any value above this threshold will be placed in this bin.<\/p>\n<p><em><strong>Underflow\u00a0bin\u00a0&#8211;<\/strong><\/em><strong>\u00a0<\/strong>This\u00a0will set a threshold for your bins, any value below\u00a0this threshold will be placed in this bin.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-3454\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-06.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"341\" height=\"500\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-06.png 341w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-06-205x300.png 205w\" sizes=\"(max-width: 341px) 100vw, 341px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> Try out the following settings to modify the<strong> Excel 2016 Histogram Chart:<\/strong><\/p>\n<p><strong>Number of Bins\u00a0<\/strong>&#8211; 20<\/p>\n<p><strong>Overflow Bin <\/strong>&#8211; 90,000<\/p>\n<p><strong>Underflow\u00a0Bin <\/strong>&#8211; 20,000<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-3455\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-07.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"341\" height=\"500\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-07.png 341w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-07-205x300.png 205w\" sizes=\"(max-width: 341px) 100vw, 341px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Now you have your cool\u00a0<strong>Histogram\u00a0<\/strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/grade-distribution-chart-in-excel\/\" target=\"_blank\" rel=\"noopener\">chart and you can quickly<\/a> point out to your management\u00a0which range of values are the most common ones&#8230;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-08.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone wp-image-3456 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-08.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"543\" height=\"400\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-08.png 543w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Histogram-Chart-08-300x221.png 300w\" sizes=\"(max-width: 543px) 100vw, 543px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000\"><a id=\"using-the-data-analysis-toolpack\"><\/a>Using Data Analysis Toolpack (In Excel 2013 or prior version)<\/span><\/strong><\/p>\n<p>Since the built-in histogram option is not available in Excel 2013 or the prior versions, you can create a <strong>Histogram using the Data Analysis Toolpack<\/strong>.<\/p>\n<p>In the data table, you have a <strong>daily stock price<\/strong> listed and the range (upper level) below:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-312.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18665\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-312.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"364\" height=\"389\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-312.png 364w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-312-281x300.png 281w\" sizes=\"(max-width: 364px) 100vw, 364px\" \/><\/a><\/p>\n<p>Let&#8217;s see how to create a histogram of the daily stock price reported!<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1: <\/strong><\/span>Go<b> <\/b>to <strong>Data Tab<\/strong> &gt; <strong>Data Analysis<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-309.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18662\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-309.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"1242\" height=\"130\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-309.png 1242w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-309-300x31.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-309-1024x107.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-309-768x80.png 768w\" sizes=\"(max-width: 1242px) 100vw, 1242px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2: <\/strong><\/span>In the<strong> Data Analysis<\/strong> dialog box, Select <strong>Histogram<\/strong> &gt; Press <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-310-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18664\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-310-1.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"388\" height=\"195\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-310-1.png 388w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-310-1-300x151.png 300w\" sizes=\"(max-width: 388px) 100vw, 388px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3: <\/strong><\/span>In the <strong>Histogram<\/strong> dialog box, enter the <strong>Input Range<\/strong> as $B$4:$B$579,<strong> Bin Range<\/strong> as $D$4:$D$15, <strong>Output Range<\/strong> as $F$3 and lastly make sure to check <strong>Chart Output<\/strong>.<\/p>\n<p>Press <strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-314.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18666\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-314.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"396\" height=\"294\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-314.png 396w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-314-300x223.png 300w\" sizes=\"(max-width: 396px) 100vw, 396px\" \/><\/a><\/p>\n<p>Your Histogram Chart is ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-315.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18668\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-315.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"673\" height=\"389\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-315.png 673w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-315-300x173.png 300w\" sizes=\"(max-width: 673px) 100vw, 673px\" \/><\/a><\/p>\n<p>You can change the format of this Chart by following the steps below:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1: <\/strong><\/span><strong>Right Click<\/strong> on the bar and select <strong>Format Data Series<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-321.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18670\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-321.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"699\" height=\"388\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-321.png 699w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-321-300x167.png 300w\" sizes=\"(max-width: 699px) 100vw, 699px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2: <\/strong><\/span>In the <strong>Format Data Series<\/strong> dialog box, change the <strong>Gap width<\/strong> from 150% to 0%.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-317.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18671\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-317.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"287\" height=\"364\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-317.png 287w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-317-237x300.png 237w\" sizes=\"(max-width: 287px) 100vw, 287px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3: <\/strong><\/span>Click on the <strong>Fill icon<\/strong>, change the<strong> color of the bar,<\/strong> and add a <strong>solid border line<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-318.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18672\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-318.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"285\" height=\"512\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-318.png 285w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-318-167x300.png 167w\" sizes=\"(max-width: 285px) 100vw, 285px\" \/><\/a><\/p>\n<p>Your formatted Histogram in Excel is ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-319.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18673\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-319.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"685\" height=\"390\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-319.png 685w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Screenshot-319-300x171.png 300w\" sizes=\"(max-width: 685px) 100vw, 685px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000\"><a id=\"using-the-frequency-function\"><\/a>Using Frequency function<\/span><\/strong><\/p>\n<p>The two ways that you saw earlier can easily help you create a histogram but they will not be <strong>dynamic i.e. they will not update once you change the data.<\/strong><\/p>\n<p>To make a dynamic Histogram, you can use a <strong>FREQUENCY<\/strong> function in Excel.<\/p>\n<p>FREQUENCY function in Excel is used to calculate how often values occur within a range of values. This function has two arguments &#8211; Data Array and Bins Array.<\/p>\n<ul>\n<li><strong>Data_Array<\/strong>: Range for which you get the frequencies.<\/li>\n<li><strong>Bins_Array<\/strong>: Range containing intervals or upper-level bins.<\/li>\n<\/ul>\n<p>You can use the Frequency to calculate how many values fall in the specified ranges and then <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/clustered-column-charts-in-excel\/\" target=\"_blank\" rel=\"noopener\">create a column chart<\/a> using that data.<\/p>\n<p>Let&#8217;s take the same example of the distribution of daily stock prices as above and see how the Frequency function works to create a Histogram.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-322.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18676\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-322.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"470\" height=\"406\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-322.png 470w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-322-300x259.png 300w\" sizes=\"(max-width: 470px) 100vw, 470px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1: <\/strong><\/span>Insert <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a> to be used will be <strong>=FREQUENCY(B4:B579, D4:D15).<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-324.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18680\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-324.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"605\" height=\"295\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-324.png 605w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-324-300x146.png 300w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2: <\/strong><\/span>Make sure to press <strong>Ctrl + Shift + Enter<\/strong> to complete the function and then copy-paste the formula below.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-326.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18679\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-326.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"563\" height=\"496\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-326.png 563w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-326-300x264.png 300w\" sizes=\"(max-width: 563px) 100vw, 563px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3: <\/strong><\/span>Select the <strong>Frequency Column<\/strong> and the Go to <strong>Insert<\/strong> &gt;<strong> Column Chart<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-330.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18681\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-330.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"793\" height=\"619\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-330.png 793w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-330-300x234.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-330-768x599.png 768w\" sizes=\"(max-width: 793px) 100vw, 793px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4: <\/strong><\/span>Go to <strong>Chart Design<\/strong> &gt; <strong>Select Data<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-332.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18682\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-332.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"1120\" height=\"128\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-332.png 1120w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-332-300x34.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-332-1024x117.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-332-768x88.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5:<\/strong><\/span>\u00a0In the <strong>Select Data Source<\/strong> dialog box, Under Horizontal (Category) Axis Label select Edit.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-328.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18683\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-328.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"583\" height=\"323\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-328.png 583w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-328-300x166.png 300w\" sizes=\"(max-width: 583px) 100vw, 583px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 6:<\/strong><\/span> Select the <strong>range containing the bin<\/strong> value i.e. D4:D15 and then Click OK.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-333.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel 2016 Histogram Chart\" class=\"alignnone size-full wp-image-18685\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-333.png\" alt=\"Create an Excel 2016 Histogram Chart\" width=\"760\" height=\"362\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-333.png 760w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-333-300x143.png 300w\" sizes=\"(max-width: 760px) 100vw, 760px\" \/><\/a><\/p>\n<p>Your dynamic Histogram 2016 Excel chart is ready!<\/p>\n<h3><strong><a id=\"conclusion\"><\/a>Conclusion<\/strong><\/h3>\n<p>A Histogram Excel 2016 can be used to show the number of data that fall within a specified range of values (bins).<\/p>\n<p>In this article, you have learned How to Create a Histogram in Excel using the <strong>built-in option<\/strong>, the <strong>data analysis toolpack<\/strong>, and the <strong>frequency function<\/strong>.<\/p>\n<p>To read about the other charts available in Excel,<strong> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/excel-charts\/how-to-make-a-graph-in-excel\/\" target=\"_blank\">Click Here<\/a>.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff\"><strong>HELPFUL RESOURCE:<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" class=\"alignnone wp-image-5924 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg\" width=\"530\" height=\"300\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot-300x170.jpg 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel 2016 Histogram Charts are one of the many new Charts available only in Excel 2016. They are\u00a0very visual as it can easily show you the distribution of numerical data, like seeing which numerical ranges are the most common. In this article, we will discuss the following: What is a Histogram? How to Create a [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17195,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Create an Excel 2016 Histogram Chart","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,127],"tags":[94,136,137],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3445"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=3445"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3445\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17195"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}