Charts & Graphs
Delhi Police / SSC Exams
Data alone can be boring — but when you turn it into a chart, it becomes visual, clear, and powerful. Charts help you compare, analyze, and present data quickly in Excel.
What are Charts & Graphs?
A chart or graph is a visual representation of data. It helps identify patterns, trends, and comparisons easily.
Tip: Charts automatically update when your data changes!
Types of Charts You Must Know
| Chart Type | Purpose | Example Use |
|---|---|---|
| Bar Chart | Compare values across categories | Compare sales by region |
| Pie Chart | Show proportions or percentages | Show expense distribution |
| Line Chart | Show trends over time | Monthly temperature or profit trend |
| Column Chart | Similar to bar chart (vertical) | Compare exam scores |
| Area Chart | Emphasize total change over time | Cumulative growth visualization |
Note: For exam-level understanding, focus mainly on Bar, Pie, and Line charts.
Creating a Chart in Excel
Steps to Create Any Chart:
Select the data you want to visualize
Go to the Insert tab
Choose your chart type (Bar, Pie, or Line)
Customize using Chart Tools (titles, colors, legends, etc.)
Shortcut: Select your data → Press Alt + N + C → Insert chart instantly!
PYQs (Delhi Police – Computer Section)
Which type of chart is best suited for showing percentage distribution?
Category: Chart Types
Show Answer
Pie Chart
In Excel, which tab is used to insert a chart?
Category: Ribbon Navigation
Show Answer
Insert Tab
Which chart type is most useful to compare data of multiple items?
Category: Chart Types
Show Answer
Bar or Column Chart
What is the shortcut to quickly insert a chart in Excel?
Category: Shortcuts
Show Answer
Alt + F1 (or Alt + N + C)
A chart that shows trends or changes over time is —
Category: Chart Types
Show Answer
Line Chart
Excel Tricks for Charts
Double-click any chart element (title, bar, axis) to format instantly
Use F11 key to create a full sheet chart from selected data
Right-click → "Change Chart Type" to switch between chart styles quickly
Use contrasting colors for clarity during presentations or exams
Always label axes and title properly — it's a favorite MCQ area in exams!
Mini Assignment
Create a simple sales report of 4 products (Q1 to Q4 sales)
Requirements:
Additional Tasks:
- Add chart titles
- Include legends
- Add data labels neatly
- Format charts professionally
Recap
Bar Chart → Compare items
Pie Chart → Show percentages
Line Chart → Show trends over time
Insert charts via Insert Tab or Alt + F1 shortcut
Charts make data meaningful — and they're a regular PYQ topic in Delhi Police & SSC exams
Master Excel Charts for Delhi Police Exam!
Join Courage Library for comprehensive study materials and expert guidance.
Be a Couragian!