Building Visualizations in Tableau

The ability to translate a business question into a clear, accurate, and compelling visualization is the core skill of a Tableau analyst. This chapter walks through the worksheet interface in detail, explains how Tableau's drag-and-drop paradigm works at a mechanical level, and guides you through building ten essential chart types — each with step-by-step instructions, a real business use case, and formatting guidance.

---

The Tableau Worksheet Interface

The worksheet is where visualization happens. Before you drag a single field, you need to know every element of this interface and what it controls.

Shelves

Shelves are the structural containers that define what your visualization shows and how it is organized.

Shelf	Location	Function
Columns	Top of view	Fields placed here become columns (x-axis or column headers)
Rows	Left of view	Fields placed here become rows (y-axis or row headers)
Pages	Upper left	Breaks the view into a series of pages, like animated slides
Filters	Upper left	Restricts which data is included in the view
Marks	Left panel	Controls visual encoding: Color, Size, Label, Detail, Tooltip

Important rule: The combination of all dimensions on the Rows, Columns, Pages, and Detail shelves defines the level of detail (LOD) of the view — meaning how granular the data points are.

Marks Card

The Marks card is one of the most powerful control surfaces in Tableau. It contains sub-shelves for:

• Color: Encode a field by color — drag a dimension for categorical color, a measure for a continuous gradient
• Size: Encode a field by the size of marks — larger marks represent higher values
• Label: Display values or field names as text on or near marks
• Detail: Add granularity to marks without changing their visual appearance (splits marks into more points)
• Tooltip: Add fields that appear when the user hovers over a mark
• Shape (when mark type is Shape): Assign different shapes to dimension members
• Path (when mark type is Line): Control the drawing order of lines

At the top of the Marks card is the Mark Type selector — a dropdown showing the current mark type (Automatic, Bar, Line, Area, Square, Circle, Shape, Text, Map, Pie, Gantt Bar, Polygon).

Show Me Panel

The Show Me panel (top-right, toggle with the Show Me button) displays all available chart types as thumbnail icons. Tableau highlights which chart types are available based on the fields currently selected in the Data pane.

• Green border: Chart type is available with currently selected fields
• Gray: Chart type requires additional fields — hover to see what is needed

Show Me is an excellent starting point for beginners, but experienced analysts typically build charts manually for full control.

Cards and Legends

Additional cards appear automatically as you build visualizations:

• Color Legend: Shows which color represents which category or value range
• Size Legend: Shows the mapping between mark size and value
• Shape Legend: Shows shape-to-category mapping
• Filter card: When you add a filter to the Filters shelf and set it to "Show Filter," a control widget appears on the view

You can show, hide, and rearrange cards using the toolbar or the View menu.

---

Drag and Drop Fundamentals — How Pills Work on Shelves

Understanding the mechanics of how pills interact with shelves is the key to building any visualization quickly and confidently.

What Happens When You Drag a Pill

1. Drag a Dimension to Rows or Columns: Tableau creates a header axis — a list of category members. The number of distinct values in that dimension determines how many rows or columns appear.
2. Drag a Measure to Rows or Columns: Tableau creates a quantitative axis. The measure is automatically aggregated (default: SUM). A continuous number line appears.
3. Drag a Dimension to Color: The marks are split into separate color categories — one color per member of the dimension.
4. Drag a Measure to Color: The marks receive a gradient of colors based on the measure's value range.
5. Drag a field to the Filters shelf: A filter dialog opens where you configure which values to include or exclude.

The Drag Path Matters

Where you drop a pill relative to existing pills changes the outcome:

• Dropping a dimension after an existing dimension on the same shelf adds a nested level of grouping
• Dropping a measure on the Rows shelf when a measure is already there creates a dual-axis chart (hold Ctrl/Cmd while dragging to add, rather than replace)
• Dragging from Columns to Rows (or vice versa) transposes the view

Pill Interactions

• Double-click a field in the Data pane to add it to the most logical shelf automatically
• Right-click drag a field to the shelf to get a menu of options before dropping
• Ctrl + drag (Windows) or Cmd + drag (Mac) a pill already on a shelf to copy it rather than move it
• Click the dropdown on any pill already on a shelf to see its full menu of options (aggregation, filters, table calculations, etc.)

---

Blue vs Green Pills: Discrete vs Continuous in Depth

The blue/green distinction is fundamental to how Tableau renders its axes and headers.

Discrete (Blue Pills)

A discrete pill tells Tableau: "There is a finite, enumerable set of values here." When placed on Rows or Columns:

• Creates headers — labeled boxes, one per distinct value
• Values are separated by dividers
• The space between values has no mathematical meaning

Example: Dragging [Region] (blue) to Columns creates four column headers: East, West, North, South.

Continuous (Green Pills)

A continuous pill tells Tableau: "These values exist on a number line — there are theoretically infinite values between any two points." When placed on Rows or Columns:

• Creates an axis — a number line with tick marks and labels
• The visual distance between values is proportional to their numerical difference
• You can add reference lines, trend lines, and forecasts to continuous axes

Example: Dragging [Sales] (green) to Columns creates a horizontal axis from 0 to the maximum SUM(Sales).

Converting Between Discrete and Continuous

Right-click any pill on a shelf (or in the Data pane) to toggle between Discrete and Continuous. This is particularly powerful with date fields:

• [Order Date] as Discrete (blue): Creates column headers by year, quarter, month, or day — depending on the date part selected. Useful for seeing each period as a separate category.
• [Order Date] as Continuous (green): Creates a date axis spanning the full time range. Useful for trend analysis and when date gaps matter.

---

Aggregation: Choosing the Right Function

Every measure placed on a shelf is aggregated across the dimension members in the view. The default is SUM, but the right aggregation depends on the business question.

Aggregation	What It Computes	When to Use
SUM	Total of all values	Revenue totals, unit counts
AVG	Mean of all values	Average transaction size, average score
COUNT	Number of rows (including duplicates)	Number of orders placed
COUNT(DISTINCT) (COUNTD)	Number of unique values	Number of unique customers
MIN	Smallest value	Earliest date, minimum order value
MAX	Largest value	Latest date, highest sale
MEDIAN	Middle value	Household income, response time (robust to outliers)
STDEV	Standard deviation	Variability analysis
VAR	Variance	Statistical spread analysis
ATTR	Returns value if all rows have same value, else *	Confirming a field is consistent within groups

Important: Changing aggregation changes the meaning of the visualization entirely. SUM([Sales]) by month shows total monthly revenue. AVG([Sales]) by month shows the average transaction value per month. Always check that your aggregation matches your business question.

---

Chart Types: Step-by-Step Creation

1. Bar Chart

Business use case: Compare total sales across product categories to identify the top-performing category.

When to use: Comparing a measure across discrete categories. Works for up to ~20 categories before a dot plot or table becomes more readable.

Step-by-step:

1. Drag [Category] to the Rows shelf
2. Drag [Sales] to the Columns shelf — Tableau creates a horizontal bar chart automatically
3. To sort descending: click the Sort Descending button in the toolbar (↓ icon next to field name on axis)
4. To add value labels: drag [Sales] to the Label shelf on the Marks card; right-click the label and format the number (Currency, 0 decimals)
5. To color-code by category: drag [Category] to the Color shelf — each bar gets a distinct color
6. To add a total reference line: go to the Analytics pane, drag Average Line to the view and drop on "Table" — this adds a reference line at the average sales value

Design tips:

• Start bar charts at zero — truncated axes create misleading visual comparisons
• Use a single color for simple rank comparisons; use color only when the color encodes additional meaning
• Sort bars by value (not alphabetically) unless the alphabetical order has business meaning

---

2. Line Chart

Business use case: Analyze monthly sales trends over the past two years to spot seasonal patterns.

When to use: Showing change over time for one or more continuous measures. Lines imply continuity between data points — only use for ordered sequences (time).

Step-by-step:

1. Drag [Order Date] to the Columns shelf — Tableau defaults to the YEAR level. Click the dropdown on the pill and select Month (the continuous version — shows as a green pill)
2. Drag [Sales] to the Rows shelf
3. Tableau creates a line chart. If it shows bars instead, click the Mark Type dropdown and select Line
4. To show multiple lines (e.g., one per region): drag [Region] to the Color shelf — Tableau draws one line per region with a color legend
5. To add data point markers: click the Marks card dropdown, select Line, then check Markers at the bottom of the card
6. To add a trend line: open the Analytics pane, drag Trend Line to the view

