Ungawakha kanjani i-PivotChart kusuka ku-PivotTable ku-Excel

Inkinga: Kukhona idatha kubanikeli abayizinkulungwane ezimbalwa kanye neminikelo yabo yonyaka. Ithebula lesifinyezo elakhiwe kusukela kule datha ngeke likwazi ukunikeza isithombe esicacile sokuthi yibaphi abanikeli abanikela kakhulu, noma bangaki abanikeli abanikela kunoma yisiphi isigaba.

Isinqumo: Udinga ukwakha ishadi le-pivot. Ukumelwa okuyisithombe kolwazi oluqoqwe ku-PivotTable kungaba usizo kuphrezentheshini ye-PowerPoint, kusetshenziswe emhlanganweni, embikweni, noma ekuhlaziyeni okusheshayo. I-PivotChart ikunikeza isifinyezo sedatha oyithandayo (njengeshadi elivamile), kodwa futhi iza nezihlungi ezisebenzisanayo ezisuka ku-PivotTable ezikuvumela ukuthi uhlaziye ngokushesha izingcezu ezihlukene zedatha.

Dala ishadi le-pivot

Ku-Excel 2013, ungakha i-PivotChart ngezindlela ezimbili. Esimweni sokuqala, sisebenzisa izinzuzo zethuluzi "Amashadi anconyiwe»ku-Excel. Ukusebenza ngaleli thuluzi, asikho isidingo sokuthi siqale sidale ithebula le-pivot ukuze kamuva sakhe ishadi le-pivot kulo.

Indlela yesibili ukwakha i-PivotChart kusuka ku-PivotTable ekhona, usebenzisa izihlungi nezinkambu esezakhiwe kakade.

Inketho 1: Dala Ishadi Le-Pivot Usebenzisa Ithuluzi Lamashadi Afakiwe

1. Khetha idatha ofuna ukuyibonisa eshadini.
2. Kuthebhu ethuthukisiwe Faka (Faka) esigabeni Imidwebo (Amashadi) chofoza Amashadi anconyiwe (Amashadi Anconyiwe) ukuze uvule ibhokisi Faka ishadi (Faka Ishadi).
3. Ibhokisi lengxoxo lizovuleka kuthebhu Amashadi anconyiwe (Amashadi Anconyiwe), lapho imenyu engakwesokunxele ibonisa uhlu lwezifanekiso zeshadi ezifanele. Ekhoneni eliphezulu kwesokudla sesithonjana sesifanekiso ngasinye, kunesithonjana seshadi le-pivot:
4. Chofoza kunoma yimuphi umdwebo osohlwini olunconyiwe ukuze ubone umphumela endaweni yokubuka kuqala.
5. Khetha uhlobo lweshadi olufanele (noma olucishe lufanele) bese uchofoza OK.

Ishidi elisha lizofakwa kwesokunxele seshidi ledatha, lapho kuzokwakhiwa khona i-PivotChart (kanye ne-PivotTable ehambisana nayo).

Uma ingekho imidwebo enconyiwe elingana, vala ibhokisi lengxoxo Faka ishadi (Faka Ishadi) bese ulandela izinyathelo EzikuKhetho 2 ukuze udale Ishadi Le-Pivot kusukela ekuqaleni.

Inketho yesi-2: Dala Ishadi Le-Pivot kusukela Kuthebula Le-Pivot Ekhona

1. Chofoza noma yikuphi ku-PivotTable ukuze uveze iqembu lamathebhu kuRibhoni Yemenyu Ukusebenza ngamathebula e-pivot (I-PivotTable Tools).
2. Kuthebhu ethuthukisiwe Analysis (Hlaziya) chofoza Ishadi le-Pivot (Ishadi Le-Pivot), lokhu kuzovula ibhokisi lengxoxo Yeshadi Le-Pivot. Faka ishadi (Faka Ishadi).
3. Ngakwesokunxele sebhokisi lengxoxo, khetha uhlobo lweshadi olufanele. Okulandelayo, khetha uhlobo oluncane lweshadi phezulu ewindini. Ishadi le-pivot lesikhathi esizayo lizoboniswa endaweni yokubuka kuqala.
4. Cindezela OKukuze ufake i-PivotChart eshidini elifanayo nele-PivotTable yasekuqaleni.
5. Uma i-PivotChart isidaliwe, ungenza ngendlela oyifisayo izici zayo nemibala usebenzisa uhlu lwezinkambu kumenyu ye-Ribbon noma izithonjana. Izakhi zeshadi (Izici Zeshadi) kanye Izitayela zeshadi (Izitayela Zeshadi).
6. Bheka ishadi le-pivot eliwumphumela. Ungaphatha izihlungi ngokuqondile eshadini ukuze ubone izingcezu ezihlukene zedatha. Kuhle, ngempela!