7 Integration of Various Graphs

What This Chapter Covers

No single chart type tells the whole story. The most powerful analytical visualizations combine multiple chart types in a coherent, integrated view, whether on a single Tableau worksheet using dual axes and combined marks, or across multiple sheets assembled into a dashboard. In this chapter, you will learn the techniques for integrating graphs: dual-axis charts, combination charts (bar + line), small multiples, trellis layouts, and the principles of dashboard composition that tie multiple views into a unified analytical narrative. This chapter concludes Module 1 and prepares you for hands-on Tableau work in Module 2.

flowchart LR
    A[Single Charts] --> B[Dual-Axis <br> Combination]
    A --> C[Small Multiples <br> Trellis]
    B --> D[Bar + Line <br> Actual vs. Target]
    B --> E[Scatter + Box <br> Distribution + Summary]
    C --> F[Same chart <br> repeated across subsets]
    D --> G[Tableau Dashboard <br> Multiple sheets]
    E --> G
    F --> G
    G --> H[Integrated <br> Analytical View]
    style A fill:#e3f2fd,stroke:#1976D2
    style G fill:#f3e5f5,stroke:#7B1FA2
    style H fill:#e8f5e9,stroke:#388E3C

7.1 Why Integrate Multiple Chart Types?

The Limits of Single-Chart Analysis

Every chart type reveals some aspects of the data and conceals others. A bar chart shows totals but not distributions. A line chart shows trends but not composition. A scatter plot shows relationships but not individual category values. Integration solves this by combining charts so that their individual strengths are additive and their weaknesses are compensated by complementary views.

Three integration strategies are available in Tableau:

Dual-axis combination charts, Two different chart types (or the same type with different measures) layered on a single worksheet using a shared or dual axis.
Small multiples (trellis layouts), The same chart repeated for each value of a dimension, arranged in a grid.
Dashboard assembly, Multiple worksheets combined on a single dashboard canvas, connected by filters and actions.

Each strategy serves different analytical purposes, and the best Tableau workbooks use all three.

7.2 Dual-Axis Combination Charts

What Is a Dual-Axis Chart?

A dual-axis chart overlays two separate charts on the same worksheet, sharing the X-axis but using two independent Y-axes (one on the left, one on the right). This allows you to compare two measures with different units or scales on the same time series or categorical axis.

Common dual-axis combinations:

Combination	Left Axis	Right Axis	Use Case
Bar + Line	Sales (bars)	Profit Ratio (line)	Revenue volume with margin trend
Bar + Line	Actual (bars)	Target (line)	Performance vs. target
Bar + Line	Count (bars)	Average Value (line)	Volume with unit economics
Scatter + Box	Scatter plot	Box plot overlay	Individual points with summary
Area + Line	Cumulative total (area)	Monthly change (line)	Cumulative growth with monthly delta

How To: Creating a Bar + Line Dual-Axis Chart in Tableau

Drag Order Date to Columns (set to Month, continuous).
Drag Sales to Rows, this creates the bar chart base. Change the mark type to Bar.
Drag Profit to Rows again, placing it on the same axis initially.
Right-click the second SUM(Profit) pill on Rows and select Dual Axis.
Change the second mark type to Line.
Right-click the right Y-axis (Profit axis) and select Synchronise Axis, only if the scales are comparable. If the units differ significantly, do NOT synchronise; instead, ensure both axes are clearly labelled.
Format each mark layer independently: set the bars to a medium blue, the line to a dark orange, and add circular marks on the line.
Label the left axis “Monthly Sales (USD)” and the right axis “Monthly Profit (USD).”

[Insert screenshot of a Tableau dual-axis chart: monthly bars for Sales (blue) and a line for Profit (orange), with both Y-axes labelled]

The Dual-Axis Synchronisation Trap

The most common error in dual-axis charts is synchronising axes that should not be synchronised. If Sales is in the range of $0–$50,000 and Profit Ratio is 0–0.25 (25%), synchronising the axes will make the Profit Ratio line appear flat and meaningless at the bottom of the chart. Do NOT synchronise axes when the two measures have different units or very different magnitudes. Instead, label both axes clearly and explain the relationship in the chart title or an annotation.

