Charts and Visualizations - Show a clear comparison
Choose a chart, map labels and values correctly, and communicate a regional sales comparison.
By the end, you can
- Create a readable column chart from a summary.
- Check categories, series, and axis settings.
- Choose chart types for different questions.
Before you start: Prepare a clean summary with category labels and numeric values. Understand number formatting.
In this lesson
Choose the message before the chart
A chart makes patterns easier to compare, but it must represent the right measure. For a regional revenue comparison, first summarize transactions by region using a PivotTable or another reliable method. A chart of individual orders does not automatically calculate regional totals.
North| A | B | |
|---|---|---|
| 1 | Region | Revenue INR |
| 2 | North | 30000 |
| 3 | South | 18000 |
| 4 | East | 6000 |
Create a column chart step by step
- Select A1:B4, including the headers and all three regions.
- Choose Insert > Insert Column or Bar Chart > 2-D Clustered Column. Recommended Charts is another starting point; inspect its proposed chart before accepting it.
- Choose Chart Design > Select Data. Confirm category labels are A2:A4 and the single Revenue INR series uses B2:B4.
- Replace the chart title with Revenue by region - October review. Add axis titles Region and Revenue (INR), and use readable labels.
- Right-click the value axis, choose Format Axis, and set the minimum bound to 0 for this column comparison.
- Remove unnecessary decoration. Keep clear labels and a simple two-dimensional chart so bar heights are easy to compare.
30000| A | B | C | |
|---|---|---|---|
| 1 | Category | Revenue INR | Comparison |
| 2 | North | 30000 | Highest |
| 3 | South | 18000 | Middle |
| 4 | East | 6000 | Lowest |
Match the chart to the question
- Column chart: compare a few categories such as regions or departments.
- Horizontal bar chart: compare categories with long names, such as product descriptions.
- Line chart: show change over ordered dates, with a consistent time scale and a clearly defined measure.
- Scatter chart: examine the relationship between two numeric variables, such as delivery distance and delivery cost. Both axes represent numbers.
Check updates and source coverage
- Change North revenue in B2 from 30000 to 32000. A chart linked to that cell should show the updated value.
- Press Ctrl+Z to restore the example to 30000.
- When the summary comes from a PivotTable, refresh the PivotTable after source changes and confirm the chart reflects the refreshed report.
- When adding categories, inspect Select Data again. A fixed chart range may omit new rows; a chart based on an expanding Excel Table can help keep its source covered.
Hidden and filtered rows can affect which points a chart displays. Check Select Data > Hidden and Empty Cells where available rather than assuming every source row is plotted.
Avoid misleading or unreadable charts
- Wrong categories or multiple accidental series: inspect Select Data and use Switch Row/Column only when it produces the intended mapping.
- Numeric-looking text: convert it to numeric data; a label is not a reliable plotted amount.
- A truncated column axis exaggerates differences: use a zero baseline for the comparison above.
- Too many categories or tiny labels: summarize, filter intentionally, or use a horizontal bar chart.
- A chart title says total revenue but rows contain individual orders: create the totals first.
Check your understanding
Choose an answer for instant feedback. You can try again; answers stay only on this page.