Advanced Chart Types in Tableau
Learn how to create advanced visualizations in Tableau using treemaps, packed bubbles, box plots, histograms, waterfall charts, dual-axis charts, and other analytical charts.
1. Introduction to Advanced Chart Types
Tableau provides a wide range of visualization options to help users understand complex datasets. Basic charts such as bar charts, line charts, and pie charts are useful for common reporting requirements. However, some business problems require more specialized visualizations.
Advanced chart types help users explore distributions, relationships, proportions, variations, trends, and comparisons between multiple measures. They can reveal patterns that may not be immediately visible in a traditional chart.
Tableau supports several advanced visualizations, including treemaps, packed bubbles, histograms, box-and-whisker plots, dual-axis charts, and density maps. Some charts can be created through Show Me, while others require calculated fields, table calculations, or additional shelf configuration.
2. Why Use Advanced Visualizations?
Advanced visualizations help analysts communicate detailed information in a meaningful and understandable format. They are useful when a dataset contains multiple categories, measures, or analytical patterns.
Major Benefits
- Identify complex patterns in large datasets.
- Understand the distribution of numerical values.
- Compare multiple measures in one visualization.
- Analyze relationships between business variables.
- Identify outliers and unusual observations.
- Understand hierarchical data structures.
- Improve business reporting and decision-making.
- Communicate analytical results more effectively.
3. Common Advanced Chart Types in Tableau
| Chart Type | Purpose | Example Use |
|---|---|---|
| Treemap | Displays hierarchical data using nested rectangles. | Sales by Category and Subcategory. |
| Packed Bubble | Compares values using differently sized circles. | Revenue by Product. |
| Histogram | Shows the frequency distribution of numerical values. | Customer purchase distribution. |
| Box Plot | Displays distribution, quartiles, and potential outliers. | Salary distribution by department. |
| Waterfall Chart | Shows how positive and negative values affect a running total. | Revenue and expense analysis. |
| Dual-Axis Chart | Displays two measures using separate axes. | Sales and Profit comparison. |
| Bullet Graph | Compares actual performance against a target. | Sales performance against target. |
| Density Map | Displays geographic concentration using color intensity. | Customer concentration by location. |
4. Treemap Chart in Tableau
A Treemap displays hierarchical data using a collection of nested rectangles. Each rectangle represents a category or subcategory, and its size is determined by a numerical measure.
Treemaps are useful when users want to compare the contribution of different categories to a total value while viewing multiple levels of a hierarchy.
Example: Sales by Product Category
Suppose an organization wants to understand how much each product category contributes to total sales.
Steps to Create a Treemap
- Connect to a sales dataset.
- Open a new worksheet.
- Select Category from the Data pane.
- Select Sales as the numerical measure.
- Open Show Me.
- Select Treemap.
- Drag Subcategory to Detail if you need another hierarchy level.
- Use Sales on Size and Color.
- Add Category or Subcategory to Label.
Important Treemap Properties
- Size: Controls the area of each rectangle.
- Color: Represents a measure or category.
- Label: Displays category names or values.
- Detail: Adds additional levels of information.
5. Packed Bubble Chart
A Packed Bubble chart represents data using circles of different sizes. Each circle represents a data member, and the size of the circle is determined by a selected numerical measure.
Packed Bubble charts are useful for comparing relative values across categories. They provide a visual overview of which categories have larger or smaller values.
Example: Revenue by Product
- Open a new worksheet.
- Drag Product Name to Detail.
- Drag Sales to Size.
- Drag Category to Color.
- Open Show Me.
- Select Packed Bubbles.
- Add Product Name and Sales to Label if required.
Important Properties
- Size: Controls bubble size.
- Color: Separates categories or represents another measure.
- Label: Displays product names or values.
- Tooltip: Provides additional information when users hover over a bubble.
6. Treemap and Packed Bubble Visualization
The following diagram illustrates two different approaches to representing category values. Treemaps use rectangle areas, while Packed Bubble charts use circle sizes.
SVG Diagram 1: Comparing Treemap and Packed Bubble charts.
7. Histogram in Tableau
A Histogram displays the frequency distribution of numerical data. It divides a continuous numerical range into intervals called bins. Each bar represents the number of observations that fall within a particular interval.
Example: Customer Purchase Amount Distribution
An online store wants to understand how many customers make purchases within different price ranges.
Steps to Create a Histogram
- Open a worksheet.
- Locate the numerical field, such as Sales.
- Right-click Sales in the Data pane.
- Select Create and then Bins.
- Configure the bin size.
- Drag Sales (bin) to Columns.
- Drag Number of Records to Rows, or use an appropriate count measure.
- Review the distribution.
Important Histogram Concepts
- Bin: A numerical interval that groups values.
- Frequency: Number of observations in a bin.
- Bin Size: Width of each interval.
- Distribution: Overall pattern of the values.
If a purchase amount dataset contains 100 transactions, a histogram can show how many transactions fall into ranges such as ₹0–₹1,000, ₹1,001–₹2,000, and ₹2,001–₹3,000.
8. Box-and-Whisker Plot
A Box-and-Whisker Plot, commonly called a Box Plot, displays the distribution of numerical data through quartiles, median, and whiskers. It is useful for understanding variability and identifying potential outliers.
Components of a Box Plot
- Minimum: Lower whisker endpoint under the selected whisker rule.
- First Quartile (Q1): The 25th percentile.
- Median (Q2): The 50th percentile.
- Third Quartile (Q3): The 75th percentile.
- Maximum: Upper whisker endpoint under the selected whisker rule.
- Outliers: Observations displayed beyond the whiskers.
Interquartile Range
The Interquartile Range (IQR) measures the spread of the middle 50% of the observations.
IQR = Q3 - Q1
In a commonly used Tukey box plot, the lower and upper fences are calculated as:
Lower Fence = Q1 - (1.5 * IQR)
Upper Fence = Q3 + (1.5 * IQR)
Values beyond these fences may be displayed as potential outliers. They are not necessarily incorrect data points.
Steps to Create a Box Plot
- Open a worksheet.
- Drag a category such as Department to Columns.
- Drag a numerical measure such as Salary to Rows.
- Open Show Me.
- Select Box-and-Whisker Plot.
- Review the median, quartiles, and outliers.
9. Waterfall Chart
A Waterfall Chart shows how a starting value changes through a series of positive and negative contributions to reach a final value.
It is particularly useful for financial analysis, revenue changes, expense breakdowns, and profit calculations.
Example: Profit Calculation
| Business Activity | Amount | Impact |
|---|---|---|
| Starting Revenue | ₹1,00,000 | Starting Value |
| Product Cost | ₹30,000 | Decrease |
| Operating Expenses | ₹20,000 | Decrease |
| Additional Income | ₹10,000 | Increase |
| Final Profit | ₹60,000 | Ending Value |
Steps to Create a Waterfall Chart
- Prepare a dataset containing categories and signed financial amounts.
- Drag the category field to Columns.
- Drag the signed amount measure to Rows.
- Change the Marks type to Gantt Bar.
- Create a running total calculation.
- Use the running total as the starting position of the bars.
- Use the negative absolute contribution as the Gantt Bar size.
- Apply colors to distinguish positive and negative contributions.
- Format labels and tooltips.
Running Total Calculation
RUNNING_SUM(SUM([Amount]))
Gantt Bar Size Calculation
-SUM([Amount])
10. Dual-Axis Chart
A Dual-Axis Chart displays two measures in the same visualization using two axes. It helps users compare different metrics that may have different scales or units.
Example: Sales and Profit
A company wants to compare monthly Sales and Profit in one chart.
Steps to Create a Dual-Axis Chart
- Drag Order Date to Columns.
- Change the date level to Month.
- Drag Sales to Rows.
- Drag Profit to Rows beside the Sales axis.
- Open the second measure pill menu.
- Select Dual Axis.
- Configure the Marks cards for both measures.
- Select suitable mark types, such as Bar and Line.
- Synchronize axes only when their scales and units make comparison meaningful.
Important Considerations
- Each measure has its own axis unless synchronized.
- Different mark types can be used for the two measures.
- Color can distinguish the two measures.
- Axis titles should clearly identify the units.
- Dual axes can be misleading if scales are not interpreted correctly.
11. Bullet Graph
A Bullet Graph is a compact visualization used to compare actual performance against a target or reference value. It can also display qualitative performance ranges.
Example: Sales Performance
Suppose the monthly sales target is ₹1,00,000 and the actual sales are ₹85,000. A Bullet Graph can display the actual value in relation to the target.
Steps to Create a Bullet Graph
- Prepare actual sales and target measures.
- Open a worksheet.
- Select the category and measure fields required.
- Open Show Me.
- Select Bullet Graph if the selected fields are suitable.
- Review the actual measure and target reference.
- Adjust formatting and labels.
12. Density Map
A Density Map represents the concentration of geographic data using color intensity. Areas with a higher concentration of records appear more intense than areas with fewer records.
Example: Customer Distribution
An organization can use a density map to understand where its customers are concentrated and identify areas with a high number of customer records.
Steps to Create a Density Map
- Connect to a dataset containing geographic fields.
- Verify that Tableau recognizes the geographic roles.
- Double-click the geographic field to create a map.
- Change the Marks type to Density.
- Add a suitable geographic field to Detail if required.
- Adjust the intensity and color settings.
- Use filters to explore specific regions or periods.
13. Understanding Distribution and Comparison Charts
Different advanced charts answer different analytical questions. Histograms show frequency, box plots summarize distributions, and dual-axis charts compare two measures.
SVG Diagram 2: Histogram frequency distribution and Box Plot components.
14. Choosing the Right Advanced Chart
Selecting the right chart is important because different visualizations communicate different types of information. The chart should match the question being asked.
| Analytical Requirement | Recommended Chart | Reason |
|---|---|---|
| Compare hierarchical categories | Treemap | Displays nested category contributions. |
| Compare relative category sizes | Packed Bubble | Uses circle sizes to represent values. |
| Analyze numerical distribution | Histogram | Shows frequency across numerical bins. |
| Identify outliers and quartiles | Box Plot | Summarizes the spread of numerical data. |
| Explain financial changes | Waterfall Chart | Shows positive and negative contributions. |
| Compare two measures | Dual-Axis Chart | Displays two measures in one view. |
| Compare actual and target | Bullet Graph | Shows performance against a reference. |
| Analyze geographic concentration | Density Map | Shows spatial concentration patterns. |
15. Using Show Me for Advanced Charts
Show Me is a Tableau feature that recommends visualization types based on the selected fields and their data types.
How to Use Show Me
- Open a Tableau worksheet.
- Select one or more fields in the Data pane.
- Click Show Me in the upper-right area.
- Review the available chart recommendations.
- Select the required visualization.
- Adjust the Marks card and shelves.
- Format the visualization according to the business requirement.
Important Points
- Available chart options depend on selected fields.
- Different charts require different combinations of dimensions and measures.
- Show Me provides a starting point, not a complete analytical design.
- Some advanced charts require additional manual configuration.
16. Combining Advanced Charts in a Dashboard
Multiple advanced charts can be combined into a single dashboard to provide a broader understanding of business performance.
Example: Retail Business Dashboard
- Treemap: Sales contribution by category.
- Packed Bubble: Product-level sales comparison.
- Histogram: Distribution of order values.
- Box Plot: Order value distribution by region.
- Dual-Axis Chart: Monthly Sales and Profit.
- Density Map: Geographic customer concentration.
Dashboard Creation Steps
- Create individual worksheets for each chart.
- Choose a new dashboard.
- Set an appropriate dashboard size.
- Add the required worksheets.
- Arrange the charts using tiled or floating layouts.
- Add dashboard filters where required.
- Configure useful dashboard actions.
- Apply consistent titles, labels, and formatting.
- Test the dashboard using different selections.
17. Advanced Visualization Dashboard Layout
The following example illustrates how multiple advanced visualizations can be organized into one business dashboard.
SVG Diagram 3: Example layout combining advanced Tableau charts.
18. Best Practices for Advanced Charts
- Select a chart based on the business question.
- Use clear titles and descriptive labels.
- Choose colors that improve interpretation.
- Avoid unnecessary visual decoration.
- Use tooltips to provide additional context.
- Check aggregation and data granularity.
- Use appropriate number and date formatting.
- Do not use packed bubbles when precise comparisons are required.
- Use suitable bin sizes for histograms.
- Interpret box plot outliers carefully.
- Label both axes clearly in dual-axis charts.
- Test dashboard filters and interactions.
- Keep dashboards readable on different screen sizes.
19. Common Problems and Troubleshooting
Problem 1: Treemap Displays Incorrect Rectangle Sizes
Reason: The wrong measure or aggregation may be used on the Size shelf.
Solution: Verify the measure, aggregation, and level of detail used in the treemap.
Problem 2: Packed Bubbles Are Not Displayed
Reason: The worksheet may not contain the required dimension and measure combination.
Solution: Add a dimension to Detail and a numerical measure to Size before selecting Packed Bubbles.
Problem 3: Histogram Shows Too Many or Too Few Bars
Reason: The bin size may not be appropriate.
Solution: Adjust the bin size to provide a meaningful distribution view.
Problem 4: Box Plot Does Not Display Expected Outliers
Reason: The data distribution, grouping, or whisker configuration may affect the displayed result.
Solution: Review the underlying records, quartiles, and box plot configuration.
Problem 5: Dual-Axis Chart Is Difficult to Understand
Reason: The measures may use different scales or unclear axis labels.
Solution: Clearly label both axes, use distinct mark styles, and review whether synchronization is appropriate.
Problem 6: Waterfall Chart Shows Incorrect Totals
Reason: The running total, sort order, or signed contribution calculation may be incorrect.
Solution: Check the calculation direction, category order, and positive or negative values.
Problem 7: Dashboard Loads Slowly
Reason: Too many worksheets, complex calculations, or large amounts of data may affect performance.
Solution: Reduce unnecessary visualizations, optimize calculations, and review filters and data-source performance.
20. Practical Exercises
Exercise 1: Create a Treemap
Create a treemap showing Sales by Category and Subcategory. Use Sales for Size and Color.
Exercise 2: Create a Packed Bubble Chart
Create a packed bubble chart showing product-level sales. Use Category for Color and Sales for Size.
Exercise 3: Build a Histogram
Create a histogram using Order Value. Experiment with different bin sizes and compare the frequency distribution.
Exercise 4: Build a Box Plot
Compare the distribution of sales across different regions using a Box-and-Whisker Plot.
Exercise 5: Create a Waterfall Chart
Build a financial waterfall chart showing starting revenue, expenses, additional income, and final profit.
Exercise 6: Create a Dual-Axis Chart
Compare monthly Sales and Profit using two axes and different mark types.
Exercise 7: Build an Advanced Dashboard
Combine a treemap, histogram, box plot, and sales trend chart into one dashboard. Add filters and descriptive titles.
Summary
Advanced Chart Types in Tableau help users analyze complex business data through specialized visualizations such as Treemaps, Packed Bubbles, Histograms, Box-and-Whisker Plots, Waterfall Charts, Dual-Axis Charts, Bullet Graphs, and Density Maps. Each chart serves a different analytical purpose, including hierarchical comparisons, numerical distributions, financial analysis, target evaluation, and geographic concentration. Tableau provides Show Me and worksheet configuration options to create these visualizations. By selecting appropriate chart types, using accurate calculations, applying clear formatting, and combining meaningful charts in dashboards, developers can communicate business insights effectively and support better data-driven decisions.