How to Make a Vertical Bar Chart in Tableau

Creating a vertical bar chart in Tableau is one of the most fundamental skills you'll master. Bar charts are workhorses for a reason - they make it incredibly simple to compare values across different categories. This guide will walk you through every step, from connecting your data to customizing your chart with colors, labels, and sorting.

Before You Build: Connecting Your Data

You can't build a chart without data. Tableau can connect to almost anything, from a simple Excel file on your desktop to a complex cloud database. For this tutorial, we'll assume you're using a common data source like a spreadsheet.

When you first connect your data, Tableau displays it in the "Data Source" tab. The most important thing to notice is on the left-hand side in the "Sheet" view, where Tableau has automatically categorized your data columns into "Dimensions" and "Measures."

• Dimensions: These are your qualitative, categorical data. Think of them as the "what" or "who" you are measuring. Examples include things like Product Category, Country, Customer Name, or a date like Order Date. They are typically shown in blue.
• Measures: These are your quantitative, numerical data. They are the numbers you want to analyze or aggregate (like summing or averaging). Examples include Sales, Profit, Quantity, or Website Sessions. They are typically shown in green.

Understanding this distinction is the foundation of building virtually anything in Tableau. A bar chart works by showing a Measure (the height of the bars) for each item in a Dimension (the labels below the bars).

Creating Your First Vertical Bar Chart: Step-by-Step

Once your data is loaded and you're in a new worksheet, you'll see a blank canvas. This is where the magic happens. On the left are your Dimensions and Measures, and at the top are two crucial areas called the Columns Shelf and the Rows Shelf. A vertical bar chart requires one Dimension and at least one Measure.

Step 1: Drag Your Dimension to the Columns Shelf

First, decide what you want to compare. Let's say we want to see sales for different product categories. Your product category is the dimension.

• Find your Dimension in the data pane on the left (e.g., "Product Category").
• Click and drag this pill over to the Columns shelf at the top of the workspace.

You’ll immediately see the names of your categories appear as column headers in the main view. You don't have bars yet - just text labels. That’s because you haven't told Tableau what to measure for those categories.

Step 2: Drag Your Measure to the Rows Shelf

Next, you need to provide the numerical value that will determine the height of each bar. In our example, that's sales totals.

• Find your Measure in the data pane (e.g., "Sales").
• Click and drag this pill over to the Rows shelf.

Tableau instantly springs to life. By default, it will sum up the sales for each product category and display a vertical bar for each one, along with a vertical axis showing the sales values. That’s it! You have officially created a vertical bar chart.

Making Your Bar Chart Work for You: Customization Tips

A basic bar chart is good, but a well-formatted chart is great. Now, let’s refine it with some simple customizations to make it clearer and more insightful.

Sorting Your Data for Clarity

One of the easiest ways to improve your bar chart is to sort it. By default, Tableau usually sorts a chart alphabetically by the dimension's labels. It’s often more useful to sort by the measure, so you can quickly see the highest and lowest performers.

• The Quick Sort: The fastest way is to hover your mouse over the vertical axis (the one with your sales numbers on it). A small sort icon will appear. Clicking it will cycle through sorting in descending order, ascending order, and clearing the sort.
• The Pill Sort: For more control, you can right-click the Dimension pill ("Product Category") in the Columns shelf. Go to Sort > Sort By > Field and then choose the field to sort by (e.g., Sales) and whether you want ascending or descending order.

Sorting by value makes your chart's story instantly obvious. Anyone can glance at it and immediately know which category is the best or worst performer.

Adding Color and Detail

A splash of color can make your chart more engaging or add another layer of information. The Marks Card to the left of your chart controls the visual properties of your data points (the bars).

• Simple color change: Click the Color box in the Marks Card to select a new color for all your bars.
• Color by dimension: What if you want to see which region contributed most to each category's sales? Drag a different Dimension (like "Region") onto the Color box. Tableau will create a stacked bar chart, showing each category's total sales broken down by the color-coded regions. You can also change this to a side-by-side bar chart from the Analysis menu (Stack Marks > Off) or by clicking the visualization type in the 'Show Me' panel.

This is a powerful feature. You're layering information into your visualization, showing more context in the same amount of space.

Using Labels and Tooltips

Sometimes, you want to see the exact numbers without forcing your audience to guess based on the axis. You have two main tools for this: labels and tooltips.

• Data Labels: To show the numerical value on top of each bar, drag your Measure pill ("Sales") from the data pane and drop it onto the Label box in the Marks Card. The total sales for each category will now appear directly on your chart.
• Customizing Tooltips: A tooltip is the little information box that appears when you hover over a bar. Tableau creates a default one, but you can customize it for more detail. Click the Tooltip box in the Marks Card. This opens an editor where you can add text and drag in other data fields. For example, you could add the "Profit" measure to the tooltip, so when someone hovers over a sales bar, they can also see the corresponding profit without cluttering the main chart.

Adjusting Titles, Axes, and Formatting

For a professional final touch, clean up the text elements of your chart.

• Chart Title: Double-click the title at the top of the worksheet to edit it. You can make it more descriptive, like "Sales Performance by Product Category."
• Axis Titles: Right-click on an axis title (e.g., "Sales") and select "Edit Axis..." to change the title or "Format..." to change the number display (e.g., add a dollar sign for currency).
• Grid Lines: To create a cleaner look, you can often remove grid lines. Right-click anywhere in the blank space of the chart and select "Format...". Go to the "Lines" section (a ruler and a pencil icon) and set the Grid Lines for Rows to "None."

Pro-Tips for Better Bar Charts

Once you’re comfortable with the basics, a few extra techniques can take your analysis to the next level.

When to Use a Horizontal Bar Chart Instead

Everything you've learned here applies to horizontal bar charts, too. The only difference is that you swap the pills: put your Dimension on the Rows shelf and your Measure on the Columns shelf. A horizontal bar chart is generally preferred when you have very long labels for your categories, as they are easier to read horizontally than when scrunched and rotated vertically.

Adding Filters for Interactive Analysis

What if you only want to see data from a specific year or region? This is where filters come in. Drag a Dimension (like "Order Date") to the Filters card. Tableau will pop up a window asking how you want to filter (e.g., by years, quarters, etc.). After making a selection, a filter control will appear. Now, users viewing this chart can select different years to see how sales by category have changed over time, making your chart an interactive mini-dashboard.

Creating Calculated Fields

Sometimes, your source data doesn't have the exact metric you need. For example, you might want to see the average sale per customer, not the total sales. You can create this with a calculated field.

• Go to Analysis > Create Calculated Field.
• Give it a name, like "Sales per Customer."
• Enter a formula, such as: `SUM([Sales]) / COUNTD([Customer ID])`
• Click OK.

This new field will appear in your data pane as a new measure, and you can now drag it onto the Rows shelf just like any other measure to create a chart based on your custom metric.

Final Thoughts

You've now walked through the entire process of creating a powerful and professional vertical bar chart in Tableau. From connecting data and understanding dimensions vs. measures to customizing color, sorting, and adding advanced features like filters, you have a solid grasp of this essential data visualization technique.

We know firsthand that while tools like Tableau are powerful, they come with a significant learning curve. At Graphed, we believe getting insights from your data shouldn't require months of training. So, we built a tool where you can create the same reports and dashboards just by describing what you need in plain English. Instead of dragging pills to shelves, you simply ask, "show me a bar chart of sales by product category, sorted highest to lowest" and watch it get built in seconds. If you'd rather spend your time acting on insights instead of learning complex software, give Graphed a try and turn your manual reporting work into a simple conversation.