7.3 The Combination Chart: Bar and Line Together

The Classic Business Combination Chart

The bar-and-line combination chart is one of the most widely used chart types in business intelligence. It simultaneously shows: - Volume (bars), How much total activity occurred in each period. - Rate or ratio (line), What quality or efficiency metric accompanied that volume.

Example: Monthly order count (bars) with average order value (line). This reveals whether revenue growth is driven by more orders (volume growth) or higher-value orders (mix improvement), a strategically important distinction.

How To: Building an Actual vs. Target Combination Chart

Bring in a target value as a parameter or a separate data source column.
Create a calculated field:

Code

# Variance from target
SUM([Sales]) - [Target Sales]

Place Order Date on Columns (Month) and Sales on Rows as bars.
Add Target Sales to Rows and make it a dual axis with mark type Line.
Add a reference line at zero on the variance axis to mark break-even vs. target.
Format bars using a colour rule: green if variance is positive, red if negative.

[Insert screenshot of an actual vs. target combination chart with green and red bars showing over/under performance, and a flat target line in black]

7.4 Small Multiples (Trellis Layouts)

What Are Small Multiples?

Small multiples (also known as faceted charts or trellis layouts) display the same chart type repeated across multiple panels, one per value of a categorical dimension. Each panel uses identical axes and scales, allowing direct comparison across the panels without the visual clutter of overlaid series.

Small multiples are ideal when: - You have three or more groups to compare and overlaying them creates a “spaghetti chart.” - The pattern within each group is as important as the differences between groups. - You want to show all subsets simultaneously for a comprehensive view.

Edward Tufte described small multiples as “the best design solution for a wide range of problems in data presentation” (Jones, 2014).

How To: Creating Small Multiples in Tableau

Method 1, Multiple rows/columns: 1. Place Order Date on Columns (Month, continuous) and Sales on Rows. 2. Drag Region to the Rows shelf alongside Sales. Tableau creates one row of charts per region, a small multiples layout. 3. Ensure the axis scales are fixed and identical across panels: right-click the Y-axis > Edit Axis > Fixed and set the same range for all panels.

Method 2, Grid layout with two dimensions: 1. Drag Category to the Columns shelf (one column per category). 2. Drag Region to the Rows shelf (one row per region). 3. Drag Sales to the Text or Size shelf. 4. This creates a 3×4 grid of charts (3 categories × 4 regions), each showing the same chart type for its specific combination.

[Insert screenshot of a 4-panel small multiples layout with monthly Sales line charts, one per Region, with identical Y-axis scales]

Fixing Axis Scales in Small Multiples

The most critical design rule for small multiples is identical, fixed axis scales across all panels. If each panel auto-scales to its own data range, the viewer will misread differences in axis scale as differences in data values. Always set fixed axis ranges in Tableau before distributing a small multiples view.

7.5 Dashboard Composition: Integrating Multiple Views

The Dashboard as an Integrated Analytical Surface

A Tableau dashboard is a canvas on which multiple worksheets are assembled into a unified analytical view. A well-composed dashboard is more than a collection of charts, it is a coordinated analytical instrument where each chart answers a specific question and the charts together tell a coherent story.

The three-level dashboard structure:

Overview level, High-level KPIs (total sales, profit, order count) displayed as summary numbers or bullet charts at the top of the dashboard.
Trend level, Time-series charts in the middle showing how the KPIs have changed over time.
Detail level, Disaggregated views (by product, region, or customer segment) at the bottom allowing drill-down investigation.

This top-down layout mirrors the natural analytical workflow: assess performance overall, understand the trend, then diagnose the root cause.

How To: Building a Three-Level Dashboard in Tableau

Create three worksheets:
- Sheet 1: A text table or BANs (Big Aggregated Numbers) showing total Sales, Profit, and Order Count using the Text mark type.
- Sheet 2: A dual-axis bar + line chart showing monthly Sales (bars) and Profit Ratio (line).
- Sheet 3: A horizontal bar chart showing Sales by Sub-Category, sorted descending.
Click the New Dashboard tab.
From the Dashboard pane on the left, drag the three sheets onto the canvas. Use a Vertical layout container to stack them.
Resize each sheet: KPIs should be compact (top ~15%), trend chart in the middle (~45%), detail chart at the bottom (~40%).
Add a Text object as a title at the top of the dashboard.
Select Sheet 2 (the trend chart) and click Use as Filter in the sheet menu. Now clicking on a bar in the trend chart filters Sheet 3.

[Insert screenshot of the completed three-level dashboard showing KPI row, monthly trend combination chart, and Sub-Category bar chart]

Dashboard Actions: Creating Interactive Integration

Tableau’s Dashboard Actions transform static dashboards into interactive analytical tools. There are four action types:

Filter Action, Clicking a mark in one chart filters the data in another chart.
Highlight Action, Hovering over a mark in one chart highlights related marks in other charts.
URL Action, Clicking a mark opens a URL (useful for linking to external documentation or CRM records).
Parameter Action, Clicking a mark changes a parameter value, which in turn affects calculated fields across the dashboard.

To add a Filter Action: Dashboard > Actions > Add Action > Filter. Set the Source Sheet (the chart that triggers the filter), the Target Sheet (the chart that gets filtered), and the fields that link them.

7.6 Putting It All Together: The Integrated Analysis Workflow

A Complete Analytical Workflow Using All Chart Types Covered in Module 1

This scenario uses the Superstore dataset to demonstrate how the charts from Chapters 1–7 integrate into a complete analysis:

Question: “What is driving the decline in profit margin in the Technology category over the past two years?”

Step 1, Overview (Chapter 4, Bar chart): A bar chart of Profit Ratio by Category confirms Technology has the lowest and declining margin.

Step 2, Trend (Dual-axis combination chart, this chapter): A bar + line chart of Technology sales (bars) and profit ratio (line) by month reveals that margin declined sharply in Q3 of the most recent year.

Step 3, Distribution (Chapter 5, Box plot): A box plot of Profit by Sub-Category within Technology shows that Machines has a very wide IQR and a long lower whisker, extreme loss-making orders are pulling the category average down.

Step 4, Relationship (Chapter 3, Scatter plot): A scatter plot of Discount (X) vs. Profit (Y) for Machines, coloured by order size, reveals that large-quantity orders with high discounts are all in the loss-making quadrant.

Step 5, Geographic pattern (Chapter 4, Map): A symbol map of Machines orders coloured by profit reveals the loss-making orders are concentrated in two regions.

Conclusion: The Technology profit decline is driven by high-discount bulk Machines orders in specific regions. The recommendation is a pricing policy review for bulk Machines orders with discount rates above 30%.

7.7 Summary

Key Concepts at a Glance

Integration Technique	When to Use	Primary Tableau Feature
Dual-axis chart	Compare two measures on the same X-axis	Dual Axis option on Rows shelf
Bar + line combination	Volume + rate/ratio on same time series	Dual axis with different mark types
Small multiples	Compare patterns across 3+ groups	Dimension on Rows or Columns alongside date
Dashboard assembly	Combine multiple questions into one view	Dashboard canvas + containers
Dashboard actions	Make views interact with each other	Dashboard > Actions menu
Filter action	Click one chart to filter another	Filter action with source and target sheets

Applying This in Practice

The most impactful skill you can develop as a Tableau analyst is the ability to compose dashboards that guide the viewer through a complete analytical story, from overview to trend to detail, using integrated, interacting views. The charts you have learned in Chapters 1–7 are the building blocks. The integration techniques in this chapter are the architecture. Beginning in Chapter 8, you will apply all of these concepts hands-on in Tableau Desktop, starting with how to connect to data, navigate the interface, and build your first workbook from scratch.