[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Visualizations are a great way to gain further insight into your data. Different types of visualizations allow you to represent your data differently, so you can better understand what it means. Google Sheets offers a wide range of charts, but choosing the best one to visualize your data is up to you. The histogram is a great way to represent the value distribution of a given variable in terms of intervals. These intervals, known as bins or buckets, represent the frequency with which values in that interval appear in the data.<\/p>\n
In this guide, you will learn what a histogram is and how it differs from a column or bar chart, as well as how to create one in Google Sheets. You have step-by-step instructions on how to set up the data, create the histogram, and customize it to fit your needs. Finally, you will learn how to create a histogram using two sets of data.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”what-is-a-histogram” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
The histogram is a type of chart used to illustrate the distribution of values for a particular variable. The range of values is divided into equal-size bins or buckets along the x-axis, each representing an interval within this range. Along the y-axis, the height of the bins represents the frequency with which values in that interval occur.<\/p>\n
While they are similar in appearance, a histogram and a column or bar chart are quite different. Usually, column or bar charts are used to visualize categorical data. For example, bar charts are frequently used to visualize survey responses to multiple-choice questions. For that kind of data, see how to create a bar chart in Google Sheets<\/a>. Histograms, however, are used to visualize the distribution of numerical values for a numerical variable, like age, height, or grades.<\/p>\n For example, you can use a histogram to show the distribution of scores for a particular test. The range of the scores is given by the lowest and highest score, and you divide it into equal-sized bins. After assigning the scores to their corresponding bins, you count the number of occurrences per bin. Alternatively, you can take advantage of the fact that Google Sheets can do all of this for you.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-make-a-histogram-in-google-sheets” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Google Sheets makes it very easy to create a histogram chart without worrying about creating or filling the bins. Select the range of cells containing the values for your variable and go to Insert > Chart. Check that \u2018Chart type\u2019 is \u2018Histogram chart\u2019 in the \u2018Chart editor\u2019.<\/p>\n Fortunately, when using Google Sheets to create the histogram, there\u2019s very little to set up: a column with all the values for your variable. They don\u2019t even have to be in any particular order.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/how-to-make-a-histogram-in-google-sheets-score-data.webp” alt=”How to make a histogram in Google Sheets \u2014 Score column with test scores in column A” title_text=”Score column with test scores in column A” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Select the cells with the values and go to Insert > Chart. For more on the chart editor, see how to insert a chart in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-histogram-insert-chart-menu.webp” alt=”Google Sheets histogram \u2014 Insert menu open with Chart highlighted and the Score column selected” title_text=”Insert menu open with Chart highlighted and the Score column selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In the ‘Chart editor’ sidebar, check that \u2018Histogram chart\u2019 is selected under \u2018Chart type\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-histogram-chart-type.webp” alt=”Google Sheets histogram \u2014 Chart editor Setup tab with Histogram chart selected and the Histogram of Score chart” title_text=”Chart editor Setup tab with Histogram chart selected and the Histogram of Score chart” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-customize-a-histogram-in-google-s” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Once you have your histogram, you can edit and customize it to your liking. Below, you have instructions on how to customize the fonts and colors, how to edit titles and labels, how to change the buckets and add item dividers, and how to add a second set of data to create a double histogram.<\/p>\n In the \u2018Chart editor\u2019, click on the \u2018Customize\u2019 tab and then on \u2018Chart style\u2019 to expand the options.<\/p>\n As shown in the screenshot below, you can change the font, background color, and border color.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-histogram-chart-style.webp” alt=”Histogram in Google Sheets \u2014 Customize tab with Chart style options for background color, font and border color” title_text=”Customize tab with Chart style options for background color, font and border color” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To change any of the titles, click on \u2018Chart & axis titles\u2019 and then on the drop-down menu directly under it.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-histogram-chart-axis-titles.webp” alt=”Histogram in Google Sheets \u2014 Chart and axis titles drop-down with chart title, subtitle and axis title options” title_text=”Chart and axis titles drop-down with chart title, subtitle and axis title options” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n For each title, you can edit the text, font, font size, format, and text color.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-histogram-title-options.webp” alt=”Google Sheets histogram \u2014 Chart title text, font, font size, format and text color options” title_text=”Chart title text, font, font size, format and text color options” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Under \u2018Histogram\u2019, you can specify the size of the bins or buckets and outlier percentiles, as well as add item dividers within the buckets.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-histogram-bucket-size.webp” alt=”Google Sheets histogram \u2014 Histogram options with Show item dividers, bucket size and outlier percentile” title_text=”Histogram options with Show item dividers, bucket size and outlier percentile” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you already have a histogram with one set or series of values, you can easily add another series to create a double histogram.<\/p>\n In the \u2018Setup\u2019 tab, edit the data range to include the second column with values.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-double-histogram-data-range.webp” alt=”Double histogram in Google Sheets \u2014 data range changed to A1:B31 to include Score – Class B” title_text=”Data range changed to A1:B31 to include Score – Class B” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Click \u2018Add series\u2019 and select the second set of values.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-double-histogram-add-series.webp” alt=”Double histogram in Google Sheets \u2014 Add series list with Score – Class A and Score – Class B” title_text=”Add series list with Score – Class A and Score – Class B” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n That\u2019s it. You have your double histogram.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-double-histogram-result.webp” alt=”Double histogram in Google Sheets \u2014 blue and red bars for Score – Class A and Score – Class B” title_text=”Blue and red bars for Score – Class A and Score – Class B” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-make-a-double-histogram-in-google” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can make a double histogram in Google Sheets in a few simple steps. First, select both sets of values. Second, go to Insert > Chart. If the histogram chart is not chosen automatically, change it under \u2018Chart type\u2019 in the editor. You will need to make some small adjustments to the series.<\/p>\n 1.<\/strong> Select both sets of values and go to Insert > Chart.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-double-histogram-select-both-sets.webp” alt=”Double histogram in Google Sheets \u2014 both score columns selected with the Insert menu open on Chart” title_text=”Both score columns selected with the Insert menu open on Chart” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> In the \u2018Chart editor\u2019, check that \u2018Histogram chart\u2019 is selected under \u2018Chart type\u2019. Remove the first set of values from the X-axis, as shown below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-double-histogram-remove-x-axis.webp” alt=”Double histogram in Google Sheets \u2014 Score – Class A on the X-axis with the Remove option” title_text=”Score – Class A on the X-axis with the Remove option” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Add the first set of values as a series, as shown in the screenshot below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-double-histogram-add-first-series.webp” alt=”Double histogram in Google Sheets \u2014 Add series search with Score – Class A selected” title_text=”Add series search with Score – Class A selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Remember to remove the Y-axis title, as shown below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-double-histogram-remove-y-axis-title.webp” alt=”Double histogram in Google Sheets \u2014 Vertical axis title set to Score – Class B in the Customize tab” title_text=”Vertical axis title set to Score – Class B in the Customize tab” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> That\u2019s it. You have your double histogram so you can compare the two sets of values.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-double-histogram-compare-sets.webp” alt=”Double histogram in Google Sheets \u2014 finished chart comparing Score – Class A and Score – Class B” title_text=”Finished chart comparing Score – Class A and Score – Class B” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you have seen, histograms are a great way to visualize the frequency distribution of values for a numerical variable. The range of values is divided into equal intervals called bins or buckets, and the values are assigned to their corresponding bucket. The buckets are placed along the horizontal axis from lowest to highest, and the height of the buckets indicates the frequency of values in that interval.<\/p>\n You now know what a histogram is and how it differs from column or bar charts. You also know how easy it is to create a histogram chart in Google Sheets, as you don\u2019t even need to set up or fill the buckets. Finally, you also know how to customize your histogram and change its style, edit the titles and labels, and add another series to create a double histogram.<\/p>\n To learn more about charts and graphs in Google Sheets, check out these guides on:<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Aprenda a fazer um histograma no Google Sheets: prepare os dados, insira um histograma, altere as classes e os t\u00edtulos e crie um histograma duplo.<\/p>","protected":false},"author":2,"featured_media":265348,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-265332","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/265332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=265332"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/265332\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/265348"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=265332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=265332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=265332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to make a histogram in Google Sheets step-by-step?<\/h2>\n
1. Set up data<\/h3>\n
2. Insert chart<\/h3>\n
3. Select chart type<\/h3>\n
How to customize a histogram in Google Sheets?<\/h2>\n
Change chart style<\/h3>\n
Change chart titles<\/h3>\n
Change bins<\/h3>\n
Add a series to make a double histogram<\/h3>\n
How to make a double histogram in Google Sheets?<\/h2>\n
Conclusion<\/h2>\n
\n