Shaxanada Pivot^(Pivot) waa hab horumarsan oo lagu habeeyo xogta habaysan iyo isticmaalka qaacidooyinka Microsoft Excel . Waxaan u adeegsan karnaa qaacidooyin gooni-gooni ah marka loo eego safafka iyo tiirarka laakiin marka lagu daro ama la tirtiro safafka qaaciidooyinkani way xumaadaan. Tani waa halka laga isticmaalo miisaska pivot.

Sida loo sameeyo miiska Pivot^{(Pivot Table)} gudaha Excel

Ugu horreyntii^(First) , waxaad u baahan doontaa xog urursan oo safafka iyo tiirarka lagu habeeyay. Tusaale ahaan. Liisaska buundooyinka ay keeneen ardayda maadooyinka kala duwan. Ka soo qaad inaad u baahan tahay wadarta guud ee buundada arday kasta ee maaddooyinka safka u dambeeya. Waxaad isticmaali kartaa qaacido oo u jiid unugyada adiga oo isticmaalaya shaqada Buuxinta^(Fill) , laakiin taasi waxay faa'iido yeelan doontaa oo keliya ilaa safafka iyo tiirarka aan la beddelin.

Si loo sameeyo miiska pivot, nidaamku waa sida soo socota:

1. Dooro tirada unugyada.
2. Guji Gelida^(Insert) oo dooro Shaxda Pivot^{(Pivot Table)} .
3. Sida caadiga ah, kala duwanaanta miiska ayaa lagu xusi doonaa oo miiska pivot wuxuu ku furmayaa warqad shaqo oo cusub. Sidaa u dhig oo dooro OK.
4. Warqad shaqo oo cusub oo leh Shaxda Pivot^{(Pivot Table)} ayaa la abuuri doonaa.
5. Waraaqda shaqada ee leh miiska pivot, waxaad dooran kartaa tiirarka wadarta ama wadarta guud ee aad u baahan tahay.

Kiiska aan kor ku soo sheegnay waa mid guud oo aad uga baahan tahay wadarta qiyamka tiir keliya ee safka u dambeeya.

Haddii aad rabto inaad wax ka beddesho, fadlan adeegso ikhtiyaarka loogu talagalay miisaska Pivot^{(Pivot Tables)} ee lagu taliyay ee hoos yimaada tabka^(Insert) Gelida.

Akhri^(Read) :  Sida loo beddelo midabka warqadda shaqada ee Excel.^{(How to change the color of the Excel worksheet Tab.)}

Sida loo sameeyo jaantuska Pivot^{(Pivot Chart)} gudaha Excel

Markaad abuurto miiska Pivot^{(Pivot Table)} , waxaad samayn kartaa jaantuskiisa^{(make a Chart)} . Nidaamku waa sida soo socota:

Ka dooro tirada unugyada ee ku yaal miiska Pivot^{(Pivot Table)} .

Tag Gelida^(Insert) oo hoosta qaybta Charts , dooro jaantuska Pivot^{(Pivot Chart)} .

Dooro nooca jaantuska aad rabto inaad isticmaasho oo ku dhufo OK .

Noo soo sheeg haddii aad wax shaki ah ka qabto qaybta faallooyinka.

Hadda akhri^{(Now read)} : Sida loo isticmaalo SUMIF iyo SUMIFS Functions gudaha Microsoft Excel^{(How to use SUMIF and SUMIFS Functions in Microsoft Excel)} .

How to create a Pivot Table and Pivot Chart in Excel

Pivot tables are an advanced method of arranging organized data аnd using formulae in Microsoft Excel. We could use standalone formulae over rows and columns but upon adding or deleting rows these formulae get corrupted. This is where pivot tables come into use.

How to create a Pivot Table in Excel

First of all, you would need a set of data arranged across rows and columns. Eg. The lists of marks scored by students in various subjects. Assume that you need the total of each student’s mark in all the subjects in the last row. You could use a formula and pull it across the cells using the Fill function, but that would be useful only till the rows and columns are not changed.

To create a pivot table, the procedure is as follows:

1. Select the range of cells.
2. Click on Insert and select Pivot Table.
3. By default, the table range will be mentioned and the pivot table would open in a new worksheet. Keep it that way and select OK.
4. A new worksheet with the Pivot Table would be created.
5. In the worksheet with the pivot table, you can select the columns for the sum or grand total you would need.

The case mentioned above is a generic one where you need the sums of values in a single column in the last row.

In case you wish to make modifications, please use the option for recommended Pivot Tables under the Insert tab.

Read: How to change the color of the Excel worksheet Tab.

How to create a Pivot Chart in Excel

Once you have created the Pivot Table, you can make a Chart of it. The procedure is as follows:

Select the range of cells across the Pivot Table.

Go to Insert and under the section for Charts, select Pivot Chart.

Select the type of chart you wish to use and hit OK.

Let us know if you have any doubts in the comments section.

Now read: How to use SUMIF and SUMIFS Functions in Microsoft Excel.

Related posts

• Sida Loo Sameeyo Shaxda Pivot Fudud ee Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo abuuro Graph Bar ama Shaxda Saxiixa ee Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo sameeyo jaantuska xariiqda iyo garaafka firdhiya ee sawirka gudaha Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo sameeyo shaxda Pie ee Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog