Table of content

Histogram Charts in Tableau

A histogram chart in Tableau represents the frequencies of values of a variable bucketed into ranges. A Histogram is similar to a bar chart but it groups the values into continuous ranges. Each bar in the histogram represents the height of the number of values present in that range.

Tableau creates a histogram by taking one measure. It creates an additional bin field for the measure used in creating a histogram.

Creating a Histogram Graph in Tableau:

  • Open Tableau and click on Connect to Data.
    connect-to-data-tableau
  • Then the Connect page will open, click on Microsoft Excel.
    click-on-connect-to-data-excel-file-tableau
  • Navigate to the downloaded files, select Sample Superstore.xls excel file, which is a saved excel file, and click on Open.
    connect-sample-superstore-to-tableau
  • You can download a Sample Superstore.xls file from the link: https://chercher.tech/files/
  • Once the data source has been connected, open a new worksheet by clicking on sheet1.
    naviagte-to-sheet1-tableau
  • Sample Superstore.xls excel file contains the below details.
    sample-superstore-excel-file-tableau
  • Here, we are going to find the quantities of sales in different regions.
  • Drag the measure value quantity to the row shelf.
  • Select Histogram chart from Show Me.
  • Now, you can see the chart created, which shows the quantities bucketed automatically into the values ranging from 0-1457 as below.
    histogram-chart-with-values-ranging-values-tableau
  • You can also create a Histogram chart by adding dimensions to measures. This will create a stacked histogram.
  • Each bar will have a stacks representation of dimension values.
  • Add the Region Dimension to the color Shelf under Marks Card.
  • This creates the following histogram where each bar also includes the visualization for different regions.
    stacked-histogram-chart-tableau
0 results
Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions