Basic Charts in Tableau
Learn how to create essential data visualizations in Tableau, including bar charts, line charts, area charts, pie charts, scatter plots and histograms. Understand how to use Rows, Columns, Marks Card and Show Me to convert raw data into meaningful visual insights.
1. Introduction to Basic Charts in Tableau
Data visualization is the graphical representation of information and data using visual elements such as charts, graphs, maps and tables. Instead of analyzing large amounts of raw data, users can understand patterns, comparisons, relationships and trends through visual representations.
Tableau provides multiple built-in chart types that help users explore data and communicate analytical findings. By dragging dimensions and measures into the worksheet, users can quickly create visualizations without writing complex programming code.
For example, a sales dataset may contain thousands of records. A chart can help answer questions such as which product category generates the highest revenue, how sales change over time and which regions perform better.
Why are charts important?
- Make large datasets easier to understand.
- Help identify trends and patterns.
- Support comparisons between categories.
- Highlight unusual values and outliers.
- Help users communicate business insights.
- Support better data-driven decisions.
2. Understanding the Tableau Worksheet
A Tableau worksheet is the main workspace where users create individual charts and visualizations. It provides different shelves, cards and panels that control how data is displayed.
Important worksheet components
| Component | Description |
|---|---|
| Data Pane | Displays available dimensions, measures and fields from the connected data source. |
| Columns Shelf | Controls fields displayed along the horizontal direction of the view. |
| Rows Shelf | Controls fields displayed along the vertical direction of the view. |
| Marks Card | Controls mark type, color, size, label, detail and tooltip. |
| Filters Shelf | Restricts the data included in the visualization. |
| Show Me | Suggests chart types based on the selected fields and their data roles. |
| View Area | Displays the actual chart or visualization created in the worksheet. |
3. Understanding Dimensions and Measures in Charts
Dimensions and measures are important building blocks of Tableau visualizations. Dimensions generally represent descriptive or categorical information, while measures represent numeric values that can be aggregated.
| Dimension | Measure |
|---|---|
| Category | Sales |
| Region | Profit |
| Product Name | Quantity |
| Order Date | Discount |
| Customer Name | Revenue |
For example, when Category is placed on the Columns shelf and Sales is placed on the Rows shelf, Tableau can create a bar chart that compares sales across product categories.
4. Bar Chart in Tableau
A bar chart is one of the most commonly used visualizations in Tableau. It represents data using rectangular bars whose lengths correspond to numeric values. Bar charts are useful for comparing values across different categories.
Types of Bar Charts
- Vertical Bar Chart: Displays categories horizontally and values vertically.
- Horizontal Bar Chart: Displays categories vertically and values horizontally.
- Stacked Bar Chart: Divides each bar into segments to show category composition.
- Side-by-Side Bar Chart: Places multiple bars next to each other for comparison.
Example: Sales by Product Category
Consider the following sample dataset:
| Category | Sales |
|---|---|
| Technology | 85,000 |
| Furniture | 62,000 |
| Office Supplies | 48,000 |
| Accessories | 35,000 |
Steps to Create a Bar Chart
- Open Tableau Desktop or Tableau Public.
- Connect to a dataset containing Category and Sales fields.
- Open a new worksheet.
- Drag the Category dimension to the Columns shelf.
- Drag the Sales measure to the Rows shelf.
- Tableau creates a bar visualization when the field arrangement supports it.
- Use the Marks Card or Show Me panel to select the required bar chart style.
- Drag Sales to Label if you want to display values on the bars.
- Use Color to distinguish categories when it improves readability.
- Rename the worksheet to Sales by Category.
5. Line Chart in Tableau
A line chart displays data points connected by straight lines. It is especially useful for analyzing changes over time, identifying trends and understanding fluctuations in numeric values.
Line charts are commonly used in business reporting for monthly sales, yearly revenue, website traffic, customer growth and financial performance.
Example: Monthly Sales Trend
| Month | Sales |
|---|---|
| January | 20,000 |
| February | 25,000 |
| March | 22,000 |
| April | 32,000 |
| May | 38,000 |
| June | 35,000 |
Steps to Create a Line Chart
- Connect Tableau to a dataset containing Order Date and Sales.
- Open a new worksheet.
- Drag Order Date to the Columns shelf.
- Select the required date level, such as Month.
- Drag Sales to the Rows shelf.
- Open the Marks Card and select Line if necessary.
- Use Color to distinguish multiple lines if comparing categories.
- Use Tooltip to display detailed values when hovering over points.
- Add an appropriate chart title.
6. Area Chart in Tableau
An area chart is similar to a line chart, but the area between the line and the axis is filled with color. It helps communicate changes in values over time and can also show how different components contribute to a total.
Types of Area Charts
- Area Chart: Shows the trend of a measure with the area underneath filled.
- Stacked Area Chart: Shows the contribution of multiple categories to a combined total.
- Percentage Area Chart: Shows the relative percentage contribution of categories over time.
Steps to Create an Area Chart
- Open a worksheet with a date field and a numeric measure.
- Drag the date field to Columns.
- Drag the measure, such as Sales, to Rows.
- Open the Marks Card.
- Select Area as the mark type, or use Show Me where available.
- To create a stacked area chart, add a category dimension to Color.
- Review the chart to ensure that the filled areas are easy to interpret.
7. Pie Chart in Tableau
A pie chart represents the contribution of different categories to a whole. The complete circle represents 100 percent, while each slice represents the proportion of a category.
Pie charts are useful when the dataset contains a small number of categories and the purpose is to show how each category contributes to the total.
Example: Sales Contribution by Category
| Category | Sales |
|---|---|
| Technology | 50,000 |
| Furniture | 30,000 |
| Office Supplies | 20,000 |
Steps to Create a Pie Chart
- Open a new Tableau worksheet.
- Select the Pie mark type from the Marks Card.
- Drag Category to Color.
- Drag Sales to Angle to control the size of each slice.
- Drag Sales to Label if values should be displayed.
- Optionally use Quick Table Calculation to display Percent of Total.
- Adjust the size using the Size option in the Marks Card.
- Review the labels and legend to ensure the chart is understandable.
8. Scatter Plot in Tableau
A scatter plot displays individual data points using two numerical measures. One measure is placed on the horizontal axis and the other measure is placed on the vertical axis.
Scatter plots help identify relationships, clusters, patterns and unusual observations between two numerical variables.
Example: Sales and Profit Relationship
Suppose a company wants to understand whether higher sales are associated with higher profit. A scatter plot can display sales on the X-axis and profit on the Y-axis.
Steps to Create a Scatter Plot
- Open a worksheet with at least two numeric measures.
- Drag Sales to the Columns shelf.
- Drag Profit to the Rows shelf.
- Drag a record-level dimension, such as Customer Name or Order ID, to Detail if individual marks are required.
- Choose Circle from the Marks Card or use Show Me when the selected fields support a scatter plot.
- Use Color to distinguish groups, such as Region or Category.
- Use Size to represent an additional measure if appropriate.
- Optionally add a trend line from the Analytics pane.
9. Histogram in Tableau
A histogram displays the distribution of numerical data by grouping values into intervals called bins. The height of each bar represents the number of records that fall within the corresponding interval.
Histograms are useful for understanding the distribution of values, such as customer ages, delivery times, product prices, examination scores and transaction amounts.
Important Histogram Concepts
- Bins: Groups of numeric values within defined intervals.
- Frequency: Number of records inside a bin.
- Distribution: How values are spread across intervals.
- Outliers: Values that are unusually far from the main distribution.
Steps to Create a Histogram
- Connect to a dataset containing a numerical field such as Customer Age.
- In the Data Pane, right-click the numerical measure.
- Select Create and then Bins.
- Set an appropriate bin size based on the data range and analysis requirement.
- Drag the generated bin field to Columns.
- Drag Number of Records or an appropriate record count measure to Rows.
- Use the Bar mark type if necessary.
- Review the bin size to ensure that the distribution is meaningful.
10. Using Show Me to Create Charts
Show Me is a Tableau feature that provides chart recommendations based on the fields selected by the user. It helps users quickly identify possible visualizations without manually trying every mark type.
The available chart options depend on the selected fields and their data types. For example, a bar chart requires a suitable categorical field and a measure, while a scatter plot generally requires two numerical measures.
Steps to Use Show Me
- Open a Tableau worksheet.
- Locate the Data Pane.
- Select the fields required for the visualization.
- Open the Show Me panel in the worksheet.
- Review the available chart recommendations.
- Select a suitable chart type.
- Tableau creates the visualization if the selected fields meet its requirements.
- Customize the result using the Marks Card and shelves.
Common Show Me chart options
- Text Tables
- Bar Charts
- Line Charts
- Area Charts
- Pie Charts
- Scatter Plots
- Histograms
- Maps
- Highlight Tables
11. Understanding the Marks Card
The Marks Card controls the appearance and level of detail of marks in a Tableau visualization. A mark can represent a bar, line, circle, square, text label or another graphical element depending on the chart type.
Important Marks Card Options
| Option | Purpose | Example |
|---|---|---|
| Color | Changes the color of marks or separates categories visually. | Different colors for product categories. |
| Size | Controls the size of marks. | Larger circles for higher sales. |
| Label | Displays text or values directly on marks. | Sales values on bars. |
| Detail | Adds additional data-level detail without necessarily changing the visual encoding. | Customer ID on a scatter plot. |
| Tooltip | Controls the information displayed when hovering over a mark. | Category, Sales and Profit. |
| Shape | Changes the shape of marks where the mark type supports it. | Different shapes for customer segments. |
12. Choosing the Right Chart Type
Selecting the correct chart type is important because different visualizations communicate different kinds of information. A chart should match the analytical question and the structure of the data.
| Chart Type | Best Used For | Example |
|---|---|---|
| Bar Chart | Comparing categories. | Sales by Region. |
| Line Chart | Showing trends over time. | Monthly Revenue. |
| Area Chart | Showing magnitude and changes over time. | Sales Contribution Over Time. |
| Pie Chart | Showing parts of a whole with a small number of categories. | Market Share. |
| Scatter Plot | Exploring relationships between two numeric measures. | Sales vs Profit. |
| Histogram | Understanding numerical distributions. | Customer Age Distribution. |
| Highlight Table | Comparing values using color intensity. | Sales by Region and Category. |
| Text Table | Displaying exact values in rows and columns. | Category-wise Sales Summary. |
13. Practical Example: Create a Sales Analysis Worksheet
In this practical exercise, we will use a sample sales dataset to create multiple charts in Tableau. The dataset should contain fields such as Order Date, Category, Region, Sales, Profit and Quantity.
Step 1: Connect to the Dataset
- Open Tableau Desktop or Tableau Public.
- Choose the appropriate data connector.
- Load the sales dataset.
- Review the fields in the Data Pane.
- Confirm that date, category and numeric fields have appropriate data types.
Step 2: Create Sales by Category
- Create a new worksheet.
- Drag Category to Columns.
- Drag Sales to Rows.
- Choose a bar chart.
- Add Sales to Label.
- Rename the worksheet to Sales by Category.
Step 3: Create Monthly Sales Trend
- Create another worksheet.
- Drag Order Date to Columns.
- Choose Month as the date level.
- Drag Sales to Rows.
- Choose a line chart.
- Rename the worksheet to Monthly Sales Trend.
Step 4: Create Sales and Profit Analysis
- Create a new worksheet.
- Drag Sales to Columns.
- Drag Profit to Rows.
- Add a suitable record-level dimension to Detail.
- Choose a scatter plot.
- Use Color to distinguish regions if needed.
- Rename the worksheet to Sales vs Profit.
Step 5: Review the Worksheets
After creating the charts, review titles, labels, legends, axes and tooltips. Ensure that each visualization answers a clear business question and does not contain unnecessary visual elements.
14. Common Mistakes While Creating Charts
| Mistake | Why It Is a Problem | Recommended Practice |
|---|---|---|
| Using too many colors | Makes the visualization difficult to understand. | Use a consistent and meaningful color palette. |
| Choosing an unsuitable chart | Can hide important patterns or comparisons. | Select a chart based on the analytical question. |
| Adding too many labels | Creates clutter and reduces readability. | Display only important labels. |
| Ignoring date levels | Can produce an incorrect or confusing time view. | Choose the correct year, quarter, month or day level. |
| Using a pie chart for many categories | Small slices are difficult to compare. | Use a sorted bar chart when there are many categories. |
| Ignoring aggregation | May lead to incorrect interpretation of totals or averages. | Verify SUM, AVG, COUNT or other aggregations. |
| Using misleading axis scales | Can exaggerate or hide differences. | Review axis ranges and formatting. |
15. Best Practices for Tableau Charts
- Start with a clear analytical question.
- Choose a chart that communicates the required information correctly.
- Use meaningful worksheet names and descriptive titles.
- Keep chart formatting consistent across worksheets.
- Use colors to communicate useful information rather than decoration.
- Format numbers, dates and percentages correctly.
- Use tooltips to provide additional details without overcrowding the chart.
- Check filters and aggregations before interpreting results.
- Use appropriate labels and legends.
- Review the visualization with the intended audience in mind.
Summary
Basic charts in Tableau help users transform raw data into meaningful visualizations that support analysis and decision-making. Bar charts are useful for comparing categories, line charts show trends over time, area charts communicate changes in magnitude, pie charts represent parts of a whole, scatter plots help explore relationships between numeric measures and histograms display numerical distributions. Tableau's Rows shelf, Columns shelf, Marks Card and Show Me panel make it easier to create and customize these visualizations. Selecting the correct chart, using appropriate dimensions and measures, and following visualization best practices helps create clear and effective analytical reports.