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 Bubble Chart

by suresh

Tableau Bubble Chart is used to display the data in circles. We can define each bubble using any of our Dimension members and size by Measure value. 

Bubble charts in Tableau play a significant role while creating Maps. For instance, we can use bubbles on top of the Map to display the Sales by Postal code, etc. In this article, we will show how to Create a Tableau Bubble Chart using Custom SQL Query. So, visit Connecting Tableau to SQL Server article.

SELECT Geo.EnglishCountryRegionName, 
       Geo.StateProvinceName, 
       Geo.City, 
       Prod.EnglishProductName, 
       Prod.Color, 
       Fact.OrderQuantity, 
       Fact.TotalProductCost, 
       Fact.SalesAmount, 
       Fact.TaxAmt, 
       Fact.[Freight]
FROM DimProduct AS Prod 
   INNER JOIN FactInternetSales AS Fact 
      ON Prod.ProductKey = Fact.ProductKey 
   INNER JOIN DimSalesTerritory AS Terry 
      ON Terry.[SalesTerritoryKey] = Fact.[SalesTerritoryKey] 
   INNER JOIN DimGeography AS Geo 
      ON Geo.[SalesTerritoryKey] = Terry.[SalesTerritoryKey]

First Approach to Create Tableau Bubble Chart

In this example, we are going to create a Bubble Chart for State dimension against the Sales Amount size. First, Drag and Drop the State Dimension from Dimension Region to Text Field in Marks Shelf

Tableau Bubble Chart 0

From the below screenshot you can see the available State names in Tableau report

Tableau Bubble Chart 21

Next, Drag and Drop the Sales Amount from Measures Region to Size Field in Marks Shelf.

Tableau Bubble Chart 22

Once you drag them, the following screenshot will be displayed. By default, Tableau Desktop is displaying Tree Map

Tableau Bubble Chart 24

To change the Default TreeMap to Bubble Chart in Tableau, we have to change the default Automatic option in the Marks Shelf. Please expand the drop-down list and change the Automatic to Circle.

Tableau Bubble Chart 1

Once you changed, Bubble Chart will be displayed with State Name as Text filed and Sum of Sales Amount as the Bubble size. From the below screenshot, you can see that the Bubble Size of a California State is bigger than the remaining states because the Sales Amount is higher than other states.

Tableau Bubble Chart 2

Let us add the Sales Amount to the Text field as well. By this, we can see the State name along with the Sales Amount. To do this, Please drag the Sales Amount from Measures region to Text field present in Marks Shelf

Tableau Bubble Chart 3

Let us add color to our Tableau Bubble Chart. We can do it by dragging the Calculated field Profit to the Colors field in Marks Shelf.

Tableau Bubble Chart 4

Once you have done, the following screenshot will be displayed. The State name Bubble with Maximum Sales fills with Dark Green and Least Sales Amount with light green

Tableau Bubble Chart 5

Sort Tableau Bubble Chart

A bubble chart also allows us to sort the bubbles. So please click on the Sort by descending order button present in Tableau toolbar

Tableau Bubble Chart 6

From the below screenshot, you can see that our Bubble Chart is formatted in the descending order

Tableau Bubble Chart 7

Format Text in Bubble Chart

To format the Tableau bubble chart Data Labels, Please click on the Text field inside the Marks Shelf. After you click on it, the following window will be displayed. For now, we are doing basic formatting so, click on the … the button beside the text

Tableau Bubble Chart 8

Here, we added extra text Sales, Profit beside the < SUM(SalesAmount) > and < SUM(Profit) > and also changed the font style to Lucida Sans

Tableau Bubble Chart 9

See the Formatted Text inside our Tableau bubble chart

Tableau Bubble Chart 10

Second Approach to Create Bubble Chart

This method of creating a Tableau Bubble chart is very easy and straightforward. Please press and hold the control key and then select the Dimension (s), Measure(s) from the respective region and select the Bubble Chart from the Show Me window

Tableau Bubble Chart 11

Once you did, the desktop will create a bubble chart in Tableau.

Tableau Bubble Chart 12

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