How to Make a Circle Chart in Tableau with AI

Building a circle chart in Tableau is a fantastic way to compare data across different categories without the clutter of a bar chart. Instead of just seeing bars of varying lengths, you get a visual that can show relationships between multiple data points at once using size, color, and position. This article will show you how to create compelling circle charts in Tableau, covering both the traditional drag-and-drop method and how you can use Tableau's AI features to get there even faster.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What Are Circle Charts and When Should You Use Them?

A circle chart, also known as a circle view or a bubble plot, represents data points as circles. It's a close cousin of the scatter plot but adds another dimension by allowing the size and color of each circle to represent additional variables. This makes them incredibly efficient at displaying several layers of information in a single view.

So, when is a circle chart the right choice? They shine in a few specific scenarios:

• Comparing many categories: When you have more categories than can comfortably fit in a bar chart (think 15+ sub-categories), circle charts provide a much cleaner way to compare them at a glance.
• Visualizing three or more variables: The core strength of a circle chart is its ability to encode multiple measures. You could plot Sales (Y-axis) and Profit (X-axis) like a scatter plot, and then use circle size to represent Quantity and color to represent Region.
• Identifying clusters and outliers: By plotting two measures against each other, you can easily spot outliers - like a product with high sales but extremely low profit - or clusters of similar-performing items.

Just remember, a circle chart is not a pie chart. Pie charts are designed to show how parts contribute to a whole, while circle charts excel at comparing distinct categories or items across multiple measures.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

The Traditional Way: Building a Circle Chart Manually

Before diving into Tableau's AI tools, it’s helpful to understand the foundational process of building a circle chart manually. Knowing these steps helps you understand what the AI is automating, giving you the power to fine-tune its outputs later. We'll use the "Sample - Superstore" dataset that comes with Tableau for this example.

Step 1: Get Your Data Ready

First, open Tableau and connect to your data source. In the "Saved Data Sources" section on the launch screen, select Sample - Superstore to load the dataset.

Step 2: Start with a Basic View

Once your data is loaded and you're in a new worksheet, let's create the basic structure for the chart. The goal is to compare product Sub-Categories by their Sales.

1. Drag the Sub-Category dimension from the Data pane onto the Columns shelf.
2. Drag the Sales measure onto the Rows shelf.

Tableau will automatically create a bar chart. This is our starting point.

Step 3: Change the Mark Type to 'Circle'

Now, let's switch from bars to circles. This is a simple but transformative step.

