{"id":8471,"date":"2018-11-22T06:55:13","date_gmt":"2018-11-22T06:55:13","guid":{"rendered":"http:\/\/www.nurturetechacademy.in\/?p=8471"},"modified":"2018-11-22T06:55:50","modified_gmt":"2018-11-22T06:55:50","slug":"create-histogram-chart-excel","status":"publish","type":"post","link":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/create-histogram-chart-excel\/","title":{"rendered":"How to Create a Histogram Chart in Excel"},"content":{"rendered":"<p><em>According to\u00a0<\/em><a href=\"http:\/\/www.investopedia.com\/terms\/h\/histogram.asp\"><em>Investopedia<\/em><\/a><em>, \u201ca Histogram is a graphical representation, similar to a\u00a0bar chart\u00a0in structure, that organizes a group of data points into user-specified ranges. The histogram condenses a data series into an easily interpreted visual by taking many data points and grouping them into logical ranges or bins\u201d.<\/em><\/p>\n<p>In other words, Histogram is a type of Column chart which shows the range of data. For example, if we have assigned scores to our sales representatives, on the basis of their sales, then we can create a histogram chart to show how many sales representatives are falling in which score bin e.g. we will be able to know, how many scored less than 40, how many scored in between 40 to 80 and more than 80.<\/p>\n<p>There are a couple of ways to create a histogram-<\/p>\n<p><strong>MS Office 2013 or prior version<\/strong>: We can create histogram chart using \u201cData Analysis tools\u201d or frequency tool(<em>We will be discussing it in our next blog post<\/em>).<\/p>\n<p><strong>Ms-office 2016, 2019 or Office 365<\/strong>: This chart type has been inbuilt in the chart group (we will be discussing the same in this blog post).<\/p>\n<p>Suppose we have a dataset of our sales team and their scores out of 100.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8472\" src=\"https:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-1.png\" alt=\"Pic-1\" width=\"237\" height=\"491\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-1.png 237w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-1-145x300.png 145w\" sizes=\"auto, (max-width: 237px) 100vw, 237px\" \/><\/p>\n<p>Steps to create Histogram chart in Office 2016 and upper version:<\/p>\n<ul>\n<li>Select the entire database<\/li>\n<li>Click on the insert tab<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8473\" src=\"https:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-2-1.png\" alt=\"Pic-2\" width=\"850\" height=\"366\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-2-1.png 850w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-2-1-600x258.png 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-2-1-300x129.png 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-2-1-768x331.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<ul>\n<li>From the chart group section, select \u201cInsert statistic chart\u201d<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8474\" src=\"https:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-3.png\" alt=\"Pic-3\" width=\"663\" height=\"494\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-3.png 663w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-3-600x447.png 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-3-300x224.png 300w\" sizes=\"auto, (max-width: 663px) 100vw, 663px\" \/><\/p>\n<ul>\n<li>Select the Histogram chart<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8475\" src=\"https:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-4.png\" alt=\"Pic-4\" width=\"424\" height=\"439\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-4.png 424w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-4-290x300.png 290w\" sizes=\"auto, (max-width: 424px) 100vw, 424px\" \/><\/p>\n<p>Based on our data set, we would be getting the histogram chart as shown in the above screenshot.<\/p>\n<p>Customization of Chart-<\/p>\n<p>As you may have noticed, the horizontal axis showing some default bins, depending upon the scores in our dataset. Although we can customize the same and much more by following steps-<\/p>\n<p>1- right click on the Horizontal axis<\/p>\n<p>2- select format axis<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8476\" src=\"https:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-5-1.png\" alt=\"Pic-5\" width=\"702\" height=\"463\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-5-1.png 702w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-5-1-600x396.png 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-5-1-300x198.png 300w\" sizes=\"auto, (max-width: 702px) 100vw, 702px\" \/><\/p>\n<p>After clicking on this option, we\u2019ll get format Axis pane \u2013<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8477\" src=\"https:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-6.png\" alt=\"PIc-6\" width=\"451\" height=\"452\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-6.png 451w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-6-300x300.png 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-6-100x100.png 100w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-6-150x150.png 150w\" sizes=\"auto, (max-width: 451px) 100vw, 451px\" \/><\/p>\n<p>These options will help us to customize our histogram chart. Let\u2019s discuss them one by one-<\/p>\n<p><strong>By Category<\/strong>&#8211; This will show the name of the categories, which make sense when we are actually dealing with categories like Pen, Pencil, box, eraser etc. but here we have a name of the sales representatives. This will be inappropriate (<em>refer to the screenshot below<\/em>).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8478\" src=\"https:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-7.png\" alt=\"PIc-7\" width=\"847\" height=\"392\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-7.png 847w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-7-600x278.png 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-7-300x139.png 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-7-768x355.png 768w\" sizes=\"auto, (max-width: 847px) 100vw, 847px\" \/><\/p>\n<p><strong>Automatic<\/strong>-This option will automatically decide the total number of bins. For example, according to our dataset, it has taken 4 bins, however, we can change the number of bins according to our requirement.<\/p>\n<p><strong>Bin width<\/strong>&#8211;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8479\" src=\"https:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-8.png\" alt=\"PIc-8\" width=\"769\" height=\"442\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-8.png 769w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-8-600x345.png 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-8-300x172.png 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-8-768x441.png 768w\" sizes=\"auto, (max-width: 769px) 100vw, 769px\" \/><\/p>\n<p>Here we can define the width of the bin. If we put number 10 inside the bin width box, it will create a bin range, which looks like this (11-21,21-31,31-41,51-61 etc.)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8480\" src=\"https:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-9.png\" alt=\"PIc-9\" width=\"638\" height=\"272\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-9.png 638w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-9-600x256.png 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-9-300x128.png 300w\" sizes=\"auto, (max-width: 638px) 100vw, 638px\" \/><\/p>\n<p><strong>Number of Bins<\/strong>&#8211; here we can specify the number of bins. Once we change the number of bins, it will automatically create a chart based on the number of bins. In the case of the histogram, we can change either the bin width or the number of bins. Not both.<\/p>\n<p><strong>Overflow Bin<\/strong>&#8211;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8481\" src=\"https:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-10.png\" alt=\"PIc-10\" width=\"807\" height=\"380\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-10.png 807w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-10-600x283.png 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-10-300x141.png 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-10-768x362.png 768w\" sizes=\"auto, (max-width: 807px) 100vw, 807px\" \/><\/p>\n<p>If we want to highlight score &gt;80 on the chart then we can use Overflow bin.<\/p>\n<p><strong>Underflow bin<\/strong>&#8211; Similarly to overflow bin, If we want to know the number of the salesperson who scored less than 30 (&lt;30) then we can use underflow bin.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8482\" src=\"https:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-11.png\" alt=\"PIc-11\" width=\"836\" height=\"378\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-11.png 836w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-11-600x271.png 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-11-300x136.png 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/PIc-11-768x347.png 768w\" sizes=\"auto, (max-width: 836px) 100vw, 836px\" \/><\/p>\n<p>In our next blog, we will discuss \u201chow to create a histogram with Data analysis tool?\u201d.<\/p>\n<p>We hope this blog post will help you to create and customize histogram chart. We would love to hear your suggestions, ideas and how this blog post helped you. If you have any query, feel free to write down in the comment box.<\/p>\n<p>&nbsp;<\/p>\n<p>Stay connected and stay updated.<\/p>\n<p>Happy Learning \ud83d\ude0a<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8471\" class=\"pvc_stats all  \" data-element-id=\"8471\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>According to\u00a0Investopedia, \u201ca Histogram is a graphical representation, similar to a\u00a0bar chart\u00a0in structure, that organizes a group of data points into user-specified ranges. The histogram condenses a data series into an easily interpreted visual by taking many data points and <\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8471\" class=\"pvc_stats all  \" data-element-id=\"8471\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":8483,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[56],"tags":[265,266,263,243,264,336,257,260,259,249,256,248,329,331,330,332,333,334,335,244,250,252,245,253,254,246,251,267,255,262,258,247,261],"class_list":["post-8471","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-corporate-training-companies","tag-corporate-training-companies-in-delhi","tag-corporate-training-courses","tag-corporate-training-in-delhi","tag-corporate-training-programs","tag-easy-to-use-histogram","tag-excel-course-online","tag-excel-courses-online","tag-excel-online-course","tag-excel-online-training","tag-excel-training-in-delhi","tag-excel-training-online","tag-histogram-chart","tag-histogram-chart-example","tag-histogram-chart-in-excel","tag-histogram-chart-in-excel-2013","tag-histogram-chart-uses","tag-how-to-create-histogram-chart","tag-learn-histogram","tag-learn-microsoft-excel","tag-learn-ms-excel-online","tag-learning-excel-online","tag-learning-microsoft-excel","tag-microsoft-excel-course","tag-microsoft-excel-online-training","tag-microsoft-excel-training","tag-ms-excel-learning","tag-ms-excel-online-training","tag-ms-excel-training-in-delhi","tag-online-corporate-training","tag-online-excel-course","tag-online-excel-training","tag-online-excel-training-courses"],"_links":{"self":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/8471","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/comments?post=8471"}],"version-history":[{"count":3,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/8471\/revisions"}],"predecessor-version":[{"id":8486,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/8471\/revisions\/8486"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media\/8483"}],"wp:attachment":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media?parent=8471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/categories?post=8471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/tags?post=8471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}