Reference lines in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a reference line in Tableau?

A reference line is a line added to a chart to highlight a specific value, such as an average or a target, helping viewers quickly understand important points.

beginner

How can you add a reference line in Tableau?

Right-click on an axis and select 'Add Reference Line'. Then choose the scope, value, and formatting options before applying it to the view.

intermediate

Name three types of values you can use for a reference line in Tableau.

You can use a constant value, an aggregate (like average or median), or a computed value (like a parameter) for a reference line.

intermediate

What is the difference between a reference line and a trend line in Tableau?

A reference line marks a specific value on the axis, while a trend line shows the overall pattern or relationship between data points.

beginner

Why should you use reference lines carefully in dashboards?

Too many reference lines can clutter the view and confuse users. Use them to highlight key insights clearly and keep the dashboard clean.

Which of the following is NOT a valid scope option when adding a reference line in Tableau?

A Per Worksheet

B Entire Table

C Per Pane

D Per Cell

Tableau allows reference lines per pane, per cell, or entire table, but not per worksheet as a scope option.

What type of value can you NOT use for a reference line in Tableau?

A Raw data point value

B Aggregate value

C Parameter value

D Constant value

Reference lines use constant, aggregate, or parameter values, but not individual raw data points.

How do reference lines help in data visualization?

A They sort data points

B They add color to charts

C They filter data automatically

D They highlight important values for quick understanding

Reference lines highlight key values like averages or targets to help viewers quickly grasp important information.

Which of these is a good practice when using reference lines in dashboards?

A Add as many as possible for detail

B Use them only to highlight key insights

C Use them to replace all labels

D Avoid formatting them

Reference lines should be used sparingly to highlight key insights and keep dashboards clear.

Where do you find the option to add a reference line in Tableau?

A From the Data pane

B From the Marks card

C Right-click on the axis

D In the Filters shelf

You add reference lines by right-clicking on an axis and selecting 'Add Reference Line'.

Explain what a reference line is and how it can be used in Tableau dashboards.

Think about lines that highlight important values on charts.

Describe the steps to add and customize a reference line in Tableau.

Focus on the user actions and options available.