How to Make a Graph in Tableau

Building a graph in Tableau for the first time might seem intimidating, but its drag-and-drop interface makes the process surprisingly intuitive. This guide will walk you through creating your first visualizations, from connecting your data to customizing your charts. We’ll cover how to build a simple bar chart and a line chart, giving you a solid foundation for telling stories with your data.

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

Before You Begin: Understanding the Tableau Workspace

Opening Tableau reveals a workspace that can be broken down into a few key areas. Getting familiar with them is the first step toward building great visualizations.

The Data Pane

On the left side of the screen is the Data Pane. After you connect your data, this is where Tableau lists all the available fields from your dataset. It automatically sorts them into two categories:

• Dimensions: These are categorical fields. Think of them as the "what," "who," or "where" in your data. Examples include Product Category, Customer Name, or Region. Dimensions are typically used to slice and dice your data. They are usually blue.
• Measures: These are numerical fields you can perform mathematical calculations on. Think of them as the "how much" or "how many." Examples include Sales, Profit, Quantity, or Page Views. Measures are the numbers you want to analyze. They are usually green.

This distinction between Dimensions and Measures is fundamental to how Tableau works. Visualizations are created by seeing how a Measure changes across different Dimensions.

The Shelves (Columns and Rows)

At the top of the workspace, you’ll see the Columns and Rows shelves. This is where the magic happens. You build charts by dragging fields from the Data Pane onto these shelves.

• Fields placed on the Columns shelf create columns in your table or along the x-axis of your chart.
• Fields placed on the Rows shelf create rows in your table or along the y-axis of your chart.

The Marks Card

To the left of your blank canvas is the Marks Card. This powerful tool allows you to control the visual properties of your graph - the "marks" that represent your data points. You can change the graph type (bar, line, pie, etc.) here or drag fields onto properties like:

• Color: Change the color of your marks based on the values of a field.
• Size: Adjust the size of marks based on a field's values.
• Label: Display values as text labels on your marks.
• Detail: Break down the view further without adding color or size.
• Tooltip: Customize the information that appears when you hover over a data point.

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 1: Connecting to Your Data

You can't build a graph without data. Tableau can connect to hundreds of different data sources, from simple spreadsheets to complex cloud databases. For this walkthrough, let's use a common data source: a Microsoft Excel file.

When you first open Tableau, you'll be greeted with the Connect pane.

1. Under the "To a File" section, click on Microsoft Excel.
2. Navigate to your saved Excel file and click Open. For this example, let's imagine we have a simple sales report with columns like Order Date, Region, Category, Product Name, Sales, and Profit.
3. Tableau will now show you the sheets available in your workbook. Drag the sheet containing your sales data into the canvas area.

Tableau will display a preview of your data. Once you're happy with it, click the Sheet 1 tab at the bottom of the screen to go to your worksheet and start building.

Step 2: Building Your First Bar Chart

A bar chart is a perfect starting point. It’s ideal for comparing total amounts across different categories. Let's create a chart to compare total sales across each product category.

1. Add a Dimension to Columns

In the Data Pane on the left, find your Category field under Dimensions. Click and drag it onto the Columns shelf. You'll see column headers appear for each of your product categories (e.g., Furniture, Office Supplies, Technology).

2. Add a Measure to Rows

Now, find your Sales field under Measures. Click and drag it onto the Rows shelf. Instantly, Tableau generates a vertical bar chart. It automatically aggregates the Sales (summing them up by default) for each Category and displays the result.

And just like that, you've made your first graph! You can now clearly see which product category generates the most revenue.

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 3: Enhancing Your Graph with Detail

That basic bar chart is useful, but we can make it more insightful with just a few more drags and drops using the Marks Card.

1. Adding Color for More Context

What if you wanted to see how sales in each category break down by region? Find the Region dimension in your Data Pane. Instead of putting it on Rows or Columns, drag Region directly onto the Color property in the Marks Card.

Tableau instantly changes the chart. Each bar is now a stacked bar, segmented by color, with each color representing a different region. A legend is automatically created to the right, showing which color corresponds to which region. Now you can see not only which category is best, but also which regions contribute most to each category's sales.

2. Adding Labels for Clarity

If you want to see the exact sales figures on the chart without hovering, you can add labels. Drag the Sales measure from the Data Pane onto the Label property in the Marks Card. The sum of sales will now appear on top of each corresponding bar or colored segment.

This adds granular detail, making your graph easier to read at a glance.

Step 4: Creating a Line Chart to See Trends

Bar charts are great for comparing categories, but what if you want to see how your sales are performing over time? For that, a line chart is the perfect choice.

Let's create a new graph. Click the New Worksheet icon at the bottom of Tableau (it looks like a small grid with a plus sign).

1. Drag Your Date Field to Columns

In your new worksheet, find your Order Date dimension. Drag it onto the Columns shelf. By default, Tableau rolls the date up to the YEAR level.

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

2. Drag Your Measure to Rows

Just like before, drag the Sales measure onto the Rows shelf. Tableau will create a line chart connecting data points for the total sales in each year.

3. Drilling Down into Time

One of Tableau’s best features is its handling of dates. Notice the little + sign on the YEAR(Order Date) pill in the Columns shelf. Click it. The view expands to show QUARTER. Click it again, and it expands to MONTH.

This allows you to easily "drill down" to a more granular level of detail. You can use the - sign to roll it back up. You can also right-click the date pill to select specific date parts (e.g., Weekday, Week Number) or continuous date values for a smoother line.

Tips for an Effective First Graph

As you start building, keep these simple tips in mind:

• Keep It Clean: Don’t try to answer every question with one graph. A single chart should convey a clear, focused message. Too many colors, labels, and dimensions can make it confusing.
• Titles Tell the Story: Always give your chart a descriptive title. Double-click the default "Sheet 2" title and change it to something like "Monthly Sales Trend." Your future self and your colleagues will thank you.
• Use Tooltips Wisely: Hovering over a data point reveals a tooltip. You can customize this by clicking on the Tooltip property in the Marks Card. Add extra information here, like Profit or Quantity, to provide context without cluttering the main view.
• Choose the Right Chart: Start with the basics. Bar charts are for comparing totals, and line charts are for tracking trends over time. As you get more comfortable, you can explore other chart types from the "Show Me" menu in the top-right corner.

Final Thoughts

Making a graph in Tableau comes down to understanding the two main components of your data: Dimensions and Measures. By dragging these fields onto the Rows, Columns, and Marks card, you can visualize the relationships between them and uncover the stories hidden in your spreadsheet.

While learning tools like Tableau is an incredibly powerful skill, the reality is that sometimes you need business answers without the multi-step setup. That’s why we built Graphed. Instead of dragging and dropping, you can simply ask a question like, "Show me a line chart of my Shopify sales by month for the last year," and our AI data analyst builds an interactive, real-time dashboard for you instantly. It's designed to give you insights in seconds, not hours.