Charts turn pivot and table outputs into visual stories—choose chart type to match the message, not decoration.
Create
Select data → Insert → Column/Line/Bar chart. Use recommended charts as a starting point.
Parts
Title, axes, legend, data labels—keep clutter low for executives.
Important interview questions and answers
- Q: Wrong chart?
A: Pie with 15 slices is unreadable—use bar chart. - Q: Axis zero?
A: Bar charts should usually start at zero.
Self-check
- Name two chart types and when to use them.
- Why avoid too many pie slices?
Tip: Delete chart junk—gridlines and legend entries you do not need.
Interview prep
- Bar chart baseline?
Usually start y-axis at zero to avoid distortion.