Đại học Kinh tế Quốc dân – National Economics UniversityMICRO4ASIA
🏆 Arena
Sign inSign up
MICRO4ASIAThe six micro-credentials

Courses are delivered on the Limio learning platform. Limio

← Data Visualization in Business

You are viewing a public preview

Sign in to save your progress, do assignments, join discussions and get feedback.

Sign in
Module 3 — Building and Refining Basic Charts in Tableau

3.2 · Chart Refinement

Print / Save as PDF

In this lesson

Appearance and formatting; colors, size and display options; data labels, titles, subtitles and fonts; axes, scales, number formats and grid lines; sorting, filtering, Top N and grouping; legends, tooltips and reference lines; layout, readability and accuracy checks.

Learning outcomes

  • LO.5: Use Tableau Desktop and Tableau Public to connect data, organize fields and build visualizations.
  • LO.6: Select, build and refine charts that fit the analytical objective and the data.

The lecture slides for this lesson are being prepared and will be added here.

Practice for Module 3

Build comparison, trend, composition, relationship and geographic charts from the practice data; then refine their formatting, axes, labels, filters, sorting, legends and tooltips, and check each chart for readability and accuracy. (About 24 hours of independent study.)

Study notes

By the end of this lesson you can:

  • Format a Tableau chart's colours, labels, titles, fonts, axes, number formats and gridlines for readability.
  • Sort, filter, apply Top N and group data so the view shows what matters.
  • Edit legends and tooltips, and add reference lines, bands and distributions.
  • Run a final readability and accuracy check before sharing a chart.

Key idea: A first chart answers the question for you; a refined chart answers it for your audience. Every formatting choice should make the main message faster to see and harder to misread.

Formatting: colour, size and display

Most formatting is done in the Format pane (right-click an element and choose Format), and workbook-wide fonts and lines can be set once under Format → Workbook.

  • Colour: click Color on the Marks card and choose Edit Colors. For a dimension, pick a categorical palette or assign colours manually; for a measure, choose a sequential or diverging palette and, for diverging palettes, set the centre (for example 0 for Profit). A good habit from Module 1: grey for context, one accent colour for the item you want readers to notice.
  • Size and opacity: adjust mark size, and lower opacity or add borders when marks overlap.

Labels, titles and fonts

  • Labels: click Label on the Marks card and choose which marks to label (all, minimum/maximum, line ends, selected or highlighted). Label only the values readers need.
  • Titles: double-click the title to edit it. A good title states the finding, not the chart type. You can insert fields and parameters into titles and captions so they update when filters change, for example a title that shows the selected year.
  • Fonts: keep one font family, use size and weight to create hierarchy (title, subtitle, labels), and avoid decorative fonts.

Axes, scales, number formats and gridlines

  • Edit Axis (double-click the axis): choose an automatic, uniform, independent or fixed range; keep Include zero for bar charts; use a logarithmic scale only when values span several orders of magnitude, and say so.
  • Number formats: right-click a measure, then Default Properties → Number Format to set it everywhere (thousands separators, decimals, currency, percentage, units such as K or M). Formatting a single pill changes only that view.
  • Gridlines and borders: remove or lighten lines that do not help reading (Format → Lines, Format → Borders). Hide axis titles that repeat the chart title.

Sorting, filtering, Top N and grouping

  • Sorting: use the sort buttons on the toolbar or axis, or right-click a dimension and sort by a field, alphabetically, manually or nested within another dimension.
  • Filtering: drag a field to the Filters shelf. Dimension filters choose members (with General, Wildcard, Condition and Top tabs); measure filters choose a range; date filters can be relative ("last 12 months"). Show Filter gives viewers a control (list, dropdown or slider).
  • Top N: in a dimension filter, the Top tab keeps the top or bottom N members by a measure. Top N filters are computed before ordinary dimension filters, so to apply another filter first, add that filter to context (it turns grey).
  • Grouping: select members and click the paperclip icon, or right-click a dimension and choose Create → Group. A group creates a new dimension that combines members into higher-level categories, optionally with "Other" for the rest.

Legends, tooltips and reference lines

  • Legends: show only legends that are needed, give them a clear title, and order items to match the chart.
  • Tooltips: click Tooltip on the Marks card to edit the text. Insert fields, remove technical names such as "SUM(Sales)", and write a readable sentence. You can also insert a small chart into the tooltip (Viz in Tooltip).
  • Reference lines, bands and distributions: drag them from the Analytics pane onto the view. A reference line can show a constant (a target), an average, median, minimum or maximum, computed for the whole table, each pane or each cell. A band shades a range; a distribution shows percentiles or standard deviations.

