How to Make a Column Chart in Tableau

A column chart is one of the first visualizations anyone learns to build, and for good reason - it’s perfect for comparing values across different categories. This guide will walk you through creating, customizing, and mastering the column chart in Tableau, turning a basic skill into a powerful tool for visual data analysis.

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

Understanding the Building Blocks: Dimensions and Measures

Before you drag and drop anything in Tableau, you need to understand the two fundamental types of data it uses: Dimensions and Measures. Getting this right is the foundation for building any chart correctly.

Think of it like telling a story. Dimensions set the scene, and Measures provide the action.

• Dimensions: These are qualitative, categorical fields. They are the "who, what, and where" of your data. Think of things like product names, customer names, regions, or dates. In the Tableau data pane, dimensions are typically shown above the gray line and are color-coded blue when you use them.
• Measures: These are quantitative, numerical fields. They are the things you can count, sum, average, or otherwise calculate. Examples include sales, profit, quantity, and website sessions. Measures are usually below the gray line in the data pane and turn green when used in a view.

When you create a column chart, you're essentially comparing a Measure (like sales) across different categories of a Dimension (like product categories). The Dimension sets up the individual columns, and the Measure determines how tall each column is.

Step-by-Step: Building Your First Column Chart

Let's create a classic "Sales by Category" column chart using the Sample Superstore dataset that comes with Tableau. If you don't have it open, you can connect to it from the start screen by selecting "Microsoft Excel," navigating to your "My Tableau Repository/Datasources" folder, and choosing the Sample Superstore file.

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: Get Your Dimension and Measure Ready

Once your data is loaded, look at the Data pane on the left side of your worksheet. You’ll see your fields organized into Dimensions and Measures.

For this chart, we will use:

• The Category field (a Dimension).
• The Sales field (a Measure).

Step 2: Drag Your Dimension to the Columns Shelf

Click and drag the Category dimension from the Data pane and drop it onto the Columns shelf at the top of the workspace.

You will immediately see column headers appear for "Furniture," "Office Supplies," and "Technology." Tableau knows that since 'Category' is a dimension, it should be used to create distinct labels for our columns.

Step 3: Drag Your Measure to the Rows Shelf

Next, click and drag the Sales measure and drop it onto the Rows shelf. Just like that, Tableau works its magic.

It automatically creates a vertical axis for the Sum of Sales and draws a column for each category, with the height of the column corresponding to the total sales for that category. Congratulations, you've just made a column chart!

Customizing Your Column Chart for Clearer Insights

Building the chart is just the beginning. The real value comes from formatting and adding context to make it easier to understand. Here are a few simple ways to enhance your column chart.

Add Color to Show More Detail

Color is one of the most effective ways to add another layer of information. Let's color our columns by Sub-Category to see which products make up the sales in each main category.

1. Find the Sub-Category dimension in the data pane.
2. Drag Sub-Category and drop it directly on the Color tile in the Marks card.

Your single-color bars will instantly transform into stacked columns, with each color representing a different sub-category. Tableau also automatically creates a color legend on the right. Now, you can easily see that "Phones" and "Chairs" are the biggest contributors within their respective categories.

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

Sort Your Data to Emphasize Performance

By default, Tableau sorts your columns alphabetically. However, it’s often more useful to sort them by value to quickly see which category is performing best or worst.

The quickest way to sort is using the one-click sort icons in the toolbar at the top:

• Click the Descending Sort icon (looks like bars going from tallest to shortest) to arrange the categories from highest sales to lowest.
• Click the Ascending Sort icon to do the opposite.

This simple change immediately draws the eye to Technology as the top-performing category, a detail that wasn't as obvious before.

Show Labels for Exact Values

While the height of the column gives a general idea of its value, sometimes you need to see the exact numbers without forcing your audience to consult the axis. This is where labels come in handy.

1. Find the Sales measure in the Data pane.
2. Drag another instance of Sales and drop it onto the Label tile in the Marks card.

The total sales value will now appear on top of each column. To format these numbers as currency, right-click the SUM(Sales) pill on the Rows shelf, select Format, and in the pane that appears, choose Currency (Custom) and set the decimal places to zero.

Adjusting Fit and View

Sometimes your chart might look a bit squished or have too much empty space. You can easily adjust this using the Fit dropdown in the toolbar (it usually defaults to "Standard").

• Entire View: This makes the chart fit whatever empty space is available.
• Fit Width: This makes the chart use the width of your screen, which can be useful for spreading out columns.
• Fit Height: This is more useful for horizontal bar charts with lots of categories.

For our purpose, either 'Standard' or 'Entire View' works well.

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

Filtering Your Data for a Deeper Look

What if you only want to see sales for a specific year or region? This is where filters come in. Let's filter our view to only show sales from the most recent year.

1. In the Data pane, find the Order Date dimension.
2. Drag Order Date onto the Filters shelf, which is located just above the Marks card.
3. A dialog box will appear asking how you want to filter the date. Select "Years" and click Next.
4. In the next box, check the box for the most recent year in the dataset (e.g., 2023) and click OK.

The entire chart and axes will instantly update to reflect sales from only the selected year. You now have an interactive filter that you can edit anytime.

Column Charts vs. Bar Charts: When to Use Which?

A common question that comes up is the difference between a column chart (vertical bars) and a bar chart (horizontal bars). Functionally, they display the same type of data - comparing categorical values - but there are best practices on when to use each one.

Use Column Charts when:

• Showing Time: Use a time-related dimension like 'Month' or 'Year' to naturally create a flow from left to right, consistent with our intuitive understanding of progression.
• You have just a few categories: Column charts work great when the labels on the x-axis are not cramped. As a rule, up to ten categories are ideal.

Use Bar Charts when:

• Comparing many categories: Horizontal bars are easier to read when you have many data points. If you are comparing many products with longer names, a bar chart will be much more legible as scrolling down feels more natural than scrolling side to side.

To change your column chart to a bar chart in Tableau is incredibly simple.

Final Thoughts

Creating a column chart in Tableau is an essential skill that serves as the foundation for more advanced visualizations. Understanding how to enhance these charts with color, labels, and filters will always help you transform raw numbers into clear insights.

Tableau is a powerful tool, but the setup and learning curve can feel steep if you're just getting started. Whether you're analyzing trends, creating sales pipelines, building forecasting dashboards, or any other data-driven task, understanding and utilizing analytics can help you gain insights with tools like Graphed, bringing the simplicity of a traditional BI platform.