Shintsha isihloko se-turntable

Kulula kakhulu ukushintsha isihloko sethebula le-pivot ku-Microsoft Excel. Ngezansi uzothola izinyathelo zokushintsha isihloko Sethebula Le-Pivot, kanye nezithombe-skrini ezihambisanayo.

Hlela isihloko sethebula le-pivot

Ngaso sonke isikhathi uma udala ithebula le-pivot, i-Microsoft Excel ngokuzenzakalelayo iliqamba ngokuthi i-PivotTable1 futhi ithebula le-pivot elilandelayo olidalayo limane liqanjwe ngokuthi PivotTable2.

Esikhundleni sokulandela le ngqungquthela yokuqamba amagama, ungashintsha isihloko se-Pivot Desk sibe okuthile okubalulekile nokuhlobene nolwazi lweDeski le-Pivot.

Isibonelo, amathebula e-pivot anamagama athi “Isamba Sokuthengisa NgoJanuwari” noma “Isamba Sentengiso Ngenyanga” abonakala enengqondo kunamagama azenzakalelayo akhiqizwa i-Excel (PivotTable1 kanye ne-PivotTable2)

Enye inzuzo yokusetha amagama amisiwe amathebula e-pivot ukuthi ungawabhekisela embhalweni nasekubhalweni ngekhodi okuyisisekelo okubonwayo.

Izinyathelo zokushintsha isihloko sethebula le-pivot

Njengoba sesishilo, kulula kakhulu ukushintsha isihloko sethebula le-pivot ku-Microsoft Excel.

1. Chofoza kahle noma kuphi ku- Turntable , bese uchofoza ku -PivotTable Selection… kumenyu evelayo.

2. Esikrinini se-Pivoting Desktop Options, chofoza inkambu elandelayo: Pivoting Desktop Title , bese ufaka isihloko esisha sehhovisi lakho eliphakathi. Esimweni sethu, manje sibiza ihhovisi lethu eliphakathi ngokuthi "uJanuwari Gross Sales by Retailer".

3. Uma usuqedile, cindezela inkinobho yegundane ethi OK ukuze ungachithi lolu hlobo lokushintsha.

• Engeza noma susa amanani angaphansi kokuthi Ideskithophu Le-Pivoting