{"id":6540,"date":"2021-07-08T20:13:14","date_gmt":"2021-07-08T18:13:14","guid":{"rendered":"https:\/\/careerfoundry.inbearbeitung.de\/en\/?p=6540"},"modified":"2023-08-31T12:27:32","modified_gmt":"2023-08-31T10:27:32","slug":"how-to-create-a-histogram-in-excel","status":"publish","type":"post","link":"https:\/\/careerfoundry.inbearbeitung.de\/en\/blog\/data-analytics\/how-to-create-a-histogram-in-excel\/","title":{"rendered":"How to Create a Histogram in Excel: A Step-by-Step Guide"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">A histogram is a popular chart for <a href=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/blog\/data-analytics\/different-types-of-data-analysis\/\" target=\"_blank\" rel=\"noopener\">data analysis<\/a> in Excel. It is similar to a column chart and is used to present the distribution of values in specified ranges.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Excel provides a few different methods to create a histogram. In this article, I\u2019ll show you two different methods and explain the advantages and disadvantages of each method.<\/span><\/p>\n<p>Learn more Excel analysis skills with CareerFoundry&#8217;s<a href=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/short-courses\/become-a-data-analyst\/\"><strong> free 5-day data short course<\/strong><\/a>.<\/p>\n<p><span style=\"font-weight: 400;\">I&#8217;m going to cover:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"#what-is-a-histogram\"><span style=\"font-weight: 400;\">What is a histogram?<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"#histogram-vs-column-chart\"><span style=\"font-weight: 400;\">How is a histogram different from a column chart?<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"#histogram-chart\"><span style=\"font-weight: 400;\">How to create a histogram in Excel with the histogram chart<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"#histogram-formula\"><span style=\"font-weight: 400;\">How to create a histogram in Excel using a formula<\/span><\/a><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">So, let\u2019s dive in.<\/span><\/p>\n<h2 id=\"what-is-a-histogram\"><span style=\"font-weight: 400;\">1. What is a histogram?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">A histogram is a chart that shows the frequency distribution of a set of values.\u00a0<\/span><span style=\"font-weight: 400;\">The frequency distribution of these values are arranged into specified ranges known as bins.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Examples of using a histogram include grouping performance scores into ranges, grouping values into ranges of years, or survey responses grouped into age brackets. A histogram is a type of data visualization. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">You can learn all about <\/span><a href=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/blog\/data-analytics\/what-is-data-visualization\/\"><span style=\"font-weight: 400;\">what data visualization is in this guide<\/span><\/a><span style=\"font-weight: 400;\">, and we&#8217;ve also collected <\/span><a href=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/blog\/data-analytics\/data-visualization-examples\/\"><span style=\"font-weight: 400;\">some great data visualization examples<\/span><\/a><span style=\"font-weight: 400;\">.\u00a0<\/span><\/p>\n<h2 id=\"histogram-vs-column-chart\"><span style=\"font-weight: 400;\">2. How is a histogram different to a column chart?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">A histogram is very similar to a column chart, but they are not exactly the same. A few differences between the two charts include:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The purpose of a histogram is to present frequency distribution e.g., the count of exam scores grouped into ranges. Column charts compare values e.g., the total sales value of six different products.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The X axis of a histogram must be in order of its size e.g., 1-5, 6-10, 11-15. A column chart does not need to be in a specific order. The order depends on its purpose.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The X axis is formed of intervals or bins in a histogram. A column chart typically has text values in this axis, such as names of cities.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">There are no gaps between the columns of a conventional histogram.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">100% of the values in a data set must be included in a histogram. A column chart could be used to compare only the top 5 products.<\/span><\/li>\n<\/ul>\n<h2 id=\"histogram-chart\"><span style=\"font-weight: 400;\">3. How to create a histogram in Excel with the histogram chart<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The first method to create a histogram in Excel is to use the built-in histogram chart.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This chart is available in Excel 2016 and later, so if you have an earlier version of Excel, you can follow the second method provided in this post.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6543\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/data.png\" alt=\"Two rows of data in an Excel spreadsheet\" width=\"442\" height=\"367\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/data.png 442w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/data-300x249.png 300w\" sizes=\"auto, (max-width: 442px) 100vw, 442px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">There are 41 scores in this data, and we want to create a histogram that distributes the scores over intervals of 10 starting from the score of 40, and ending with 100 (the maximum score).<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select range A1:B42.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click <\/span><b>Insert <\/b><span style=\"font-weight: 400;\">&gt; <\/span><b>Insert Statistic Chart<\/b><span style=\"font-weight: 400;\"> &gt; <\/span><b>Histogram<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6544\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/insert-histogram.png\" alt=\"An annotated diagram showing how to create a histogram in Excel\" width=\"896\" height=\"495\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/insert-histogram.png 896w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/insert-histogram-300x166.png 300w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/insert-histogram-768x424.png 768w\" sizes=\"auto, (max-width: 896px) 100vw, 896px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The following histogram is inserted. It has grouped the scores into four bins.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6545\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/initial-distribution.png\" alt=\"A simple histogram in Excel\" width=\"744\" height=\"445\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/initial-distribution.png 744w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/initial-distribution-300x179.png 300w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">This is nothing like what we require, so we need to edit the axis options.<\/span><\/p>\n<ol>\n<li><span style=\"font-weight: 400;\">Right click on the category axis (x-axis) and click <\/span><b>Format Axis<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<li>Click the <b>Axis Options<\/b> category.<\/li>\n<li>Type <b>40 <\/b>for the <i>Underflow bin<\/i>. This is the score that the bins will start from.<\/li>\n<li>Type <b>90<\/b> for the <i>Overflow bin<\/i>. Scores of 91 or above will be included in this final bin.<\/li>\n<li>Specify a <i>Bin width<\/i> of <b>10<\/b>. This creates bins in intervals of 10 from 40.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6546\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/format-axis.png\" alt=\"A histogram in Excel with the drop-down menu used to format the axis\" width=\"800\" height=\"589\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/format-axis.png 800w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/format-axis-300x221.png 300w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/format-axis-768x565.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">An alternative to specifying a bin width would be to use the option to specify the number of bins required.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6547 size-full\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/axis-options.png\" alt=\"The format axis pane in Excel used to format the axis of a histogram\" width=\"476\" height=\"631\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/axis-options.png 476w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/axis-options-226x300.png 226w\" sizes=\"auto, (max-width: 476px) 100vw, 476px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The histogram is now looking good.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6548\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/excel-histogram.png\" alt=\"A histogram in Microsoft Excel\" width=\"770\" height=\"465\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/excel-histogram.png 770w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/excel-histogram-300x181.png 300w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/excel-histogram-768x464.png 768w\" sizes=\"auto, (max-width: 770px) 100vw, 770px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">An important thing to know is that the upper value of a bin is included, and the lower value is not (except for the first bin).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">So, if there is a score of 60, this is included in the (50, 60] bin and not the (60, 70] bin. This is specified by the different brackets in the axis, but this is not clear to the reader.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Some general improvements can be made to the histogram chart, such as editing the chart title, adding data labels, and changing the colors of the columns.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">These techniques are not covered in this article as our focus is on creating the histogram. There are many chart formatting options.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6549\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/final-histogram.png\" alt=\"A simple histogram showing exam score distribution in Excel\" width=\"746\" height=\"447\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/final-histogram.png 746w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/final-histogram-300x180.png 300w\" sizes=\"auto, (max-width: 746px) 100vw, 746px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The advantages of using this method to create a histogram are that we do not need to prepare bins in advance or write complex formulas. It is all controlled by the built-in chart and the options available.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The disadvantages are that it is only available in Excel 2016 or later and that you are confined to the abilities of the built-in chart. It lacks versatility.<\/span><\/p>\n<h2 id=\"histogram-formula\"><span style=\"font-weight: 400;\">4. How to create a histogram using a formula in Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Using a formula to count the occurrences in each bin provides more flexibility for your histogram. This is my preferred method and also works in all versions of Excel.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This method involves inserting a column chart instead of the histogram option and then formatting it to look like a conventional histogram.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">We will use the same exam score data used in the previous example, but two of the scores have been changed to less than 40.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">First we need to create the source data for our chart. This is the bins and the frequency of exam scores in each of those bins.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The following image shows the source created in this example. The bins are typed into range G4:G10 and the <\/span><a href=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/blog\/data-analytics\/countifs-function-excel\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">COUNTIFS function<\/span><\/a><span style=\"font-weight: 400;\"> is used to count the occurrences of the scores for each bin.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=COUNTIFS($B$2:$B$42,&#8221;&gt;=&#8221;&amp;E4,$B$2:$B$42,&#8221;&lt;=&#8221;&amp;F4)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The values in ranges E4:E10 and F4:F10 have been used to assist the COUNTIFS function. It makes it easier to change if the size of the bins changes in the future. These columns will be hidden as nobody wants to see them.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6550\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/bins-and-formula.png\" alt=\"An Excel spreadsheet with data and a formula typed into the formula bar\" width=\"764\" height=\"515\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/bins-and-formula.png 764w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/bins-and-formula-300x202.png 300w\" sizes=\"auto, (max-width: 764px) 100vw, 764px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">To create the histogram:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select range G4:H10<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click <\/span><b>Insert <\/b><span style=\"font-weight: 400;\">&gt; <\/span><b>Insert Column or Bar Chart<\/b><span style=\"font-weight: 400;\"> &gt; <\/span><b>Clustered Column<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6551\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/insert-chart.png\" alt=\"The steps you need to follow to create a histogram in Excel\" width=\"1088\" height=\"751\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/insert-chart.png 1088w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/insert-chart-300x207.png 300w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/insert-chart-1024x707.png 1024w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/insert-chart-768x530.png 768w\" sizes=\"auto, (max-width: 1088px) 100vw, 1088px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The following column chart is inserted. It looks great already, but we will make some general improvements and then remove the gap between each column.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6552\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/first-column-chart.png\" alt=\"A column chart in Excel\" width=\"1062\" height=\"503\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/first-column-chart.png 1062w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/first-column-chart-300x142.png 300w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/first-column-chart-1024x485.png 1024w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/first-column-chart-768x364.png 768w\" sizes=\"auto, (max-width: 1062px) 100vw, 1062px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">3. I have made the following changes to the column chart.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Edited the chart title to \u201cExam Score Distribution\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Formatted the columns to a green colour<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Removed the value axis (y-axis)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Removed the horizontal gridlines<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Added data labels above each column<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6553\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/after-changes.png\" alt=\"A column chart in Excel showing distribution of exam scores\" width=\"736\" height=\"439\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/after-changes.png 736w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/after-changes-300x179.png 300w\" sizes=\"auto, (max-width: 736px) 100vw, 736px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">4. To remove the gap between each column, right click on one of the columns and click <\/span><b>Format Data Series<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6554\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/format-data-series.png\" alt=\"A column chart in Excel, showing the menu used to format data series in the column chart\" width=\"594\" height=\"543\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/format-data-series.png 594w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/format-data-series-300x274.png 300w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">5. From the <\/span><i><span style=\"font-weight: 400;\">Format Data Series<\/span><\/i><span style=\"font-weight: 400;\"> pane, Click the <\/span><b>Series Options<\/b><span style=\"font-weight: 400;\"> category and change the <\/span><i><span style=\"font-weight: 400;\">Gap Width<\/span><\/i><span style=\"font-weight: 400;\"> to <\/span><b>0<\/b><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6555\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/gap-width.png\" alt=\"The format data series window in Microsoft Excel\" width=\"478\" height=\"471\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/gap-width.png 478w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/gap-width-300x296.png 300w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The gap between the column is removed making it look like a typical histogram.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6556\" src=\"http:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/final-histogram-2.png\" alt=\"A fully formatted histogram chart in Excel showing exam score distribution\" width=\"742\" height=\"439\" title=\"\" srcset=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/final-histogram-2.png 742w, https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-content\/uploads\/2021\/07\/final-histogram-2-300x177.png 300w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">By creating our own bins, this method provided more flexibility for our histogram. The first bin is for scores less than 40. And then the bins are in intervals of 10. The rigidity of the built-in histogram chart prevents this freedom.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This chart is also very easy to change in the future, as we just need to edit the values in the cells of the source data.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Finally, because the category axis (x-axis) is generated from range G4:G10, we were able to make it appear how we wanted.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Final thoughts<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Histograms are used to present the distribution of data arranged in intervals, known as bins. There are a few different methods to create a histogram in Excel. The method you choose will depend on your data, the level of flexibility required and how often your data changes.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For a hands-on introduction to the field of data analytics, try out <\/span><strong><a href=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/short-courses\/become-a-data-analyst\/\">this free five-day short course<\/a><\/strong><span style=\"font-weight: 400;\"><strong>.<\/strong> And, for more Excel tutorials, check out the following:<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/blog\/data-analytics\/iferror-function-excel\/\"><span style=\"font-weight: 400;\">How to use the IFERROR function in Excel<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/blog\/data-analytics\/countifs-function-excel\/\"><span style=\"font-weight: 400;\">How to use the COUNTIFS function in Excel<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/careerfoundry.inbearbeitung.de\/en\/blog\/data-analytics\/convert-text-to-numbers-excel\/\"><span style=\"font-weight: 400;\">Convert text to numbers in Excel (4 methods)<\/span><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>A histogram is a popular chart for data analysis in Excel. It is similar to a column chart and is used to present the distribution of values in specified ranges. Excel provides a few different methods to create a histogram. In this article, I\u2019ll show you two different methods and explain the advantages and disadvantages [&hellip;]<\/p>\n","protected":false},"author":43,"featured_media":6542,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_lmt_disableupdate":"yes","_lmt_disable":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-6540","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-analytics"],"acf":{"homepage_category_featured":false},"modified_by":"Matthew Deery","_links":{"self":[{"href":"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-json\/wp\/v2\/posts\/6540","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-json\/wp\/v2\/comments?post=6540"}],"version-history":[{"count":2,"href":"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-json\/wp\/v2\/posts\/6540\/revisions"}],"predecessor-version":[{"id":28715,"href":"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-json\/wp\/v2\/posts\/6540\/revisions\/28715"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-json\/wp\/v2\/media\/6542"}],"wp:attachment":[{"href":"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-json\/wp\/v2\/media?parent=6540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-json\/wp\/v2\/categories?post=6540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/careerfoundry.inbearbeitung.de\/en\/wp-json\/wp\/v2\/tags?post=6540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}