Readability and accuracy checks

Before sharing, ask: Is the message clear in five seconds? Do bar axes start at zero? Do totals match the data? Is anything left that could be removed?

Worked example

Refine a chart of Profit by Sub-Category (course dataset) for a category manager.

  1. Start. Sub-Category on Rows, SUM(Profit) on Columns, title "Sheet 2", bars in default blue, unsorted.
  2. Sort. Sort descending by SUM(Profit), so profitable sub-categories sit at the top and any loss-making ones at the bottom.
  3. Colour with meaning. Drag SUM(Profit) to Color and choose a diverging palette (for example orange–blue) centred at 0. Losses now stand out without a legend; hide the colour legend because the axis already shows the values.
  4. Reference line. Add a constant reference line at 0, labelled "Break-even", so readers see which bars cross it. Optionally add an average line to show which sub-categories are above the typical profit.
  5. Labels and numbers. Set the Profit default number format to thousands separators with no decimals, and label only the negative bars.
  6. Title. Write a title that states what the chart shows, built after checking the data, for example in the form "[sub-categories] lose money while the rest are profitable". Add a subtitle with the date range.
  7. Tooltip. Edit it to read <Sub-Category>: profit <SUM(Profit)> on sales of <SUM(Sales)>.
  8. Check. Compare the sum of all bars with total profit in the data source, and look at the chart in greyscale to make sure losses are still readable through position and the reference line.

Common mistakes

  • Fixed axis ranges left in place. A fixed range copied from another chart may cut off bars after a filter changes.
  • Top N without context. Adding a Region filter does not change which items are "top" unless that filter is in context.
  • Formatting only the pill. Format the measure's default properties so every view uses the same number format.
  • Tooltips full of field names. "AGG(Profit Ratio): 0.1234" is not readable; rewrite it as a sentence with a formatted value.

Summary

  • Use the Format pane and workbook formatting for consistent colours, fonts and lines.
  • Labels, titles and tooltips should state the message in plain language.
  • Bar axes start at zero; number formats are set once in default properties.
  • Sort, filter, Top N and groups focus the view; context filters control the order of filtering.
  • Reference lines, bands and distributions from the Analytics pane add benchmarks to a chart.

Flashcards · Chart Refinement

9 words
WordMeaningExample
  • Format pane

    The panel for formatting fonts, shading, borders, lines and numbers of a view or workbook.

    Right-click the axis → Format → Lines.

  • Edit Axis

    Dialog for setting an axis range (automatic, uniform, independent, fixed), zero, scale and title.

    Keep 'Include zero' ticked for bar charts.

  • Default number format

    A measure's number format set once in Default Properties so every view uses it.

    Sales: thousands separator, 0 decimals.

  • Top N filter

    A dimension filter that keeps the top or bottom N members by a measure.

    Top 5 Sub-Categories by SUM(Sales).

  • Context filter

    A filter applied before Top N, sets and FIXED LOD expressions; shown as a grey pill.

    Region filter in context, then Top 5 within it.

  • Group

    A new dimension that combines selected members into a higher-level category.

    Same Day and First Class grouped as Express.

  • Tooltip

    The text shown when hovering over a mark; it can be edited and include fields or a chart.

    'In <MONTH(Order Date)>, sales were <SUM(Sales)>.'

  • Reference line

    A line from the Analytics pane marking a constant, average, median, min or max.

    Average monthly sales line on a trend chart.

  • Dynamic title

    A title that includes field or parameter values so it updates with filters.

    'Sales in <YEAR(Order Date)>'

Practice in Tableau — Lab 3B: Refine your charts

Take the charts from Lab 3A and make them presentation-ready.

  1. Sort and Top N. Make a horizontal bar chart of Sub-Category × Sales, sort it descending and add a Top N filter (top 5 by Sales). Check: Machines first, with 556,446.
  2. Titles that say something. Replace "Sheet 1" with a title that states the finding, for example "Sales grew every year, peaking in December".
  3. Number formats. Format Sales with thousands separators and no decimals, and Profit Ratio as a percentage.
  4. Labels and colour. Show labels only where they help (e.g. the largest bars). Use one highlight colour for the category you want readers to notice and grey for the rest.
  5. Axes. Bar charts must start at zero. Remove gridlines you do not need.
  6. Grouping. Create a group Express that combines Same Day and First Class in Ship Mode.
  7. Tooltips. Edit the tooltip of the monthly line chart to read: "In <month>, sales were <Sales>."
  8. Reference line. Add an average line to the monthly sales chart and describe which months sit above it.

Swap your refined charts with a classmate and check each other's against the design principles in Module 1: is the message clear in five seconds?