Tableau Circle Timeline Chart (Complete Guide with Examples)

In data visualization, showing trends over time is very important. Many people use line charts to display time-based data, but they may not be sufficient to clearly show multiple values.

This is where the Tableau Circle Timeline Chart becomes very useful. It helps us visualize data as circles, with time on one axis and multiple measures, such as sales and profit, represented by size and color.

When I was analyzing our retail sales data in Tableau, I wanted to see product sales and the profits they generated over the last five years. I tried using a line chart for this data visualization, but it only showed trends, not the relationship between sales and profit.

Then, I used the Tableau Circle timeline chart to show sales and profit data over five years. By plotting categories such as Furniture, Office Supplies, and Technology over time, I could show profit or loss.

Using the circle timeline chart, it was easy to spot which product lines were profitable, which ones were not, and how performance varied over the years.

In this tutorial, I will explain the Tableau Circle Timeline chart. Then, we will see how we can use it to compare data on measures like Sales and Profit over time.

Table of Contents

What is a Circle Timeline Chart in Tableau?

In Tableau, the Circle Timeline chart displays time-related data points as circles, with position indicating time, size representing a measure like sales, and color indicating another measure like profit or loss.

A Circle Timeline Chart in Tableau is a type of data visualization that displays data points over time using circles. Each circle represents a data point, and its properties show different values.

Position (X-axis): Represents time (like year or month)
Size of circle: Represents one measure (like Sales)
Color of circle: Represents another measure (like Profit or Loss)

This type of chart is very useful for comparing multiple values over time in a single view. Instead of using multiple charts, you can combine everything into one visualization.

For example, you can show:

Sales over time
Profit over time
Category performance

All in one chart.

According to visualization concepts, circle-based charts can represent multiple dimensions at once using size and color, making them more informative than simple charts

It is useful for showing multiple metrics together on a timeline. With the Tableau Circle Timeline chart, we can easily spot patterns and trends in measures such as Sales and profit.

Why Use Circle Timeline Chart?

Many beginners ask, “Why not use a line chart?”

The answer is simple. A line chart shows only trends, but a Circle Timeline Chart shows:

Trends
Comparisons
Relationships between multiple measures

For example:

A line chart shows sales growth
A circle timeline shows sales + profit together

This helps in better decision-making.

When Should You Use This Chart?

Use the Circle Timeline Chart when:

You have time-based data
You want to show multiple measures together
You need a comparison across categories
You want better visualization than line charts

Avoid using it when:

Too many categories (chart becomes messy)
Data is too simple (use a bar chart instead)

Create Circle Timeline Chart in Tableau

In this example, we will create a Tableau timeline chart to show the Sales and Profit for the Product Categories, which are Furniture, Office Supplies, and Technology.

For the data, we will use the Tableau superstore dataset. Connect Tableau to the data source, then follow the steps below to create a Circle Timeline chart.

For the year timeline, add the Order date to the Columns. By default, it will be in year format; to change, click the dropdown and select Month (continuous).

On the Rows shelf, add the average function with 0 as the argument: AVG(0). After this, drag the measure Sales to the Size card in the Marks section.

In the Marks section, select Circle chart. With this, we will see the circle on the average line for Sales data.

To remove the AVG(0) header from the axis, right-click on the axis and uncheck Show header. To remove it from the details, click on the AVG(0) in the rows and uncheck Include in tooltip.

To increase the circle’s size, click the Size card in the marks section and adjust the slider to make it bigger.

To change the circle’s color, click the color card. From here, we can change the circle color, increase opacity, and add a border to the circles.

Add another measure of profit to the chart. For this, we will add the Profit to the Color card to show profits with respect to Sales. Here, darker shades indicate higher profits, while lighter shades indicate lower profits or losses.

Compare Sales using tableau Timeline Chart

To show the Sales and Profit for the product categories, drag the Categories to the Rows. Now, we can see the monthly Sales and Profit of the product categories over five years.

This way, we can create a Circle timeline chart in Tableau to show measures such as Sales and Profit over time.

Circle Timeline vs Line Chart in Tableau

Feature	Circle Timeline	Line Chart
Shows trends	Yes	Yes
Shows multiple measures	Yes	Limited
Visual appeal	High	Medium
Best for comparison	Yes	Limited

Frequently Asked Questions

Q1: What is a Circle Timeline Chart?

It is a chart that shows data over time using circles.

Q2: When should I use it?

When you want to compare multiple values over time.

Q3: Can beginners use it?

Yes, it is easy to create in Tableau.

Conclusion

The Tableau Circle Timeline Chart is a powerful visualization tool that helps in analyzing time-based data using multiple measures. It is better than traditional charts when you need deeper insights and comparisons.

By using circle size and color, you can easily understand trends, patterns, and relationships in your data. With proper formatting and best practices, this chart can make your dashboards more interactive and professional.

By following the above steps, you can easily create a Tableau Circle timeline chart to show data for time-based analysis, like sales and profit, in a single Tableau chart.