How to Make a Dot Plot in Tableau

Tired of cluttered bar charts? Dot plots are a clean, powerful, and often overlooked alternative for visualizing data across different categories. They offer a simple way to compare values and see distributions without the visual weight of bars. This tutorial will walk you through creating a dot plot in Tableau, from the basics to more advanced techniques like connected dot plots for comparison.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly is a Dot Plot?

A dot plot, at its core, represents data points with dots along a simple scale. Imagine a bar chart, but instead of a full bar extending from the axis, there’s just a single dot at the endpoint. This minimalistic approach makes it incredibly effective for several reasons:

• Clarity and Precision: By reducing visual clutter, dot plots make it easier for viewers to see the precise value for each category and quickly compare them.
• Space Efficiency: They are great for displaying many categories at once without overwhelming the dashboard.
• Shows Distribution: When dots cluster in certain areas, it instantly reveals the distribution and density of your data points.

It's an excellent choice when you want to compare numerical values across categorical data, like viewing sales by product category, profit by region, or employee performance scores across different departments.

Preparing Your Data for a Dot Plot

Before you jump into Tableau, a quick check of your data structure will save you time. To build a standard dot plot, all you need is:

• A Categorical Dimension: This is the qualitative data you want to compare. Think of things like Product Name, Customer Segment, Sales Region, or Marketing Channel.
• A Continuous Measure: This is the quantitative value you want to plot for each category. Examples include Sales, Profit, Number of Clicks, or Customer Satisfaction Score.

Tableau’s Superstore sample dataset is perfect for practicing this. We'll use it to visualize Sales (our measure) for each Sub-Category (our dimension).

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step: Creating a Basic Dot Plot in Tableau

Let's build a simple dot plot from scratch. Once you connect to your data source (like the aforementioned Superstore dataset), these steps will take you from a blank canvas to a finished chart in minutes.

1. Set Up Your Rows and Columns

First, you need to tell Tableau what you're measuring and which categories to show.

• Drag your categorical dimension, such as Sub-Category, onto the Rows shelf. You'll see a list of all your sub-categories appear.
• Next, drag your continuous measure, like Sales, onto the Columns shelf.

Right away, Tableau will likely default to showing you a horizontal bar chart. This is the foundation from which we'll build our dot plot.

(Your view in Tableau should now look like a standard bar chart with Sub-Category on the Rows shelf and SUM(Sales) on the Columns shelf.)

2. Change the Mark Type to 'Circle'

This is the simple but essential step that transforms your bar chart into a dot plot.

• Navigate to the Marks card, which is typically located to the left of your visualization worksheet.
• Click the dropdown menu that currently says Automatic (or Bar).
• From the list of options, select Circle.

The bars will disappear, and each one will be replaced by a dot aligned with its value on the axis. You've just created a basic dot plot!

3. Adjust the Size and Opacity

The default dots might look a bit small. You can easily adjust their size for better visual impact.

• On the Marks card, click on the Size button.
• A slider will appear. Drag it to the right to increase the size of the dots until they look substantial but not overlapping. A little less than halfway is often a good starting point.
• You can also click on the Color button and adjust the Opacity slider. Lowering it slightly to around 80-90% can look nice if dots overlap.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

4. Sort for Better Readability

A dot plot is most effective when it’s easy to compare values. Sorting your categories from highest to lowest (or lowest to highest) value makes this much easier.

• Hover your cursor over the SUM(Sales) axis label. A small sort icon will appear.
• Click the descending sort icon to arrange your Sub-Category dots from the highest sales to the lowest.

Now, it's immediately clear which sub-categories are your top performers and which are at the bottom, just by glancing down the sorted list.

Advanced Technique: The Connected Dot Plot (Dumbbell Plot)

A dot plot truly shines when you use a variation called a "connected dot plot" or "dumbbell plot." This chart type is fantastic for comparing two data points for each category - for example, comparing sales in 2022 to sales in 2023, comparing budget vs. actuals, or a goal vs. current performance.

Let's build a dumbbell plot to compare Sales and Profit by Sub-Category.

1. Set Up the Initial Pills

• Start with a clean sheet. Place your dimension, Sub-Category, on the Rows shelf.
• Now, drag your first measure, Sales, to the Columns shelf.
• Drag your second measure, Profit, from the data pane and drop it directly onto the existing X-axis in your visualization. When you do this, a "Show Me" double ruler icon should appear. Release your mouse button when you see it.

Tableau will automatically create the structure you need: Measure Names is placed on the Filters shelf and Measure Values is on the Columns shelf. On your screen, you should now see two side-by-side bar charts for each sub-category.

2. Create the Dumbbell Chart Lines

• In the Marks card, change the mark type dropdown from Bar to Line. You'll now see jagged lines connecting Sales to Profit, which isn’t quite right yet.
• From the data pane, drag Measure Names onto the Path button in the Marks card. This tells Tableau to draw a separate line for each sub-category, connecting the Sales point to the Profit point. Now you have the lines for your dumbbell chart.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

3. Add the Dots with a Dual Axis

The lines are there, but a dumbbell plot needs the dots on each end. We'll use a dual-axis chart to overlay the dots.

• Hold down Ctrl (or Cmd on Mac) and drag the green Measure Values pill from your Columns shelf right next to itself. This duplicates the pill.
• You now have two identical line charts. In your Columns shelf, right-click the second Measure Values pill and select Dual Axis.
• Right-click the top axis in your visualization and select Synchronize Axis. This is crucial for ensuring both measures are on the same scale.

4. Finalize the Mark Types

Now, look at your Marks card. You should see three tabs at the top: All, AVG(Measure Values), and AVG(Measure Values) (2).

• Click on the first Measure Values tab in the Marks card (the one for your original chart). Confirm it's a Line type. You can adjust the line thickness here with the Size slider.
• Now, click on the second Measure Values (2) tab in the Marks card.
• Change its mark type to Circle. Use the Size slider to make the circles larger and more prominent than the connecting line.
• To make it clear which dot is which, drag Measure Names to the Color button on this same Marks card tab. Now your "Sales" and "Profit" dots will have distinct colors.

And there you have it! A completed dumbbell plot that clearly shows both the Sales and Profit for each Sub-Category and the gap between them.

Final Thoughts

Mastering dot plots in Tableau opens up a powerful and elegant way to present comparative data cleanly. You now know how to build a basic plot for single values and how to create a more advanced connected dot plot to compare two measures for each category. It’s a versatile chart that deserves a spot in any data analyst’s toolkit.

Getting comfortable with powerful BI tools like Tableau is a fantastic way to gain deep control over your data visualization. For marketing and sales teams who need answers in seconds, not hours, we built Graphed to streamline the entire process. We automated the data connections and manual chart building so you can simply ask questions in plain English - like "create a chart comparing Facebook Ads spend vs revenue by campaign this month" - and get a live dashboard built instantly.