Find the Marks card (it's typically between the Rows shelf and the view itself). You'll see a dropdown menu that currently says "Automatic" or "Bar". Click on it and select Circle from the list.

Your bars will instantly transform into circles, with one circle at the top of where each bar used to be. You officially have a circle chart, though a very basic one.

Step 4: Use Size and Color to Add More Information

This is where the magic happens. We can now encode more data into each circle. Let's make the size of each circle represent the corresponding profit, and the color represent the product category.

1. Drag the Profit measure from the Data pane and drop it onto the Size property on the Marks card. Instantly, you’ll see the size of the circles change. Bigger circles now represent higher profit. Notice how "Bookcases" has decent sales, but its small circle shows it's not very profitable.
2. Drag the Category dimension from the Data pane and drop it onto the Color property on the Marks card. Now each circle is colored based on its parent category, helping you spot trends across product groups.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 5: Refine and Polish Your Chart

A good visualization is easy to read. Let's clean this one up a bit.

• Adjust Sizes: The size differences might be too extreme or too subtle. Click on the Size property on the Marks card and use the slider to adjust the overall size of the circles to your liking.
• Sort for Clarity: To make it easier to compare, click the sort icon on the Sales axis or right-click the "Sub-Category" pill on the Columns shelf and select a sort order. Sorting by Sales, descending, is a good start.
• Add Labels: What does each circle represent? Drag the Sub-Category dimension and the Sales measure to the Label property on the Marks card. This will display their names and values directly on the chart.
• Customize the Tooltip: Hover over any circle. The tooltip provides details on demand. You can customize what it shows by clicking on the Tooltip property. You could add "Profit" and "Discount" data to give your audience context when they explore the chart.

The Faster Way: Using Tableau's AI Features

While the manual process offers maximum control, Tableau's built-in AI tools, "Show Me" and "Ask Data," can drastically speed up the creation process. They act as your analytics assistant, helping you get to a great starting point in just a few clicks.

Method 1: Let "Show Me" Do the Heavy Lifting

"Show Me" is Tableau's oldest AI feature. It acts as a recommendation engine that suggests appropriate chart types based on the data fields you select.

Here’s how to use it to create our circle chart:

1. Start with a fresh worksheet.
2. In the Data pane, hold down the Ctrl key (or Cmd on a Mac) and click to select the fields you want to visualize. For our example, select Sub-Category, Sales, and Profit.
3. Go to the top-right corner of the Tableau window and click on the Show Me button to expand the panel.
4. "Show Me" will highlight the chart types it recommends for your selected data. Look for the "packed bubbles" chart or "scatter plot". Clicking on "packed bubbles" creates a classic bubble chart.
5. After clicking a chart type, Tableau automatically arranges the pills on the Columns, Rows, and Marks shelves to build the view. You can then add more fields (like dragging Category to Color) or tweak the chart just as you would with the manual method.

"Show Me" is perfect when you know what data you want to see but aren't sure of the best way to visualize it. It presents you with valid options automatically, avoiding the trial-and-error of dragging pills around manually.

Method 2: Converse with Your Data Using "Ask Data"

"Ask Data" takes AI a step further by introducing natural language processing (NLP). Instead of clicking and dragging, you can simply type what you want to see in plain English, and Tableau will generate a visualization for you.

Here’s how to build a circle chart with "Ask Data":

1. From your dashboard or data source page, look for the Ask Data feature. When a new workbook is open from a published data source, an "Ask data" button appears next to that data source in the Data pane. Or open your data source in Tableau Server/Cloud and launch the Ask Data interface from there.
2. In the search box, type a request. The phrasing can be conversational. Start with something simple like: Sales by Sub-Category. Tableau will likely generate a bar chart.
3. Let's refine it. Now, try typing: Sales and Profit by Sub-Category as a bubble chart.
4. "Ask Data" interprets your request and automatically builds a visualization. You can continue to refine it with more questions or simply save the generated view as a new worksheet to fine-tune it with the standard Tableau interface.

The beauty of "Ask Data" is its speed and accessibility. It allows anyone on your team, regardless of their Tableau skill level, to ask questions and get visual answers from your data instantly. It serves as an excellent starting point for more complex and customized dashboards.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Tips for Creating Effective Circle Charts

No matter how you build it, a great chart is one that communicates insights clearly and accurately. Here are a few tips to make your circle charts as effective as possible.

• Avoid Overcrowding: If you have hundreds of circles on your chart, it can become an unreadable mess, often referred to as hairball charts. Use Tableau's filter functionality to narrow the scope. For example, you could add a filter for "Category" to allow users to focus on one department at a time.
• Use Color and Size Meaningfully: Don’t add visual encodings just for decoration. Every attribute should tell a story. Use color to group related items (like categories) and size to represent magnitude (like profit or sales volume). Use diverging color palettes (e.g., orange-blue) for metrics like profit that can be positive or negative.
• Prioritize Smart Labeling: Labeling every single circle will quickly clutter your chart. Instead, label only the most important points - like the top 5 performers or significant outliers. For everything else, leverage the tooltip. A well-designed tooltip can provide rich detail on hover without overwhelming the main view.
• Always Provide Context: A chart without a title, labels, and legends is just a collection of shapes. Make sure your viz includes a descriptive title (e.g., "Sales & Profit Performance by Sub-Category"), clear axis labels if applicable, and visible legends for color and size so your audience knows exactly what they’re looking at.

Final Thoughts

Circle charts are an incredibly powerful tool in your data visualization toolkit, capable of displaying complex relationships between multiple variables in a simple, intuitive format. Whether you prefer the granular control of building them manually or the lightning-fast assistance of AI tools like "Show Me" and "Ask Data," you can create insightful visualizations that drive better decisions in Tableau.

Ultimately, building reports should be about getting to the "why" in your data, not getting stuck on the "how" of building the chart. While Tableau's AI has made great strides, we wanted to remove even more friction from the process. That's why we built Graphed, where we turn the entire report-building sequence into a simple, natural language conversation. Just ask "Show me sales versus profit for each sub-category as a bubble chart," and our AI analyst creates a real-time, shareable dashboard for you in seconds - no clicking, dragging, or configuring required.