📊 PHASE 1 · LEVEL 2 🟢 Beginner MODULE 05

Basic Charts & Visualizations

⏱️ 50–65 min read

📊 6 Chart Types

❓ 5 Quiz Questions

🗺️ Maps Included

This is where Tableau gets truly exciting. You'll build every essential chart type — bar charts in their many forms, trend lines, maps, scatter plots, and more. By the end of this lesson, you'll be able to look at any business question and immediately know which chart to reach for, and exactly how to build it in Tableau.

Module 5 of 25+ · Phase 1 Progress 20%

📊 Section 1

Bar Charts

The bar chart is the workhorse of data visualization. It's the best chart for comparing discrete categories on a single quantitative measure. Tableau makes building bar chart variants trivial — here's how to build each type.

Vertical Bar Chart (Standard)

Drag Dimension to Columns

Drag Category (or any dimension) to the Columns shelf. You'll see three columns labeled with your category values.

Drag Measure to Rows

Drag SUM(Sales) to Rows. Tableau auto-renders a vertical bar chart. The mark type in the Marks card automatically selects "Bar".

Sort Descending

Click the Sort Descending icon in the toolbar, or right-click the axis → Sort → Field → Descending. Sorted bars are far easier to read than random order.

Horizontal Bar Chart

When your category labels are long (product names, customer names), horizontal bars prevent label overlap. Simply press Ctrl+W to swap rows and columns — your vertical bar chart instantly becomes horizontal. You can also right-click on the chart → Swap Rows and Columns.

Stacked Bar Chart

Stacked bars show part-to-whole relationships within each category. To create one: start with a vertical bar chart, then drag a second dimension (e.g., Segment) to the Color mark. Each bar splits into colored segments representing the sub-categories. Tableau stacks them automatically.

Side-by-Side (Grouped) Bar Chart

To place bars side-by-side instead of stacked: after dragging the second dimension to Color, also drag it to the Columns shelf (add it alongside the first dimension). Tableau creates grouped bars where each main category contains one bar per sub-category placed side by side.

💡

When to Use Stacked vs Side-by-Side

Stacked is best when you want to show the total AND the composition simultaneously — total revenue broken down by product segment. Side-by-side is better when you need to precisely compare sub-category values to each other — comparing sales for each product category in 2023 vs 2024 side by side. Stacked bars make comparing individual segments hard when the baseline isn't the same (middle segments float).

📈 Section 2

Line Charts

Line charts are the gold standard for showing trends over time. They connect data points sequentially, making it easy to see direction, acceleration, seasonality, and inflection points. In Tableau, building a compelling line chart requires understanding continuous vs discrete date handling.

Basic Time-Series Line Chart

Drag Order Date to Columns

Drag your date field to Columns. Tableau defaults to showing it at the Year level — right-click the pill → choose a finer granularity like Month or Quarter.

Drag Sales to Rows

Drag SUM(Sales) to Rows. Tableau renders a bar chart first — click the Line chart icon in Show Me (or change the mark type dropdown to Line). You now have a line chart.

Continuous vs Discrete Dates

Right-click the date pill on Columns. The top half of the menu shows Discrete options (blue pill — creates labeled headers). The bottom half shows Continuous (green — creates a smooth axis). For line charts, continuous dates give the best visual result.

Multiple Lines (Dual-Axis)

To show two measures as separate lines on the same chart (e.g., Sales and Profit over time): drag the second measure to the Rows shelf alongside the first. Right-click the second measure's axis → Dual Axis. Both measures now share the same axis area with independent scales. Right-click again → Synchronize Axis if you want them on the same scale.

Adding Trend Lines

Right-click on the line chart view → Trend Lines → Show Trend Lines. Tableau fits a linear regression line by default. Right-click the trend line → Edit Trend Lines to switch to Exponential, Logarithmic, Polynomial, or Power trend models — and to show R² and p-values to assess fit quality. Trend lines are essential for sales forecasting presentations.

⚠️

Discrete vs Continuous Date Trap

