Good charts are honest and readable: labeled units, consistent colors, accessible contrast, and no misleading axes.
Rules
- Title states the takeaway
- Label axes with units ($, %, count)
- Sort bars by value when comparing categories
- Link chart to dynamic range or Table for updates
Export
Copy as picture for slides; embed linked chart in PowerPoint for live updates (desktop).
Important interview questions and answers
- Q: Truncated axis?
A: Can exaggerate differences—document if intentional. - Q: Dynamic range?
A: OFFSET or Table keeps charts current.
Self-check
- Why label units on axes?
- One rule for bar chart baselines?
Pitfall: Dual-axis charts can mislead—label both axes clearly.
Interview prep
- Title job?
State the takeaway, not just "Chart1".