Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs

Tableau Scatter Plot

by suresh

Tableau Scatter Plot is useful to visualize the relationship between any two sets of data. In this article, we will show you how to Create a Scatter Plot in Tableau with an example. For this scatter plot in Tableau example, we write a custom SQL query.

-- SQL Query to create a Scatter Plot in Tableau
SELECT Geo.EnglishCountryRegionName, 
       Geo.StateProvinceName, 
       Geo.City, 
       Geo.PostalCode, 
       Fact.OrderQuantity, 
       Fact.TotalProductCost, 
       Fact.SalesAmount, 
       Fact.TaxAmt, 
       Fact.OrderDate
FROM FactInternetSales AS Fact 
   INNER JOIN
     DimCustomer AS Cust ON Fact.CustomerKey = Cust.CustomerKey
   INNER JOIN
     DimGeography AS Geo ON Cust.GeographyKey = Geo.GeographyKey

How to Create a Scatter Plot in Tableau

To create a Scatter plot in Tableau, drag and drop the Order Quantity from Measures Region to Rows Shelf and Sales Amount from Measures region to Columns Shelf. The Tableau intelligence will automatically select the scatter plot, and if it does not case, please select the Scatter plot option from the Show Me window.

Tableau Scatter Plot 1

As you see that it is showing the aggregated data.But, we require to see the detailed information. So, let me drag and drop the Postal Code from Dimensions Region to Details field present in Marks Shelf.

Tableau Scatter Plot 2

Add Linear Progression to Scatter Plot in Tableau

This example shows how to add the linear progression to the scatter plot. Tableau provides two different ways to add linear progression.

First Approach: You can add the progression, or Trend lines using the Trend Line option available in the Tableau. To access this option, Please navigate to the Analytics tab.

Tableau Scatter Plot 3

Next, Drag and drop the Tableau Trend Line to the Plotting area.

Tableau Scatter Plot 4

Second Approach: Right-click on the Plotting area will open the context menu. Please select the Trend Lines, and click on the Show Trend Lines option.

Tableau Scatter Plot 5

Once you click on the Show Trend Lines option, Tableau scatter plot will show the Trendline, along with the confidence bands.

Tableau Scatter Plot 6

By default, Tableau will add the confidence bands to the Trendline, but you can alter these default settings. To do so, right-click on the Plotting area and select the Trend Lines, and click on the Edit Trend Lines …option from the context menu.

Tableau Scatter Plot 7

It will open a new window called the Trend Lines Options. Here you can change the default Linear Model to Logarithmic, Exponential, Polynomial, etc. Here, we will remove the Confidence bars. To do this, please uncheck the Show Confidence bands option.

Tableau Scatter Plot 8

It removes the Tableau confidence bars

Tableau Scatter Plot 9

Remove Scatter Plot Trend Line

Right-click on the Plotting area will open the context menu. Please select the Trend Lines, and uncheck the Show Trend Lines option.

Tableau Scatter Plot 10

Add Colors to Scatter Plot

This example shows how to add colors to the Tableau scatter plot. For this, drag and drop the English Country Region Name from Dimensions Region to Color field in Marks Shelf. It means each country has its own color

Tableau Scatter Plot 11

Add Multiple Trend Lines to a Scatter Plot in Tableau

This example shows how to add the trend line for each region in a scatter plot. Right-click on the Plotting area will open the context menu. Please select the Trend Lines, and click on the Show Trend Lines option.

Tableau Scatter Plot 12

It will create the Tableau Trend Line for each country.

Tableau Scatter Plot 13

Change the Size of a Scatter Plot

Let me show you how to change the size of a dot. For this, drag and drop the English Country Region Name from Dimensions Region to Size field in Marks Shelf, as shown below. It means each country has its own size

Tableau Scatter Plot 14

Change the Scatter Plot Shape of a ring

To change the Tableau scatter plot default ring shape, click on the Shape field in Marks Shelf. It will open the list of available shapes. Please select the shape.

Tableau Scatter Plot 15

As you see, we changed the default ring shape to star

Tableau Scatter Plot 16

Create Category wise Scatter Plot

To create a Tableau scatter plot for each region, drag the English Country Region Name from Dimensions Region to Rows Shelf.

Tableau Scatter Plot 17

Add Labels to a Scatter Plot

This example shows how to add labels to each dot in a Tableau scatter plot. For this, drag and drop the Order Quantity from Measures Region to Label field in Marks Shelf

Tableau Scatter Plot 18

Placed Under: Tableau

  • Download and Install Tableau
  • Tableau Start Page
  • Tableau Show Me
  • Connect to MS Analysis Services
  • Connecting Tableau to SQL
  • Tableau Connect to Text File
  • Tableau Connect to Excel File
  • Hierarchies in Tableau
  • Tableau Bins
  • Tableau Parameters
  • Combined Tableau Sets
  • Tableau Set
  • How to Edit Tableau Group
  • Tableau Group
  • Tableau Grouping
  • Tableau First Report
  • Data Labels in Tableau Reports
  • Format Tableau Chart Title
  • Create Folders in Tableau
  • Tableau Sort
  • Add Totals in Tableau
  • How to Join Data in Tableau
  • Tableau Data Blending
  • Tableau Table Report
  • Tableau Crosstab Report
  • Tableau Annotations
  • Tableau Charts
  • Tableau Area Chart
  • Tableau Bar chart
  • Tableau Box Plot
  • Tableau Bubble Chart
  • Tableau Bullet Graph
  • Tableau Bump Chart
  • Tableau Circle Views
  • Tableau Dual Combination Chart
  • Tableau Dual Lines Chart
  • Tableau Funnel Chart
  • Tableau Traditional Funnel Chart
  • Tableau Gantt Chart
  • Tableau Grouped Bar Chart
  • Tableau Heat Map
  • Tableau Highlight Table
  • Tableau Histogram
  • Tableau Cumulative Histogram
  • Tableau Line Chart
  • Tableau Lollipop Chart
  • Tableau Pareto Chart
  • Tableau Pie Chart
  • Tableau Scatter Plot
  • Tableau Stacked Bar Chart
  • Tableau Text Label
  • Tableau Treemap
  • Tableau Word Cloud
  • Tableau Waterfall Chart
  • Tableau Individual Axis
  • Tableau Dual Axis
  • Tableau Blended Axis
  • Tableau Add Reference Lines
  • Tableau Add Reference Bands
  • Add Reference Distributions
  • Tableau Maps
  • How to Create a Map in Tableau
  • Use Google Maps in Tableau
  • Mapbox Maps as a Background
  • WMS Server Map as Background
  • Create a Tableau Dashboard
  • Format Dashboard Layout
  • Create Dashboard Device Prev
  • Tableau Dashboard Objects
  • Create a Tableau Story
  • Tableau Filters
  • Tableau Filters on Dimensions
  • Tableau Filters on Measures
  • Tableau Extract Filters
  • Tableau Dashboard Filters
  • Tableau Data Source Filters
  • Tableau Slicing Filters
  • Tableau Quick Filters
  • Tableau Context Filters
  • Tableau Top Filters
  • Tableau Table Calculations
  • Tableau Calculated Fields
  • Tableau Running Total
  • Tableau Rank Calculation Basic
  • Tableau Rank advanced calculate
  • Tableau Aggregate Functions
  • Tableau Conversion Functions
  • Tableau Case Function
  • Tableau Date Functions
  • Tableau If Function
  • Tableau Logical Functions
  • Tableau Math Functions
  • Tableau String Functions
  • Tableau Table Functions

Copyright © 2021 · All Rights Reserved by Suresh

About Us | Contact Us | Privacy Policy