Goal
You’ll be able to create a basic chart from your data, and understand how to choose the correct chart type for what you’re actually trying to show — a decision that matters more than most beginners realize.
Learn
Selecting your data and choosing a chart type from the Insert tab creates a visual representation of that data. Different chart types genuinely fit different situations, and choosing the wrong one can make even completely accurate data look confusing or misleading:
- Column/Bar charts — comparing distinct categories against each other (sales by region, scores by student).
- Line charts — showing a trend over a continuous sequence, especially time (revenue over the past 12 months).
- Pie charts — showing how individual parts make up a whole, genuinely only appropriate when the parts sum to a meaningful 100% total, and best used with a small number of categories (roughly 5 or fewer) to stay genuinely readable.
A genuinely common mistake is using a pie chart for data that doesn’t represent parts of one meaningful whole — like comparing five students’ individual test scores, where the scores don’t actually sum to any meaningful combined total. A column chart fits this specific comparison far better.
Once a chart exists, clicking it reveals Chart Design and Format tabs, letting you adjust colors, add data labels, change the chart type entirely, or add a trendline (for line/scatter charts, showing the overall direction the data is trending, beyond just the raw individual points).
Decision Task
You want to visually compare five different students’ individual test scores against each other. Before reading on: would a pie chart or a column chart better fit this specific data, and why?
Show Answer
A column chart fits far better. The five scores don’t represent parts of one meaningful combined total (a pie chart’s specific purpose) — they’re independent, separate values being compared side by side, which is exactly what a column chart is designed to show clearly.
Common Mistake
Using a pie chart for data that isn’t genuinely “parts of a whole” — like comparing independent values (individual scores, separate measurements) that don’t actually sum to a meaningful combined total. This is one of the most common chart-selection mistakes, and it can make even completely accurate data look confusing or misleading to someone trying to correctly interpret it.
Practice Questions
1. You want to show how a company’s monthly revenue changed over the past year. Which chart type fits best, and why?
Show Answer
A line chart — it’s specifically designed to show a trend over a continuous sequence like time, which monthly revenue over a year genuinely is.
2. You want to show what percentage of a total marketing budget went to each of four different channels. Which chart type fits, and why?
Show Answer
A pie chart — the four channel amounts genuinely sum to one meaningful total (the whole budget), which is exactly what a pie chart is designed to represent.
3. Why is a pie chart with 15 different categories generally considered a poor choice, even if the data technically sums to 100%?
Show Answer
With that many categories, the individual slices become too small and numerous to visually compare or read clearly, making the chart genuinely hard to interpret despite being technically valid.
4. True or False: any chart type can be used interchangeably for any kind of data, since they all technically display the same underlying numbers.
Show Answer
False — different chart types are genuinely suited to different kinds of comparisons, and choosing the wrong one can make accurate data look confusing or misleading.
5. What does a trendline show on a chart, beyond the raw individual data points?
Show Answer
The overall direction the data is trending, smoothing past the specific individual point-to-point fluctuations.
Try It Yourself
Without looking back, explain in your own words why comparing five independent students’ test scores with a pie chart would genuinely be a poor choice, using this lesson’s reasoning about what pie charts are actually meant to represent.
Show Answer
Pie charts are specifically meant to show how individual parts make up one meaningful combined whole; five independent students’ scores don’t actually sum to any meaningful total together, so representing them as “slices of a whole” misrepresents what the data actually is — a column chart, comparing independent values side by side, fits this specific situation correctly instead.
Quick Check
1. What kind of comparison do column/bar charts fit best?
Show Answer
Comparing distinct, independent categories against each other.
2. What kind of data do line charts fit best?
Show Answer
A trend over a continuous sequence, especially time.
3. What must be true about data for a pie chart to be an appropriate choice?
Show Answer
The parts must sum to a meaningful, complete whole (like 100%).
4. Why is a pie chart with too many categories a poor choice, even if technically valid?
Show Answer
The individual slices become too small and numerous to compare or read clearly.
5. What does a trendline show?
Show Answer
The overall direction data is trending, beyond the individual raw data points.