Line charts in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a line chart used for in Tableau?

A line chart shows trends over time or ordered categories by connecting data points with a line. It helps visualize how values change.

beginner

How do you create a basic line chart in Tableau?

Drag a date or continuous field to Columns and a measure to Rows. Tableau automatically connects points with a line.

intermediate

Why should you avoid too many lines in a single line chart?

Too many lines make the chart cluttered and hard to read. It’s better to limit lines or use filters for clarity.

beginner

What role does the continuous axis play in a line chart?

The continuous axis (usually time) ensures the points are connected in order, showing smooth trends.

intermediate

How can you add labels to a line chart in Tableau?

Drag the measure or dimension to the Label shelf on the Marks card to show values or names on the line points.

What type of data is best visualized with a line chart?

A Data with unrelated categories

B Data showing parts of a whole

C Data showing trends over time

D Data with only one value

Line charts are ideal for showing how data changes over time or ordered categories.

In Tableau, what happens if you drag a date field to Columns and a sales measure to Rows?

A Tableau creates a line chart by default

B Tableau creates a pie chart

C Tableau creates a bar chart

D Tableau creates a scatter plot

Tableau automatically creates a line chart when a continuous date is on Columns and a measure on Rows.

Why should you use a continuous axis for the date in a line chart?

A To connect points in order and show trends

B To separate data into categories

C To create gaps between points

D To hide some data points

A continuous axis ensures data points are connected in order, showing smooth trends.

What is a good practice when you have many categories to show in a line chart?

A Remove the axis labels

B Limit the number of lines or use filters

C Use pie charts instead

D Show all lines regardless of clutter

Too many lines clutter the chart; filtering or limiting lines improves readability.

How can you add data labels to points on a line chart in Tableau?

A Right-click and select 'Add Data Labels'

B Labels cannot be added to line charts

C Use the Tooltip shelf only

D Drag the measure to the Label shelf on the Marks card

Dragging the measure or dimension to the Label shelf shows labels on the line points.

Explain how to create a line chart in Tableau and why it is useful.

Think about how dates and measures work together to show changes.

Describe best practices to keep a line chart clear and easy to read.

Imagine you are showing a chart to a friend who needs to understand it quickly.

Practice

1. What is the primary purpose of a line chart in Tableau?

easy

A. To show trends over time or ordered data

B. To display proportions of categories

C. To compare individual values without order

D. To show relationships between two categorical variables

Solution

1. Step 1: Understand line chart usage

   Line charts are designed to show how data changes over time or ordered sequences.

2. Step 2: Compare with other chart types

   Other charts like pie or bar charts serve different purposes such as proportions or category comparisons.

3. Final Answer:

   To show trends over time or ordered data -> Option A

4. Quick Check:

   Line charts = trends over time [OK]

Hint: Line charts = trends over time or ordered data [OK]

Common Mistakes:

• Confusing line charts with pie charts
• Using line charts for categorical comparisons
• Ignoring the order or time aspect

2. Which of the following is the correct way to create a continuous line chart in Tableau?

easy

A. Drag a continuous date field to Columns and a measure to Rows

B. Drag a measure to Columns and a dimension to Size

C. Drag a dimension to Rows and a measure to Color

D. Drag a discrete date field to Columns and a measure to Rows

Solution

1. Step 1: Identify continuous date usage

   Continuous date fields create smooth, connected lines in Tableau.

2. Step 2: Understand discrete vs continuous

   Discrete dates create separate marks; continuous dates create a continuous axis for line charts.

3. Final Answer:

   Drag a continuous date field to Columns and a measure to Rows -> Option A

4. Quick Check:

   Continuous date + measure = line chart [OK]

Hint: Use continuous date fields for smooth lines [OK]

Common Mistakes:

• Using discrete dates for line charts
• Placing dimensions on Color instead of axis
• Confusing measure placement

3. Given a dataset with sales over months, what will happen if you drag Order Date (continuous) to Columns and SUM(Sales) to Rows in Tableau?

medium

A. A bar chart with sales for each month

B. A pie chart showing sales proportions

C. A scatter plot of sales vs. months

D. A smooth line chart showing sales trend over months

Solution

1. Step 1: Analyze continuous date on Columns

   Continuous dates create a continuous axis, ideal for line charts.

2. Step 2: Analyze SUM(Sales) on Rows

   SUM(Sales) aggregates sales values to plot points connected by lines.

3. Final Answer:

   A smooth line chart showing sales trend over months -> Option D

4. Quick Check:

   Continuous date + SUM(Sales) = line chart [OK]

Hint: Continuous date + measure = smooth line chart [OK]

Common Mistakes:

• Expecting bars instead of lines
• Confusing continuous with discrete dates
• Misinterpreting aggregation effect

4. You created a line chart but see disconnected points instead of a line. What is the most likely cause?

medium

A. Using a continuous date field on the Columns shelf

B. Using a discrete date field on the Columns shelf

C. Placing a measure on Color instead of Rows

D. Not aggregating the measure

Solution

1. Step 1: Identify effect of discrete date

   Discrete dates create separate marks for each date, causing disconnected points.

2. Step 2: Contrast with continuous date

   Continuous dates create a continuous axis, connecting points with lines.

3. Final Answer:

   Using a discrete date field on the Columns shelf -> Option B

4. Quick Check:

   Discrete date = disconnected points [OK]

Hint: Discrete dates cause disconnected points [OK]

Common Mistakes:

• Assuming continuous dates cause disconnected points
• Ignoring aggregation importance
• Misplacing measures on Color

5. You want to compare sales trends for multiple product categories over time in one line chart. Which approach is best in Tableau?

hard

A. Place Category on Columns, continuous Order Date on Rows, and SUM(Sales) on Label

B. Place discrete Order Date on Columns, Category on Rows, and SUM(Sales) on Size

C. Place continuous Order Date on Columns, SUM(Sales) on Rows, and Category on Color

D. Place continuous Order Date on Rows, Category on Color, and SUM(Sales) on Tooltip

Solution

1. Step 1: Use continuous date for smooth time axis

   Continuous Order Date on Columns creates a smooth timeline axis.

2. Step 2: Use SUM(Sales) on Rows for measure values

   SUM(Sales) on Rows plots sales values vertically.

3. Step 3: Use Category on Color to separate lines

   Category on Color differentiates multiple lines by color for easy comparison.

4. Final Answer:

   Place continuous Order Date on Columns, SUM(Sales) on Rows, and Category on Color -> Option C

5. Quick Check:

   Continuous date + measure + color by category = multi-line chart [OK]

Hint: Use color to separate lines by category [OK]

Common Mistakes:

• Using discrete dates causing broken lines
• Placing category on Rows instead of Color
• Not using continuous date for time axis