Design tips:

• Do not use more than 5-6 lines on a single line chart — beyond that, use small multiples (a technique where the same chart is repeated for each category in a grid layout)
• Label the end of each line rather than using a legend when possible — reduces eye travel
• Use a smooth line only when the underlying data is genuinely smooth (not for erratic financial data)

---

3. Scatter Plot

Business use case: Identify the relationship between profit margin and sales volume across products — does selling more always mean more profit?

When to use: Exploring the relationship (correlation) between two continuous measures. Each point represents one record (or one aggregated entity).

Step-by-step:

1. Drag [Sales] to the Columns shelf (x-axis)
2. Drag [Profit] to the Rows shelf (y-axis)
3. By default, Tableau shows a single aggregated point (SUM of all sales vs SUM of all profit). To see one point per product: drag [Product Name] to the Detail shelf on the Marks card
4. To color by category: drag [Category] to the Color shelf
5. To size points by order quantity: drag [Quantity] to the Size shelf
6. To add a trend line: Analytics pane → drag Trend Line to the view → drop on Linear
7. To add reference lines at zero: Analytics pane → drag Reference Line → drop on both axes, set to Constant value of 0

Design tips:

• The quadrant created by zero reference lines on both axes is useful: top-right = high sales, high profit; bottom-left = low sales, low profit; top-left = low sales, high profit (niche gems); bottom-right = high sales, low profit (loss leaders)
• Overplotting (too many overlapping points) can be reduced using transparency: click Color on the Marks card → adjust opacity slider

---

4. Pie / Donut Chart

Business use case: Show the market share split across three product categories as a percentage of total sales.

When to use: Showing part-to-whole relationships with very few categories (2-4 maximum). Pie charts are controversial — use sparingly.

When NOT to use:

• More than 4-5 categories (slices become too small to read)
• When exact values matter (bar charts are more accurate for comparison)
• When the differences between values are small (humans cannot accurately compare arc lengths)

Step-by-step:

1. Click the Mark Type dropdown and select Pie
2. Drag [Sales] to the Size shelf (determines the slice size)
3. Drag [Category] to the Color shelf (determines the number of slices and their colors)
4. Drag [Sales] to the Label shelf — right-click the label pill and select Quick Table Calculation > Percent of Total to show percentage labels
5. Format labels: click the Label shelf → check Show Mark Labels

Creating a Donut Chart:

1. Build a pie chart as above
2. Create a calculated field: name it 0, enter the value 0 as the formula
3. Drag this 0 field to the Rows shelf
4. On the Rows shelf, right-click the 0 pill and select Dual Axis
5. On the second axis marks card, change mark type to Circle, remove all fields, increase the circle size to cover the center of the pie
6. Change the circle color to white (or your background color)
7. Right-click the right axis and select Synchronize Axis, then hide the axis

---

5. Heat Map

Business use case: Identify which sub-categories perform well or poorly across different customer segments — a correlation-style overview.

When to use: Displaying a measure across two dimensions simultaneously — the intersection is colored by value. Excellent for spotting patterns in large matrices.

Step-by-step:

1. Drag [Sub-Category] to the Rows shelf
2. Drag [Segment] to the Columns shelf
3. Drag [Profit] to the Color shelf on the Marks card — Tableau creates a color-encoded table
4. Change the mark type to Square (for a true heat map look)
5. Drag [Sales] to the Size shelf — marks sized by sales, colored by profit
6. Adjust the color palette: click Color on the Marks card → Edit Colors → select a diverging palette (e.g., Red-Blue) with the center at 0 to distinguish positive from negative profit

---

6. Treemap

Business use case: Show the proportional sales contribution of each sub-category within the overall product portfolio — a hierarchical view.

When to use: Showing part-to-whole relationships across many categories where relative size matters. More scalable than pie charts.

Step-by-step:

1. Click Show Me and select the Treemap option (squares icon), or:
2. Change mark type to Square
3. Drag [Sales] to the Size shelf — larger rectangles = more sales
4. Drag [Category] to the Color shelf — each category gets a base color
5. Drag [Sub-Category] to the Label shelf — labels each rectangle
6. Drag [Profit] to the Color shelf (replacing Category) — color now represents profitability, revealing which high-sales sub-categories are actually unprofitable

---