If your date is on Columns as a discrete MONTH(Order Date), the line chart won't span across years — you'll see multiple overlapping lines, one per year. This is intentional for year-over-year comparisons but confusing for a continuous trend. For a full timeline, use continuous date (bottom half of the right-click menu). Look for the green vs blue pill to know which mode you're in.

🥧 Section 3

Pie Charts & Donut Charts

Pie charts show part-to-whole proportions. They're the most misused chart type in data visualization. Use them sparingly and only under specific conditions.

Building a Pie Chart

Change Mark Type to Pie

Start with a blank sheet. Click the Mark type dropdown in the Marks card → select Pie.

Drag Measure to Angle

Drag SUM(Sales) to the Angle shelf in the Marks card (this appears when Pie is selected). This defines the slice size.

Drag Dimension to Color

Drag Category (or your dimension) to the Color shelf. Each slice gets a color. Add the dimension to Label as well to show slice names.

Converting to a Donut Chart

Donut charts (pie with a hole) are more modern and allow placing a KPI number in the center. To create one: build your pie chart, then create a second "blank" Axis on the Rows shelf by typing MIN(0) and dragging it to Rows. Make it dual-axis. Set the inner circle's mark size to large and color it to match the background. The visual result is a donut — add a text label in the center via a floating text object on a dashboard.

⚠️

When NOT to Use Pie Charts

Avoid pie charts when: (1) you have more than 5-6 slices — humans can't accurately perceive slice angles beyond that. (2) The values are close together — a bar chart makes differences immediately obvious while a pie chart obscures them. (3) You need to show change over time. The golden rule: if you need a legend to identify slices, the chart is already too complex — use a bar chart instead.

🗺️ Section 4

Maps

Maps are powerful when your data has a geographic dimension. Tableau has built-in geographic recognition for countries, states, provinces, cities, and ZIP codes. There are two main map types: Symbol Maps and Filled (Choropleth) Maps.

Symbol Map (Bubble Map)

Double-Click a Geographic Field

Double-click State (or Country, City) in the Data pane. Tableau automatically generates Latitude and Longitude fields and places dots on a map — one per location.

Encode Size with a Measure

Drag SUM(Sales) to the Size mark. Each dot grows proportionally to sales volume — locations with more sales have bigger circles.

Add Color for Second Measure

Drag SUM(Profit) to Color. Now each bubble shows both sales (size) and profit (color intensity) simultaneously — two measures in one chart.

Filled Map (Choropleth)

Filled maps color entire geographic regions based on a measure value. In Show Me, select the Filled Map option after placing a geographic field. Drag your measure to Color. A gradient color scale fills each region — darker shades typically indicate higher values. Best for showing density or rate data (like population per square km or sales per capita) rather than raw totals.

🌍

Custom Geocoding for Non-Standard Locations

Tableau doesn't recognize every location by default. For Pakistan districts, local administrative areas, or custom zones, you have two options: (1) Create a custom geocoding file (.csv with Location Name, Latitude, Longitude columns) and import it via Map → Geocoding → Import Custom Geocoding. (2) Manually provide a Latitude and Longitude field in your dataset and place them directly on the Rows (Latitude) and Columns (Longitude) shelves.

🔵 Section 5

Scatter Plots & Text Tables

Scatter plots reveal relationships and correlations between two quantitative variables. Text tables (crosstabs) present precise numeric data in a grid format. Both serve important analytical roles.

Scatter Plot

Drag Two Measures

Drag SUM(Sales) to Columns and SUM(Profit) to Rows. Tableau shows a single aggregate dot — that's because all data is summed into one point.

Add Detail to Disaggregate

Drag Customer Name (or Product Name) to the Detail mark. This disaggregates the view — one dot per customer. Now you can see the Sales vs Profit relationship for each customer.

Add a Reference Line

Right-click on the Profit axis → Add Reference Line → Line → set the value to 0. This adds a breakeven line, making negative-profit customers immediately visible below the line.

Text Table (Crosstab)

