Chart Excel ka ek powerful tool hai jiska use data ko graphical form mein represent karne ke liye kiya jata hai. Chart ki help se large data ko numbers ki jagah visual form mein easily samjha aur compare kiya ja sakta hai.
“Chart Excel mein data ko graphical ya visual form mein present karne ka method hai, jisse data ko samajhna, compare karna aur analysis karna easy ho jata hai.”
Agar humare paas bahut saara numerical data ho, to sirf table dekhkar comparison karna difficult ho sakta hai.
Example:
| Month | Sales |
|---|---|
| January | ₹50,000 |
| February | ₹65,000 |
| March | ₹80,000 |
| April | ₹70,000 |
Chart banane par hume easily pata chal sakta hai ki kis month mein sales zyada ya kam thi.
Excel mein Chart ka use:
Excel mein different situations ke liye different Charts use kiye ja sakte hain:
| Chart Type | Main Use |
|---|---|
| Column Chart | Categories ka comparison |
| Bar Chart | Horizontal comparison |
| Line Chart | Time ke saath trend |
| Pie Chart | Total mein different parts ka share |
| Area Chart | Trend aur magnitude |
| Scatter Chart | Do numerical values ke relationship |
| Combination Chart | Do chart types ko combine karna |
Maan lijiye company ke paas:
Product Sales
Laptop ₹80,000
Mobile ₹60,000
Tablet ₹40,000
Printer ₹25,000
Is data ka Column Chart banane par products ki sales ko visually compare karna easy ho jayega.
Laptop ████████████████
Mobile ████████████
Tablet ████████
Printer █████
Ek Excel Chart mein commonly ye elements hote hain:
Chart kis data ke baare mein hai, ye batata hai.
Example:Monthly Sales Report
Chart mein data ko measure karne ke liye axes hoti hain.
Chart mein represent kiya gaya actual data.
Different data series ko identify karne mein help karta hai.
Chart ke points/bars ke saath actual values show kar sakte hain.
Chart ka main area jahan data graphical form mein दिखाई देता है.
Basic steps:
Step 1: Data select karein.
Step 2:
Go to:
Insert → Charts
Step 3: Required chart type select karein.
Example:
Insert → Column Chart
Step 4: Chart worksheet mein insert ho jayega.
Step 5: Chart Title, Legend aur Data Labels ko requirement ke according customize karein.
Student marks ka data:
| Subject | Marks |
|---|---|
| English | 75 |
| Maths | 85 |
| Computer | 90 |
| Excel | 88 |
Iska Column Chart banakar subjects ke marks ko easily compare kiya ja sakta hai.
Inventory report:
| Product | Stock |
|---|---|
| Laptop | 25 |
| Mouse | 80 |
| Keyboard | 50 |
| Printer | 15 |
Chart se quickly identify kiya ja sakta hai ki kis product ka stock zyada ya kam hai.
Leave a Reply