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.
  • Then the Connect page will open, click on Microsoft Excel.
  • Navigate to the downloaded files, select Sample Superstore excel file data source, which is a saved excel file, and click on Open.
  • You can download a Sample Superstore.xls file from the given link:
  • Once the data source has been connected, open a new worksheet by clicking on sheet1.
  • The Sample Superstore excel file contains the below details.
  • 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.
  • 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.
0 results
Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions