Future-Proof Your Career, Master Data Skills + AI

Blog

Blog

# How to Make a Histogram in Tableau: A Concise Guide

by | 11:16 am EDT | October 12, 2023 | Tableau

Histograms allow you to visualize the distribution of data points across continuous variables such as time, age, or sales figures.

This data visualization tool helps you understand your data sets’ underlying trends and patterns, allowing for better decision-making and analysis.

To make a histogram in Tableau, you must have a continuous variable in your dataset. You must drag and drop a continuous variable to the canvas and then click on Show Me. This will open a range of charting options. Select histograms from the menu, and Tableau will create a histogram for you.

But wait, there’s more.

Once you have configured your histogram, you can customize it by adjusting the bin sizes, adding reference lines, and modifying the chart’s aesthetics to match your desired visual style.

In this article, we will walk you through the complete procedure of creating stunning histograms in Tableau. We will demonstrate each step with examples to help you better understand the concepts.

Let’s get into it!

## Why Use a Histogram?

Before we dive into the steps for creating histograms, it is important to revisit why you would want to use a histogram.

A histogram is a graphical representation of the distribution of a continuous variable in the dataset. It is an estimate of the probability distribution of a continuous variable.

You may want to use histograms when:

1. Visualizing Data Distribution
2. Identifying Central Tendency
4. Detecting Outliers and Anomalies

## 2 Ways of Displaying Data in Histogram

There are two main ways of displaying data in a histogram:

1. Count of values within bins: This shows the actual number of observations in each bin.
2. Density of values (% of Total): This displays the percentage of observations in each bin relative to the total number of observations.

In the section below, we will demonstrate how you can represent data in a histogram as counts and percentages.

## 4 Steps to Create a Histogram in Tableau

Specifically, we will go over the following steps:

1. Identifying a continuous variable
2. Dropping the variable to the Canvas
3. Opening the Show Me toolbar and selecting histogram
4. Customizing the histogram

### Step 1. Identifying a Continuous Variable

By definition, a histogram is the distribution of a continuous variable. Therefore, you must have a continuous variable in your dataset to create a histogram.

In Tableau, continuous variables are also known as measures. You can find all your continuous variables at the bottom left of the Tableau window.

For demonstrations, we will use Quantity as our variable of choice.

### Step 2: Dropping The Variable to The Canvas

After identifying your continuous variable, you must drop it into the canvas as shown below:

Tableau will display the total number of quantities after dropping the Quantity variable onto the canvas.

Let’s go ahead and convert this into a histogram chart.

### Step 3: Opening The Show Me Toolbar And Selecting Histogram

You will see a Show Me button at the top-right corner of your screen. When you click on that, you will see a range of charting options that Tableau offers.

Here, you must click histogram.

Tableau will automatically create a histogram from the variable already present on the canvas.

### Step 4: Customizing the histogram

Now that you are done creating a histogram, let’s make it more appealing by making some customization.

The first thing you can do is to display the count per bin. You can do this by dragging and dropping CNT(Quantity) to the Text Label in the Marks card. Once done, your view should look like the following:

You can also drill down on histograms by dividing each bin on some dimension in your dataset.

Suppose I want to see the contribution of each category per bin. You can do this by dragging and dropping the Category dimension to Color in the Marks Card.

The histogram shows the contribution of the Quantity measure in each bin.

The next thing you can do is to convert the numbers inside the histograms. This will help make comparisons more easy for you.

To do this, right-click on CNT(Quantity), and select Quick Table Calculation. A table calculation dialog box will open. Click Percent of total.

Your histogram should look like the following now:

You can keep customizing your histogram until you get your desired output.

Learn Advanced Data Analytics (ADA) and see how you can take your histograms and their interpretation to another level.

## Final Thoughts

Histograms in Tableau are an essential data visualization tool. This is because when you can visualize your data’s frequency distribution, you’re better equipped to understand and interpret its nuances.

