Hello friends, aaj me aapko advance excel me INSERT CHART function ke baare me batane jaa raha hu. Chart ek esa function hai jiski help se hum data ko graphically communicate kar sakte hai. Aur 11 types (Column, Line, Pie, Bar, Area, Scatter, Stock, Surface, Doughnut, Bubble, Radar) ke use se apne data ko chart me present kar sakte hai. Aur audience ko comparison karne me help milti hai. Chaliye dosto ek symple aur primary table ke according dekhte hai ki iska use kaise karte hai.

Insert Chart Ka Use Kaise Kare Advance Excel Me

 

Step 1

Chart banane ke liye sabse pehle workshet me ek table banaye jaisa ki niche image me dekh sakte hai ki student name aur unke total marks.

 

Step 2

Table ko select kare aur insert function click karke apne hisab se chart ki style choose kare aur ok button press kare. Iske baad image me chart show ho jayega jaisa image me dekh sakte hai.

Shortcuts:-
Table me click karke F11 ya phir Alt+F1 karne se chart generate ho jayega.

 

Chart Ko Resize Kaise Kare

Niche diye gaye tariko me se kisi se bhi aap chart ko apne according resize kar sakte hai.

Manual Re-Size

Size ko manually change karne ke liye chart par click kare aur jo size aap chahte hai usse set karne ke liye size handles ko upar niche drag kare.

Specific Re-Size

Specific size aur measurement ke liye chart par right click karne se format tab open hoga ab Format chart area option choose kare, yaha par aap apne according chart ko resize kar sakte hai, shape hight aur shape width box me size dal kar chart ko bada aur chhota kar sakte hai.

Format tab se chart ko cut, copy, paste, move aur font style etyadi ko hum apne according set kar sakte hai.

Hope aap samajh gaye honge ki advance excel me insert chart ka use kaise karte hai. Phir bhi koi doubt ho to comment karke puch sakte ho. Aur agar aapko ye post acchi lagi ho to niche share button par click karke apne dosto ke sath share jaroor kare.