7. Bullet Chart

Business use case: Compare actual sales against a sales target for each sales representative — a KPI performance overview.

When to use: KPI vs target comparisons. A bullet chart is a compact, information-dense alternative to a gauge/dial chart.

Step-by-step:

1. Drag [Sales Rep] to the Rows shelf
2. Drag [Actual Sales] to the Columns shelf (creates horizontal bars)
3. Right-click the axis and select Add Reference Line
4. Set the reference line to a constant value or a measure (e.g., [Sales Target])
5. Set the line style to Line, label it Target
6. To add a shaded range (showing "good", "satisfactory", "poor" zones): Add a Reference Band instead, using percentage-based boundaries

Alternatively, use the built-in Bullet Chart from Show Me:

1. Select [Sales Rep] and both [Actual Sales] and [Sales Target] in the Data pane (hold Ctrl)
2. In Show Me, click the Bullet Graph option

---

8. Box Plot

Business use case: Compare the distribution of order values across shipping modes — understanding spread, median, and outliers at a glance.

When to use: Showing statistical distribution — median, quartiles, and outliers — across categories. Better than bar charts when you need to communicate variability, not just averages.

Step-by-step:

1. Drag [Ship Mode] to the Columns shelf
2. Drag [Sales] to the Rows shelf
3. Change the mark type to Circle — one circle per order appears
4. Go to the Analytics pane, drag Box Plot to the view — Tableau draws the box (interquartile range), whiskers (1.5x IQR), and marks outliers

Reading a Box Plot:

• Box: Middle 50% of values (25th to 75th percentile)
• Center line in box: Median (50th percentile)
• Whiskers: Extend to 1.5x the interquartile range
• Points beyond whiskers: Outliers

---

9. Histogram

Business use case: Understand the distribution of order values — how many orders fall into each price range?

When to use: Showing the frequency distribution of a single continuous measure. Reveals whether data is normally distributed, skewed, bimodal, etc.

Step-by-step:

1. Right-click [Sales] in the Data pane and select Create > Bins
2. Set bin size to 100 (meaning each bin covers a range of $100)
3. Click OK — Tableau creates a [Sales (bin)] field in your Data pane
4. Drag [Sales (bin)] to the Columns shelf
5. Drag [Sales] to the Rows shelf and change the aggregation to COUNT
6. Tableau creates a histogram — each bar represents the count of orders within that $100 price range

Tip: Experiment with different bin sizes. Bins that are too small create noise; bins too large hide patterns. A general rule is to use the square root of the number of data points as the starting number of bins.

---

10. Gantt Chart

Business use case: Visualize project tasks, their start dates, and durations on a timeline — useful for project management and order fulfillment tracking.

When to use: Displaying duration or time ranges for tasks, projects, or events.

Step-by-step:

1. Drag [Task Name] (or [Order ID] for order tracking) to the Rows shelf
2. Drag [Start Date] to the Columns shelf — change to the continuous date (green pill)
3. Change the mark type to Gantt Bar
4. Create a calculated field for duration: right-click in the Data pane → Create Calculated Field → name it Days to Ship → formula: DATEDIFF('day', [Order Date], [Ship Date])
5. Drag [Days to Ship] to the Size shelf — the bar extends rightward by the number of days
6. Drag [Ship Mode] to the Color shelf to color-code by shipping method

---

The Show Me Panel — When and Why to Use It

Show Me analyzes which fields you have selected in the Data pane and recommends appropriate chart types:

Fields Selected	What Show Me Recommends
1 dimension	Text table, bar chart
1 measure	Histogram
1 dimension + 1 measure	Bar chart, pie chart, treemap
2 dimensions	Heat map, highlight table
1 dimension + 2 measures	Scatter plot, bubble chart
Date + 1 measure	Line chart, area chart
Geographic dimension	Map
2 measures	Scatter plot

Show Me is fast for exploration but limits your control. Once you understand what chart type you want, build it manually for precision.

---

Sorting

Sorting controls the order in which dimension members appear in the view.

Sort Methods

