Charts for analysis
Choose a visual that answers the question and keeps comparisons honest.
By the end, you’ll be able to:
- Choose among category, trend, composition and relationship charts
- Calculate a meaningful percentage share
- Keep scales, labels and source scope clear
Choose the chart from the analytical question
Use a column or bar chart to compare categories, a line for an ordered trend and an XY scatter for the relationship between two numeric measures. A composition chart needs nonoverlapping parts that add to a meaningful whole.
The regional summary has revenue of 380, 230 and 40. A column chart makes the ranking clear. A line joining East, West and North would suggest an ordered connection that the category labels do not have.
| A | B | |
|---|---|---|
| 1 | Region | Revenue |
| 2 | East | 380 |
| 3 | West | 230 |
| 4 | North | 40 |
Keep time and numeric axes distinct
The monthly series 420, 480, 450 and 650 can be plotted in chronological order with a line. Include units and make the reporting period explicit. Missing months are not the same as measured zeros; investigate a gap before filling it.
An XY scatter chart plots numeric x and y coordinates, such as order value and delivery days. A regular line chart generally positions category labels along an ordered category axis. Use scatter when the numeric spacing of x values is part of the question.
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 420 |
| 3 | Feb | 480 |
| 4 | Mar | 450 |
| 5 | Apr | 650 |
Create and inspect the native chart in Excel
- Select a tidy summary including labels and the intended measures.
- Use Insert to choose the relevant chart type.
- Check the selected series, category labels and whether a total row slipped into the categories.
- Add a useful title and units; keep category bars based at zero.
- Change a source value and confirm the chart updates.
For Budget versus Actual across categories, a clustered column chart can compare two series. Keep their units and scope comparable. Two axes can exaggerate apparent relationships; use them only with a clear reason and visible labels.
Explain the result within its limits
“East contributes 58.46% of this sample’s revenue” describes the supplied records. It does not prove East is more profitable or has a larger market; the dataset has neither costs nor market size.
The browser offers functioning one-series column and line previews. Native scatter, multi-series and composition chart building are workbook tasks in Excel. Current web and desktop editions provide charting, but some chart types and formatting controls differ.
Give it a try.
Work through each exercise, check your answer and use a hint whenever you need one. Formula tasks check changed inputs, including boundary cases.
0 of 5 exercises complete
The bounded practice checker accepts equivalent supported formulas, lowercase function names and text labels, extra spaces, and comma or semicolon separators. Array tasks check the complete result shape and values. It is a teaching tool, not a complete Excel engine. See supported behavior.
Take this with you
Match the chart to the question, verify its source and denominator, and communicate only what the supplied measures support.
Practice in Excel
Download the course workbook, follow the tasks, save your completed .xlsx and check its supported formula tasks here. Native Excel features use a separate review checklist.
Download practice workbook Check my workbook ↗Technical references and lesson review
Original lesson content. Technical behavior checked against Microsoft documentation. Reviewed 2026-10-16.