Đạ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 1 — Overview of Data Visualization in Business

1.4 · Common Chart Types in Data Visualization

Print / Save as PDF

In this lesson

Purpose of commonly used charts; comparison, trend, composition, relationship and geographic charts; matching chart types to data and analytical questions. The slides cover tables, heatmaps, line charts, pie charts, bar charts, histograms, scatter plots, bubble charts and treemaps for hierarchical data, followed by a chart identification exercise.

Learning outcomes

  • LO.1: Explain fundamental concepts of business data, data analysis, data visualization, chart types, dashboards and data storytelling.
  • LO.6: Select, build and refine charts that fit the analytical objective and the data.

The lecture slides for this lesson are below.

Study notes

By the end of this lesson you can:

  • Describe the data requirements, strengths and weaknesses of tables, heatmaps, line, pie, bar, histogram, scatter, bubble and treemap charts.
  • Classify a business question as comparison, trend, composition, relationship, distribution or geographic.
  • Match a question and its data to an appropriate chart and justify the choice.
  • Explain why some charts fail when there are too many categories or data points.

Key idea: Start from the question, not the chart. Decide what you want to show (comparison, trend, composition, relationship, distribution or location) and what data you have, and the chart type usually follows.

Choosing by analytical objective

The chart chooser in the slides starts with one question: "What would you like to show?" It then branches into four families, to which business work adds geography:

ObjectiveTypical questionCommon charts
ComparisonWhich item is bigger? How did items change over time?Bar or column chart; line chart for many periods
CompositionWhat share does each part contribute?Pie, stacked bar or column, 100% stacked, treemap, waterfall
DistributionHow are values spread out?Histogram; scatter plot for two variables
RelationshipDo two or more measures move together?Scatter plot; bubble chart for three variables
GeographicWhere does it happen?Symbol map, filled map

Tables and heatmaps

A table is the simplest visualization: items in rows, attributes in columns. It is very effective for precise values and widely accepted, but it shows trends poorly, rarely conveys one clear message and becomes overwhelming with a lot of data.

A heatmap needs two categorical attributes (rows and columns) and one quantitative attribute shown as colour. It is good for finding clusters and outliers and scales to very many items, but people can only tell apart around ten levels of colour, so it shows patterns rather than exact values.

Line, bar and pie charts

  • Line chart: two quantitative attributes, usually time and a measure. It is useful for trends over time and for comparing how categories change. It is weak for reading individual points; many overlapping lines confuse; and sparse or irregularly spaced points can mislead because the line suggests values in between. For a third quantitative attribute the slides show two options: a second vertical axis, or line thickness.
  • Bar chart (horizontal or vertical): clear comparisons, handles a range of data types and large quantities of information. It is less effective with very many categories, poor for trends, and can mislead if the axis does not start at zero. Horizontal bars suit long category names.
  • Pie chart: one categorical variable for slices and one numeric variable for values. It shows a part-to-whole relationship of a single total (100%), with positive values only. It highlights a dominant share simply but is weak for small segments, gets cluttered with many slices, and makes small differences hard to see.

Histogram, scatter and bubble

  • Histogram: numerical data grouped into bins, showing how often values fall in each interval. It summarises large datasets and reveals shape (normal, skewed) and outliers. Its weakness: the picture depends on the bin width you choose.
  • Scatter plot: the relationship between two numerical variables. It reveals correlations, trends and outliers and supports predictive modelling, but with very many points marks overlap, and you may need filtering or transparency.
  • Bubble chart: a scatter plot whose marks are circles sized by a third measure. Remember that people judge area less accurately than position.

Treemaps for hierarchical data

A treemap shows hierarchical data as nested rectangles, with a quantitative attribute at the leaf level encoded as rectangle size. It scales to very many leaf nodes and shows both the parts and the hierarchy, for example Category containing Sub-Category. Comparing rectangles of similar size is harder than comparing bars.

Worked example