Method	How To	When To Use
Quick Sort	Click the sort icon that appears on an axis when hovering	Fast ascending/descending by the current measure
Toolbar Sort	Ascending (↑) and Descending (↓) buttons in toolbar	Same as quick sort
Manual Sort	Right-click dimension header > Sort > Manual	Custom order (e.g., low, medium, high)
Alphabetical	Right-click dimension header > Sort > Alphabetic	When order is meaningful (company names, codes)
Field Sort	Right-click dimension header > Sort > Field	Sort by a different measure than the one on the axis
Nested Sort	Click sort while dimension is nested under another	Sorts within each group independently

---

Formatting

Formatting in Tableau operates at multiple levels. Changes at a broader level cascade down; more specific settings override broader ones.

Format Hierarchy (broad to specific)

1. Workbook: Default fonts, colors (Format > Workbook)
2. Worksheet: Sheet-level font, shading, borders (Format > Worksheet)
3. Field: Format a specific field across all worksheets (right-click field → Format)
4. Specific Mark: Select a mark and format it individually

Key Formatting Options

Fonts: Format > Font — set font family, size, and style for headers, pane text, tooltips, and title.

Colors: Click the Color shelf on the Marks card → Edit Colors → choose a palette. For diverging color scales, select Stepped Color and choose the number of steps.

Number formats: Right-click a measure axis or label → Format → Numbers → choose Currency, Percentage, Scientific, etc. Set decimal places.

Borders: Format > Borders — control the lines between rows, columns, and cells in tables.

Shading: Format > Shading — add alternating row shading or background color to the view.

Axis formatting: Right-click an axis → Edit Axis → set title, range (Fixed vs Automatic), tick marks, and scale (linear vs logarithmic).

---

Adding Reference Lines, Trend Lines, and Forecasts

The Analytics pane (left panel, second tab) provides drag-and-drop analytical overlays.

Reference Lines

Constant or computed horizontal/vertical lines added to a continuous axis.

1. Drag Reference Line from the Analytics pane to the view
2. Drop on "Table" (entire view), "Pane" (each panel), or "Cell" (each cell)
3. Set value to a constant number, a field average, median, sum, etc.
4. Choose label format and line style

Use for: Average sales line, profit breakeven line, budget target.

Trend Lines

Statistical models fit through scatter plots and line charts to summarize relationships.

1. Drag Trend Line from the Analytics pane to the view
2. Select model type: Linear, Logarithmic, Exponential, Polynomial, Power
3. Right-click the trend line → Edit Trend Lines to see the equation and R-squared value

Use for: Understanding whether sales are growing linearly, accelerating exponentially, or showing no trend.

Forecasts

Tableau's built-in forecasting uses exponential smoothing (Holt-Winters method) to project future values.

1. Your view must have a date dimension on an axis with at least 5 data points
2. Drag Forecast from the Analytics pane to the view
3. Tableau adds projected future values with a shaded confidence interval
4. Right-click the forecast → Forecast Options to adjust the forecast length and model

---

Tooltips: Default and Custom

Tooltips appear when a user hovers over a mark. They are one of the highest-leverage details in dashboard design.

Default Tooltip

By default, Tableau includes all fields currently on the shelves in the tooltip. You can access and edit the default tooltip: Worksheet > Tooltip (or click the Tooltip button on the Marks card).

The tooltip editor supports rich text formatting with bold, italic, font size, and color.

Custom Tooltip

Manually craft a tooltip to include only the most relevant information:

1. Click Tooltip on the Marks card
2. Delete the default text
3. Write your own text, inserting fields using the Insert button (or by typing <AGG(Sales)> syntax)
4. Example: Order: <Order ID>\nCustomer: <Customer Name>\nSales: <SUM(Sales)>\nProfit Margin: <AGG(Profit Ratio)>

Viz in Tooltip

Place an entire mini-visualization inside a tooltip — a powerful feature for showing detail-on-demand.

1. Build the detail visualization on a separate worksheet (e.g., a line chart of sales over time)
2. In the parent worksheet, open the Tooltip editor
3. Click Insert > Sheets and select the detail sheet
4. Configure the size of the embedded viz in the tooltip

---

Annotations

Annotations add text callouts to specific marks, data points, or areas of the view.

Annotation Types

Type	What It Annotates	Best Use
Point	A specific data mark (bar, dot, etc.)	"Highest sales month: $1.2M"
Mark	The coordinates of a mark on an axis	Annotate exact value on a scatter plot
Area	A rectangular region of the view	"Holiday season" spanning a date range

