How to Make a Time Series Graph in Tableau

Watching your data change over time is one of the most powerful ways to understand your business performance. A time series graph is the perfect tool for this, turning rows of dates and numbers into a clear visual story. This article will guide you, step-by-step, through creating and customizing insightful time series graphs in Tableau.

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 Time Series Graph?

A time series graph (or chart) plots data points in chronological order. Usually, it's a line chart that shows a continuous sequence of data over a specific period. The horizontal axis (x-axis) always represents time, from months and years to days and minutes, while the vertical axis (y-axis) represents the value you’re measuring.

Why are they so useful? Because they help you answer critical business questions at a glance:

• Identifying Trends: Are your website sessions consistently growing month-over-month? Is customer churn slowly creeping up? A time series graph makes the overall direction of your metrics immediately obvious.
• Spotting Seasonality: Do your sales always spike in the fourth quarter? Does your web traffic dip every weekend? This visual format reveals regular, predictable patterns tied to the calendar.
• Detecting Anomalies: What caused that sudden, sharp drop in revenue last Tuesday? Why was there a massive spike in sign-ups on the first of the month? A time series graph highlights outliers and unexpected events, prompting you to investigate the "why" behind them.

Whether you're tracking monthly marketing qualified leads (MQLs) from HubSpot, daily sales from Shopify, or weekly user engagement from Google Analytics, a time series graph turns a stagnant spreadsheet into a dynamic narrative about your business's journey.

Preparing Your Data for Tableau

Before you jump into Tableau, a quick check of your data source will save you a lot of trouble. For a time series graph, your data needs just two essential components:

1. A time dimension: This is a column in your data that contains date or datetime information (e.g., 10/25/2023, 2023-10-25, or 2023-10-25 09:30:00).
2. A numeric measure: This is the column with the numbers you want to plot over time, like Sales, Revenue, Users, or Clicks.

The good news is that Tableau is incredibly smart at recognizing date fields. As long as your dates are in a standard format within a single column, Tableau will usually categorize the field as a date automatically when you connect to it. Just make sure the column is clean and consistent, without extra text or mixed data types.

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: Building a Time Series Graph in Tableau

Let's build a classic time series graph. For this example, we’ll imagine we have a simple dataset containing Order Date and Sales.

Step 1: Connect to Your Data Source

Open Tableau Desktop or Tableau Public. On the "Connect" pane on the left, choose the file type or server that holds your data (e.g., Microsoft Excel, Google Sheets, etc.). Select your file and Tableau will load it, displaying the columns in the Data Source tab.

Step 2: Drag Your Date Field to the Columns Shelf

Once your data is loaded, go to a new worksheet. You'll see your data fields listed in the "Data" pane on the left. Find your date field - in our case, Order Date - and drag it onto the Columns shelf at the top of the workspace.

Tableau will automatically aggregate the dates, likely showing up as a blue pill that says YEAR(Order Date). Blue pills in Tableau represent discrete data, meaning they are treated as separate, individual items (e.g., the years 2021, 2022, 2023). For a continuous line chart, we want a green pill.

Step 3: Change the Date to Continuous

To create a smooth, continuous timeline, right-click the blue YEAR(Order Date) pill on the Columns shelf. In the dropdown menu, you'll see a section of date options. The top section shows discrete date parts (blue icon), while the second section shows continuous date values (green icon). Select Month from the second section (the first instance of 'Month' usually shows May 2021, May 2022, etc., while the continuous one shows a timeline).

Your pill will turn green, and you'll see a continuous axis of time instead of distinct year labels.

Pro Tip: You can also right-click and drag the date field to Columns to begin with. When you drop it, a menu will pop up allowing you to choose the continuous month format right away.

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

Step 4: Drag Your Measure to the Rows Shelf

Now, find the metric you want to measure over time - in our example, Sales. Drag this field from the Data pane and drop it onto the Rows shelf.

And just like that, Tableau generates a line chart! You now have a time series graph showing your sales performance over a continuous timeline.

Customizing Your Time Series Graph for Deeper Insights

Creating the basic chart is just the beginning. Tableau’s real power lies in how easily you can manipulate and customize your visualization to uncover more specific stories.

Easily Change the Date Granularity

Is your monthly view too broad? Do you want to zoom out to see the quarterly trend? This is incredibly easy to do.

Simply right-click the green date pill on your Columns shelf again. You can switch the granularity to Quarter, Week, or even Day with a single click. The chart will instantly update, re-drawing your time series to the new level of detail. You can flip between these views in seconds to analyze your data from different perspectives.

Comparing Multiple Categories with Color

A single line showing total sales is great, but what if you want to compare how different product categories performed over the same period?

Let's say you have a Category field. To see a separate trend line for each category:

1. Find your Category dimension in the Data pane.
2. Drag it directly onto the Color tile in the Marks Card.

Tableau will automatically break your single line into multiple, color-coded lines - one for each product category (e.g., Furniture, Office Supplies, Technology). A legend is also created, so you can easily see which line corresponds to which category. This is an incredibly effective way to spot which product lines are driving growth or falling behind.

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

Adding a Filter for a Specific Date Range

Often, you don’t want to see your entire data history. You might only be interested in the performance of the last year or a specific quarter.

To filter your chart by date:

1. Drag your Order Date from the Data pane onto the Filters card.
2. A "Filter Field" pop-up will appear. You can choose a "Relative date" (e.g., last 12 months, this year), a "Range of dates" where you can set a specific start and end, or other options.
3. Select what you need, click OK, and your chart will update to show only the selected time range.

Add a Trend Line with a Single Drag

What’s the overall direction of your sales? Is the trend positive, negative, or flat? You don't have to guess.

Near the Data pane, you'll see an Analytics tab. Click on it. Inside, you’ll find several models you can add to your visualization.

Simply find Trend Line, click and hold, and drag it onto your chart. A pop-up will ask you to choose a model type (Linear is usually a good start). Drop it on, and Tableau will instantly overlay a trend line on your data, giving you a clear statistical view of the trajectory of your sales.

Final Thoughts

You now have the skills to build a powerful and dynamic time series graph in Tableau, a fundamental tool for any data-driven professional. Moving from raw numbers to visual analysis helps you understand the story of your business over time, spotting the patterns and trends that drive better decisions.

While mastering tools like Tableau is invaluable, the weekly routine of manually refreshing reports can still consume hours. We built Graphed to short-circuit that process entirely. Instead of dragging and dropping fields, we let you simply connect your marketing and sales platforms, then ask for what you need in plain English. You can create the same time series chart by asking: "Create a dashboard showing a line chart of Shopify sales by month for the last two years," and get a live, automated dashboard in seconds, not hours.