By learning how to make histograms in Tableau, you empower yourself to delve deeper into your data’s story. It allows you to recognize patterns, anomalies, and trends.

As you continue your journey with Tableau, you’ll find histograms useful for a range of applications. It adds more depth to your analytics.

In this section, you will find some frequently asked questions you may have when making histograms in Tableau.

### 1. How to create bins for a histogram?

First, drag the desired measure to the Columns shelf to create bins of Tableau histograms. Then, right-click the measure and select “Create” > “Bins”.

In the “Create Bins” dialog box, specify your desired bin size and click “OK”. The bins will be created, and you can then drag the new “bin” field into the Histogram chart.

### 2. What is the process of making a histogram with multiple measures?

To make a histogram with multiple measures in Tableau, first create separate histograms for each measure and then combine them using the “Add to Dashboard” feature.

You can also use the “Analytics” pane to drag a reference line for each histogram, showing the data distribution for each measure.

### 3. How to customize bins in a Tableau histogram?

To customize bins in a Tableau histogram, right-click on the bin field on the Rows shelf and select “Edit”.

In the “Edit” dialog box, you can adjust the bin size and other parameters. You can also create calculated fields to customize the bin size using formulas.

### 4. What are the steps to create a distribution chart?

To create a distribution chart in Tableau, you should follow these steps:

1. Connect to your data source.
2. Choose the measure for which you want to create a distribution.
3. Drag the chosen measure to either the Rows or Columns shelf.
4. Select the chart type as “Histogram” from the “Show Me” panel.
5. Customize the chart by adjusting the bin size and adding reference lines if required.

### 5. How to make a histogram with normal distribution?

To create a histogram with normal distribution in Tableau, you must overlay a normal distribution curve.

This can be done by creating a calculated field for the normal distribution function and adding it as a reference line or a second axis in the chart.

Adjust the parameters of the normal distribution function to match your data.

### 6. What differentiates a bar chart and a histogram in Tableau?

The main differences between a bar chart and a histogram in Tableau are their purposes and how the data is displayed.

A bar chart displays categorical data and is used to compare values across categories, while a histogram displays continuous numerical data and is used to show the distribution of values within a dataset.

In a bar chart, each bar represents a different category; in a histogram, each bar represents a range of values (called a bin) and their frequency in the dataset.

## How to Wrap Text in Tableau in 3 Simple Steps

When working with data in Tableau, you’ll often find the need to display long text or labels in a more...

## How Many Rows Can Tableau Handle?

Are you dealing with a large data set? Are you wondering how many rows can Tableau handle efficiently?...

## What If Analysis in Tableau: User Guide with Examples

Ever wished you could predict the future? With Tableau’s What-If Analysis, that’s not just a dream...

## How to Update Tableau in 4 Quick Steps

With frequent updates and new releases, Tableau continues to evolve and improve its functionality. To...

## What is Context Filter in Tableau? How to Apply and Set

One of the powerful features of Tableau is its ability to allow users to interact with data...

## How to Add a Grand Total in Tableau: 3 Quick Ways

So you'd like to add a grand total in Tableau? You're in luck; it's easy to do. Grand totals offer a...

## How to Replace Data Source in Tableau in 3 Simple Steps

In Tableau, data sources are the foundation for all your visualizations and analyses. They allow you to...

## How to Add a Legend in Tableau: Color, Size, Shape, and Label

In Tableau, legends provide vital context to your visualizations by explaining the color, size, or...

## How to Add Reference Line in Tableau: Quick Guide

Reference lines in Tableau can take your data visualization to the next level. They add context to your...

## Tableau Tooltip: A Design Guide for Customization

Are you ready to use Tableau tooltips to level up your visualizations and make them more insightful and...

## What is a Set in Tableau and How to Create Them: User Guide

Are you getting started with Tableau and looking to create a set? Well, you're in the right place. In...

## How to Join Data Sources in Tableau in 4 Simple Steps

Looking to join data sources in Tableau, but unsure where to start? You're in the right place. The...