CHAPTER 15 · ADVANCED EXCEL
Charts & Data Visualization
Chart banana easy hai; sahi chart choose karna skill hai. Goal data ko decorate karna nahi, comparison, trend ya composition ko clearly communicate karna hai.
Which chart to use?
- Column/Bar: categories compare karne ke liye.
- Line: time-based trend ke liye.
- Pie/Donut: limited categories ke simple part-to-whole view ke liye.
- Combo: do related metrics ko different scale/series me compare karne ke liye.
Clean chart checklist
Clear title, readable labels, unnecessary 3D effects avoid karo, axis scale check karo aur source data ko clean table me rakho.
Hinglish
Monthly sales ka trend line chart me natural lagega; region-wise sales comparison column chart me. Chart type data question se decide karo.
Practice task
Month aur Sales columns ka dataset banao, line chart insert karo, title set karo aur unnecessary legend remove karo.