A sales manager at the course's office-supplies retailer brings four new questions. Reason through each one.

  1. "How do Sales differ across each Region and Category combination?" Two categorical fields (Region, Category) and one measure (Sales). This is the heatmap pattern: Region on rows, Category on columns, colour by Sales with a sequential palette. With only nine cells you could also add the values as labels, giving a highlight table.
  2. "How has the profit of each Category changed by quarter over three years?" Twelve quarters is a continuous time trend for three series, so a line chart with one line per Category. Three lines will not overlap badly; with ten or more series, small multiples would be clearer.
  3. "How do Sales, Profit and Quantity relate across the 55 products?" Two measures on the axes and a third as size: a bubble chart with Sales on x, Profit on y and size by Quantity. If the bubbles overlap, drop size and use a scatter plot.
  4. "How is Sales split into Category and then Sub-Category?" Hierarchical part-to-whole: a treemap with Category and Sub-Category, size by Sales. A pie chart would need 13 slices and fail.

In each case, the decision started from the objective (comparison, trend, relationship, composition) and the number and type of fields.

Common mistakes

  • Pie charts with many slices. Beyond about five slices, use a sorted bar chart.
  • Line charts for unordered categories. A line between Furniture and Technology implies a continuity that does not exist; use bars.
  • Bar charts for long time series. Many periods are easier to read as a line.
  • One fixed bin width without checking. Try more than one bin size before you interpret a histogram.

Summary

  • Choose a chart by the analytical objective and the type and number of fields.
  • Tables show precise values; heatmaps show patterns across two categorical dimensions.
  • Lines show trends, bars compare, pies show a few parts of one whole.
  • Histograms show distributions; scatter and bubble charts show relationships.
  • Treemaps show hierarchical part-to-whole data compactly.

Flashcards · Common Chart Types in Data Visualization

9 words
WordMeaningExample
  • Heatmap

    A grid of two categorical attributes in which colour encodes a quantitative value, used to spot clusters and outliers.

    Region rows × Category columns, coloured by Sales.

  • Line chart

    A chart that connects points over a continuous axis, best for showing trends over time.

    Monthly Sales from 2023 to 2025.

  • Bar chart

    A chart using bar length to compare values across categories; axes must start at zero.

    Sales by Sub-Category, sorted descending.

  • Pie chart

    A circle divided into slices showing parts of one whole; positive values and few slices only.

    Share of sales by three Segments.

  • Histogram

    A chart of how often numeric values fall into bins; reveals shape, skew and outliers.

    Number of order lines by Quantity.

  • Scatter plot

    A chart of two numeric variables as points, used to reveal correlation, clusters and outliers.

    Discount on x, Profit on y.

  • Bubble chart

    A scatter plot whose marks are sized by a third measure.

    Sales vs Profit, bubble size = Quantity.

  • Treemap

    Nested rectangles sized by a measure, showing hierarchical part-to-whole data.

    Category containing Sub-Category, size = Sales.

  • Chart chooser

    A guide that selects charts by objective: comparison, composition, distribution or relationship.

    'What would you like to show?' → Comparison → bar.

Practice — Choose the right chart

No software needed. For each business question, write down (a) the chart type you would use and (b) one sentence explaining why. Then compare with the suggested answers below.

  1. How did monthly sales change from January 2023 to December 2025?
  2. Which of the 13 product sub-categories bring in the most sales?
  3. What share of sales comes from each customer segment (3 segments)?
  4. Is there a relationship between the discount given on an order line and its profit?
  5. Which provinces generate the most sales?
  6. How are order quantities distributed (most orders are small, a few are large)?

Suggested answers: 1 line chart (trend over continuous time) · 2 sorted horizontal bar chart (comparison across many categories; a pie would be unreadable with 13 slices) · 3 pie or 100% stacked bar (part-to-whole with few parts) · 4 scatter plot (relationship between two measures) · 5 filled or symbol map, or a sorted bar chart if exact comparison matters more than location · 6 histogram (distribution of one measure).

In Module 3 you will build these charts in Tableau with the course dataset.