Column Chart Excel ka ek popular chart type hai jiska use different categories ke data ko vertical columns (bars) ke through compare karne ke liye kiya jata hai.
Har category ki value ek vertical column ke form mein show hoti hai. Column jitna bada hoga, value utni zyada hogi.
Column Chart ek graphical chart hai jisme data ko vertical columns ke through represent karke different categories ke values ko easily compare kiya jata hai.
Column Chart ka main purpose hai:
Easy Trick:
Category + Comparison = Column Chart
Suppose ek shop ki different products ki sales hain:
| Product | Sales |
|---|---|
| Laptop | ₹1,20,000 |
| Mobile | ₹90,000 |
| Tablet | ₹60,000 |
| Printer | ₹40,000 |
Is data ko Column Chart mein represent karne par har product ka ek vertical column hoga.
Is chart se ek glance mein pata chal jata hai ki Laptop ki sales sabse zyada aur Printer ki sales sabse kam hai.
Column Chart tab use karna useful hota hai jab humein different categories ki values ka comparison karna ho.
Horizontal axis hoti hai.
Ye generally categories show karti hai.
Example:
Laptop | Mobile | Tablet | Printer
Vertical axis hoti hai.
Ye numerical values show karti hai.
Example:
₹20,000 | ₹40,000 | ₹60,000…
Vertical bars/columns actual values represent karte hain.
Chart ka purpose batata hai.
Example:
Product Sales Comparison
Multiple data series hone par identify karta hai ki kaunsa data kis series ka hai.
Columns ke upar actual values display kar sakte hain.
Data ko proper table mein enter karein.
Example:
| Student | Marks |
|---|---|
| Aman | 75 |
| Ravi | 82 |
| Neha | 90 |
| Priya | 68 |
Complete data range select karein.
Insert → Charts → Column Chart
Required Column Chart type select karein.
Chart Title add karein.
Example:
Student Marks Comparison
Zarurat ke according:
add karein.
Excel mein Column Charts ke different types available hote hain:
| Type | Use |
|---|---|
| Clustered Column | Categories ka simple comparison |
| Stacked Column | Multiple values ko ek column mein stack karna |
| 100% Stacked Column | Percentage/share comparison |
| 3-D Column | Visual presentation ke liye |
Clustered Column Chart normal category comparison ke liye sabse commonly used type hai.
Clustered Column Chart mein different categories ke columns side-by-side show hote hain.
Example:
| Product | 2025 Sales | 2026 Sales |
|---|---|---|
| Laptop | ₹80,000 | ₹1,20,000 |
| Mobile | ₹70,000 | ₹90,000 |
| Tablet | ₹50,000 | ₹60,000 |
Is chart se 2025 aur 2026 ki sales ko product-wise compare kar sakte hain.
Stacked Column Chart mein multiple data series ek hi column ke andar stack hoti hain.
Example:
Total Sales = Online Sales + Offline Sales
Isse total ke saath-saath uske different parts bhi samajhne mein help milti hai.
Suppose ek student ke subjects ke marks hain:
| Subject | Marks |
|---|---|
| English | 75 |
| Maths | 88 |
| Computer | 92 |
| Excel | 85 |
| Hindi | 70 |
Column Chart se easily identify kar sakte hain:
Column Chart business reports mein bahut useful hai.
Product-wise sales compare karna.
Different months ka revenue compare karna.
Department-wise employee count show karna.
Different products ki stock quantity compare karna.
Different cities/branches ki sales compare karna.
Different teams ya employees ki performance compare karna.
| Column Chart | Line Chart |
|---|---|
| Categories compare karta hai | Trends/changes show karta hai |
| Vertical columns use karta hai | Lines use karta hai |
| Product comparison ke liye useful | Time-based trend ke liye useful |
| Highest/lowest value easily identify hoti hai | Increase/decrease movement easily visible hoti hai |
| Example: Product Sales | Example: Monthly Sales Trend |
Column Chart → Compare
Line Chart → Trend
✅ Data comparison easy hota hai
✅ Highest aur lowest value easily identify hoti hai
✅ Data visually attractive lagta hai
✅ Business reports ke liye useful
✅ Student performance compare kar sakte hain
✅ Multiple categories compare ki ja sakti hain
✅ Presentations ko professional banata hai
Leave a Reply