How to create Scatter Plot and Histogram Chart in Tableau

Last updated on Oct 25 2021
Anand Vishwanathan

Table of Contents

How to create Scatter Plot and Histogram Chart in Tableau

The scatter plot is used to visualize the relationship between the two measures. It is designed by adding measures in both x-axis and y-axis. This can show the trend or relationship between the measures selected.
To create a scatter plot, you should have at least one measure in the rows shelf and one measure in the columns shelf. However, you can add the dimensions field to the scatter plot that plays a role of different color making for already existing points in the scatter graph.
For example, consider the data source such as Sample-Superstore, if you want to find the variation of Sales field and Profit field as the two axes of the Cartesian plane is distributed according to their Sub-Category field.
To create a scatter plot, there are the following steps, such as:
Step 1: Drag the measure Sales and drop into the columns shelf.
Step 2: Drag the measure Profit and drop into the rows shelf.

Page 1 Image 1 27
Profit

Step 3: Drag the dimension Sub-Category and drop into the Label shelf under the Marks pane.

Page 2 Image 2 22
Marks pane.

After that, it creates the scatter plot that shows how the Profit field and Sales field is distributed across the dimension Sub-Category of products.

Page 2 Image 3 12
Dimension

Step 4: You can also get the values color encoded after dragging the Sub-Category field into the Color Shelf.
Below chart appears that show the scatter points with a different color for each point.

Page 3 Image 4 12
Color Shelf

The same scatter plot can show different values when you choose a dimension with hierarchy.
For example, expand the dimension Sub-Category to show the scatter plot values for the Manufacturers field.

Page 4 Image 5 4
Manufacturers

Histogram

A histogram chart is a chart that displays the shape of the distribution.
A histogram looks like a bar chart but group values for a continuous measure into range. In the histogram, each bar represents the height of the number of values present in that range.
To create a histogram, we need only one measure. It creates the additional bin field for the measure.
For example, consider the data source such as Sample-Superstore, and if you to find the Quantities of sales for different Segment. For this, follow the below procedure step by step, such as:
Step 1: Go to the worksheet.
Step 2: Drag the measure Quantity into the columns shelf.

Page 5 Image 6 4
Quantity

Step 3: Click on the “show me” toolbar and select the histogram chart icon, shown in the below screenshot.

Page 5 Image 7 2
histogram

NOTE: The histogram chart is available in “show me” when the view contains only one measure and no dimensions.

Step 4: After selecting the histogram chart as the chart type. Then,
• The view changes and shows vertical bars, with a continuous X-axis and Y-axis.
• The measure Quantity with SUM aggregate in columns shelf is replaced by continuous Quantity(bin) dimension.
• The Quantity field moves to the rows shelf and aggregation changes from SUM to CNT or (Count).

Page 6 Image 8 3
Quantity(bin)

Step 5: Drag the dimension Segment and drop into the Color shelf under the Marks pane.

Page 7 Image 9 2
Segment

After adding the Segment field to Color shelf, you can see a relationship between the Segment field and the Quantity of item as per order is shown in the below screenshot.

Page 7 Image 10 1
Quantity of item

Step 6: Hold the Ctrl key in the keyboard and drag CNT(Quantity) field from the rows shelf Label shelf under the Marks pane.

Page 8 Image 11
CNT(Quantity)

Step 7: Right-click on the CNT(Quantity) field in Marks pane. And
• Click on the Quick Table Calculation option from the list.
• Select the Percent of Total option.

Page 9 Image 12
Percent of Total

Now each colored section of each bar shows its percentage of total quantity shown in the following screenshot.

Page 10 Image 13
Percentage of total quantity

So, this brings us to the end of blog. This Tecklearn ‘How to create Scatter Plot and Histogram Chart in Tableau’ blog helps you with commonly asked questions if you are looking out for a job in Tableau Desktop. If you wish to learn Tableau Desktop and build a career in Business Intelligence domain, then check out our interactive, Tableau Desktop Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Tableau Desktop

Tableau Desktop Training

About the Course

Tecklearn’s Tableau Desktop Training teach you how to transform raw data into interactive and shareable dashboards using Tableau. Our Tableau Course covers the necessary analytical skills to Advanced data visualizations by incorporating real-world use-case scenarios, labs, and exercises. Some of the topics included are Data Blending, Data Mapping, Graphs, creation of charts, and LOD expression by using different versions of Tableau, such as Tableau Desktop, Tableau Reader, and Tableau Public.

Why Should you take Tableau Desktop Training?

• The average salary of a Tableau Professional ranges between $108,697 to $158,000 per annum -Indeed.com.
• Tableau has been positioned as a Leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms – Gartner.com.
• Fidelity Investments, Capgemini, EY, Deloitte, EY, JP Morgan, Verizon, Facebook, Dell, General Motors, KPMG, Bank of America and 40,000 other MNCs worldwide across industries use Tableau.

What you will Learn in this Course?

Understanding Tableau

• Why Tableau
• Tableau Product Platforms
• Tableau Architecture
• Tableau Interface

Data Connection with Tableau Desktop

• Features of Tableau Desktop
• Connect to data from File and Database
• Types of Connections
• Data Blending
• Joins and Unions
• Tableau Desktop User Interface
• Basic project: Create a workbook and publish it on Tableau Online

Basic Visual Analytics

• Visual Analytics
• Basic Charts: Bar Chart, Line Chart, and Pie Chart
• Hierarchies
• Data Granularity
• Highlighting
• Sorting
• Filtering
• Grouping
• Sets

Advanced Visual Analytics

• Parameters
• Tool tips
• Trend lines
• Reference lines
• Forecasting
• Clustering

Calculations in Tableau

• Calculated Fields
• Numeric, String, Data, Logical, Addressing and Partitioning
• Table Calculations

Level of Detail (LOD’s) Calculations

Advanced Charts in Tableau

• Box and Whisker’s Plot
• Bullet Chart
• Bar in Bar Chart
• Gantt Chart
• Waterfall Chart
• Pareto Chart
• Control Chart
• Funnel Chart
• Bump Chart

Parameters

• What If Scenarios
• Parameter in CF (KPI control)
• Parameter in Filter (Top N)
• Parameter in reference line

Dashboards and Stories

• Introduction to Dashboards
• The Dashboard Interface
• Dashboard Objects
• Building a Dashboard
• Dashboard Layouts and Formatting
• Interactive Dashboards with actions
• Designing Dashboards for devices
• Story Points

Data Security in Tableau

Optimizations tips and tricks

Interacting with Tableau Server

Working with Tableau JavaScript API

Got a question for us? Please mention it in the comments section and we will get back to you.

0 responses on "How to create Scatter Plot and Histogram Chart in Tableau"

Leave a Message

Your email address will not be published. Required fields are marked *