Creating an annotation: Right-click directly on the mark or area in the view → Annotate → select the type → enter text. Drag the annotation box to reposition.

---

Practice Exercises

Use the Sample - Superstore dataset for all exercises unless otherwise noted.

Exercise 1: Build a Ranked Bar Chart

Objective: Build a sorted horizontal bar chart showing sales by sub-category with color-coded profitability.

Steps:

1. Create a new worksheet
2. Place [Sub-Category] on Rows, [Sales] on Columns
3. Sort bars descending by Sales (click the sort button on the axis)
4. Drag [Profit] to the Color shelf — use a diverging Red-White-Green palette
5. Add [Sales] as a label, formatted as Currency with 0 decimals
6. Add a reference line at the average SUM(Sales) across all sub-categories
7. Title the chart: "Sub-Category Sales with Profitability Indicator"
8. Deliverable: A screenshot of the final bar chart. Identify the top 3 sub-categories by sales and note which are profitable vs unprofitable.

Exercise 2: Build a Time-Series Line Chart with Forecast

Objective: Create a monthly sales trend line chart that includes a 12-month forecast.

Steps:

1. Create a new worksheet
2. Drag [Order Date] to Columns — right-click the pill and select the continuous Month (the one labeled "Month/Year" with a green icon)
3. Drag [Sales] to Rows
4. Drag [Category] to the Color shelf — three lines appear
5. In the Analytics pane, drag Trend Line to the view — select Linear. Note the different slopes for each category
6. Remove the trend line, then drag Forecast to the view — extend 12 months
7. Compare the forecasted trajectory of Furniture vs Technology vs Office Supplies
8. Deliverable: Describe what the forecast suggests about each category's growth trajectory and which category appears to have the steepest growth trend.

Exercise 3: Build a Multi-Chart Scatter Plot Analysis

Objective: Create a scatter plot that reveals the profit vs sales relationship across products, with outlier analysis.

Steps:

1. Create a new worksheet
2. Drag [Sales] to Columns, [Profit] to Rows
3. Drag [Product Name] to the Detail shelf — each product becomes a point
4. Drag [Category] to the Color shelf
5. Drag [Quantity] to the Size shelf
6. Add a Linear trend line from the Analytics pane
7. Add reference lines at 0 for both axes (creating four quadrants)
8. Hover over the points in the bottom-right quadrant (high sales, negative profit) — what products are there?
9. Right-click one of these outlier products and select Annotate > Mark to label it
10. Deliverable: Identify 3 products with high sales but negative profit and explain why these "loss leader" products might still exist in the catalog from a business strategy perspective.

---

Summary

This chapter covered the full scope of building visualizations in Tableau, from interface fundamentals to advanced formatting.

Key takeaways:

• The worksheet interface has five shelves (Rows, Columns, Pages, Filters, Marks), a Marks card with sub-shelves for Color/Size/Label/Detail/Tooltip, and the Show Me panel for chart type recommendations
• Drag and drop works by translating field placement into VizQL queries — where you drop a pill determines how Tableau structures and renders the data
• Blue (discrete) pills create headers; green (continuous) pills create axes — understanding this distinction is fundamental to controlling the view structure
• Aggregation must match the business question: SUM for totals, AVG for rates, COUNTD for unique counts, MEDIAN for robust central tendency
• Bar charts are the workhorse for category comparison; always sort by value and start at zero
• Line charts are for trends over time; limit to 5-6 series and use continuous dates for trend lines
• Scatter plots reveal correlations between two measures; quadrant analysis with zero reference lines is a powerful analytical technique
• Pie/donut charts are valid only for 2-4 categories where part-to-whole is the message — avoid for comparisons
• Heat maps, treemaps, bullet charts, box plots, histograms, and Gantt charts each solve specific analytical problems — choose based on the question, not aesthetics
• The Analytics pane provides drag-and-drop overlays: reference lines, trend lines, and forecasts — each adds statistical context without writing code
• Custom tooltips and Viz in Tooltip transform passive charts into interactive data experiences
• Formatting cascades from workbook level down to individual marks — apply changes at the highest applicable level for consistency

In the next chapter, you will learn to extend Tableau's built-in capabilities by writing Calculated Fields — custom formulas that unlock string manipulation, date arithmetic, conditional logic, and advanced aggregations.