Drag dimensions to both Rows and Columns to create a matrix, then drag a measure to the Text mark in the Marks card. The result is a grid of numbers — the Tableau equivalent of an Excel pivot table. Use Ctrl+1 to switch to Show Me, and select "Text Table" for automatic configuration. Add conditional coloring by dragging your measure to Color — Tableau applies a gradient, creating a heat map / highlight table that shows the numeric values and their relative sizes simultaneously.

🎯 Section 6

The Chart Selection Guide

Choosing the wrong chart type is the most common data visualization mistake. Use this guide to instantly select the right chart for any business question.

📊

Bar Chart

✅ Use when: Comparing values across categories

❌ Avoid: More than ~20 bars, or for showing trends over time

📈

Line Chart

✅ Use when: Showing change or trend over time (continuous data)

❌ Avoid: Categorical comparisons with no time dimension

🥧

Pie / Donut

✅ Use when: Showing part-to-whole with <6 segments

❌ Avoid: Many segments, similar values, time comparisons

🗺️

Map (Filled/Symbol)

✅ Use when: Geographic distribution matters to the story

❌ Avoid: When geographic context adds no insight

🔵

Scatter Plot

✅ Use when: Showing correlation between two measures

❌ Avoid: When one variable is categorical, use bars instead

📋

Text Table

✅ Use when: Audience needs precise numbers for lookup

❌ Avoid: When visual comparison is more important than exact values

Business Question	Best Chart	Why
"Which region sells the most?"	Horizontal Bar	Comparing discrete categories by a single measure
"How have sales trended this year?"	Line Chart	Continuous change over time
"What % of revenue comes from each category?"	Donut or Stacked Bar	Part-to-whole (donut if <6 parts)
"Where are our customers located?"	Symbol Map	Geographic distribution with quantity encoding
"Is there a correlation between discount and profit?"	Scatter Plot	Relationship between two continuous measures
"Show me exact sales by sub-category and year"	Highlight Table	Precise values + visual magnitude in a grid

🔑 Key Concepts — Lesson 5

Dual Axis

Two measures sharing the same chart area with independent or synchronized axes. Used for comparing measures with different scales.

Continuous Date

A date field used as a smooth numeric axis (green pill). Creates an unbroken timeline. Best for trend analysis over multiple years.

Filled Map

A choropleth map that colors geographic regions based on a measure. Best for showing rates or density rather than raw totals.

Symbol Map

Places sized circles on a map at geographic coordinates. Circle size and color encode measure values. Best for showing totals at locations.

Highlight Table

A text table with color encoding added. Shows both precise numbers and visual magnitude. Alternative to heat maps for labeled data.

Trend Line

A fitted statistical line overlaid on a scatter plot or line chart. Models the underlying trend (Linear, Exponential, etc.) with R² indicator.

🧠 Knowledge Check

1. You want to show how monthly sales have changed over the past 3 years as one continuous trend line. Which setup is correct in Tableau?

2. You're building a scatter plot of Sales vs Profit but it shows only one dot. What do you need to add to disaggregate the view into one dot per customer?

3. Which Tableau map type colors entire geographic regions (like countries or states) based on a measure value?

4. What is the keyboard shortcut to swap the Rows and Columns shelves (turning a vertical bar chart into horizontal)?

5. A stakeholder asks you to visualize which of 15 product sub-categories account for the largest share of total revenue. Which chart type is MOST appropriate?

🏆

✅ Lesson Summary

What You Learned

📋

Lesson 5 — Key Takeaways

✅ Bar charts: vertical, horizontal, stacked, and side-by-side — use Ctrl+W to swap axes
✅ Line charts: continuous dates for trends, discrete dates for year-over-year comparisons
✅ Pie charts: maximum 5-6 slices — use bars instead when in doubt
✅ Maps: Symbol (bubbles at locations) vs Filled (shaded regions)
✅ Scatter plots: add a dimension to Detail to disaggregate from one dot to many
✅ The chart selection rule: match chart type to the question being asked, not personal preference

← Lesson 4: Data Types