📊 Day 54: Charts & Graphs (MS Excel) – Hinglish
Charts & Graphs (MS Excel) – Hinglish
📌 Charts & Graphs kya hote hain?
Excel me data ko graphical form me dikhana = Charts / Graphs.
👉 Use:
Data ko easily samajhne ke liye
Comparison karne ke liye
Reports & presentations me
📈 Chart ke main types
1️⃣ Column Chart
👉 Data ko vertical bars me dikhata hai.
2️⃣ Bar Chart
👉 Data ko horizontal bars me dikhata hai.
3️⃣ Line Chart
👉 Data ko line me show karta hai (trend).
4️⃣ Pie Chart
👉 Data ko circle me percentage ke form me dikhata hai.
5️⃣ Area Chart
👉 Line chart jaisa hota hai, but filled area ke sath.
🛠️ Chart kaise create kare?
✅ Steps:
Excel me data select karo
Insert Tab → Charts group
Chart type choose karo (Column, Pie, Line etc.)
Chart automatically create ho jayega
🎨 Chart Formatting
👉 Options:
Chart Title change
Axis title add
Colors change
Chart Style apply
Legend add/remove
Steps:
Chart select → Chart Design / Format Tab
🧪 Example Data
| Name | Marks |
|---|---|
| Rahul | 80 |
| Priya | 90 |
| Amit | 70 |
| Neha | 60 |
👉 Task:
Column Chart banao
Pie Chart banao
🧠 Important Points (Exam ke liye)
✅ Chart = Data ka graphical presentation
✅ Insert Tab se chart banta hai
✅ Pie chart percentage show karta hai
🧪 Practice Task (Important)
👉 Excel me:
Ek marksheet banao
Column chart create karo
Chart ka title = "Student Marks" rakho
Chart ka color change karo
📝 Short Notes (Exam ke liye)
👉 Chart = Data ka graphical form
👉 Graph = Chart ka visual representation