Excel Chart mein Switch Row/Column feature ka use chart mein data ki orientation change karne ke liye kiya jata hai.
Iska matlab hai ki jo data pehle Rows ke according chart mein represent ho raha tha, use Columns ke according represent kiya ja sakta hai — aur vice versa.
Switch Row/Column Excel ka ek chart feature hai jiska use chart mein Rows aur Columns ke beech data representation ko change karne ke liye kiya jata hai.
Suppose hamare paas ye data hai:
| Month | Laptop | Mobile | Tablet |
|---|---|---|---|
| January | 50 | 70 | 40 |
| February | 60 | 80 | 45 |
| March | 75 | 65 | 55 |
Agar normal chart banaya jaye, to Excel ek particular orientation ke according data ko series aur categories mein divide karega.
Data ki interpretation change ho sakti hai:
Before Switch:
After Switch:
Isse same data ka different comparison view milta hai.
Chart select karne ke baad:
Chart Design → Switch Row/Column
par click karein.
Excel automatically chart ki rows aur columns ki interpretation switch kar deta hai.
Excel mein apna data enter karein.
Data select karke chart create karein.
Chart par click karein.
Ribbon mein Chart Design tab open karein.
Switch Row/Column option par click karein.
Chart ka data orientation automatically change ho jayega.
| Month | Online | Offline |
|---|---|---|
| Jan | ₹40,000 | ₹30,000 |
| Feb | ₹50,000 | ₹35,000 |
| Mar | ₹65,000 | ₹45,000 |
| Apr | ₹70,000 | ₹50,000 |
Categories: Jan, Feb, Mar, Apr
Series:
Yaani hum month-wise Online vs Offline sales compare kar rahe hain.
Chart ki interpretation change ho sakti hai:
Categories:
Series:
Ab hum Online aur Offline ke against monthly values dekh sakte hain.
Is feature ka main purpose hai:
Agar chart banane ke baad lage ki:
“Mera chart categories aur series ko ulte way mein show kar raha hai.”
Tab Switch Row/Column use kar sakte hain.
Aapke paas:
Month × Product Sales
data hai.
Aap pehle:
Month-wise Product Comparison
dekh rahe hain.
Switch Row/Column ke baad:
Product-wise Monthly Comparison
dekh sakte hain.
| Before Switch | After Switch |
|---|---|
| Rows data series ho sakti hain | Columns data series ho sakte hain |
| Columns categories ho sakti hain | Rows categories ho sakti hain |
| One type of comparison | Different comparison view |
| Data orientation 1 | Data orientation 2 |
Important: Exact result chart ke data structure par depend karta hai.
Month-wise vs Product-wise sales comparison.
Student-wise vs Subject-wise marks comparison.
Month-wise vs Expense-type analysis.
Product-wise vs Month-wise stock analysis.
Department-wise vs Month-wise employee data.
Switch Row/Column data ko delete, move ya modify nahi karta.
Ye sirf chart ke presentation/interpretation ko change karta hai.
Original worksheet ka data same rehta hai.
Original data:
Jan | Laptop | ₹50,000
Switch Row/Column karne se worksheet mein ₹50,000 ki value change nahi hogi. Sirf chart mein data kis direction/category-series ke according display hoga, woh change hoga.
Leave a Reply