Maitiro ekugadzira PivotChart kubva kuPivotTable muExcel

Problem: Pane data pamusoro pezviuru zvevanopa uye zvipo zvavo zvepagore. Tafura yepfupiso yakavakwa kubva pane iyi data haigone kupa mufananidzo wakajeka wekuti ndevapi vanopa vari kupa zvakanyanya, kana vangani vanopa vari kupa mune chero chikamu chakapihwa.

Sarudzo: Iwe unofanirwa kugadzira pivot chati. Mufananidzo wakajeka weruzivo rwunounganidzwa muPivotTable inogona kubatsira kune PowerPoint mharidzo, kushandiswa mumusangano, mushumo, kana kukurumidza kuongorora. A PivotChart inokupa mufananidzo weiyo data yekufarira (senge yenguva dzose chati), asi inouyawo nemafirita anodyidzana akananga kubva kuPivotTable iyo inokutendera iwe kukurumidza kuongorora zvidimbu zvakasiyana zve data.

Gadzira pivot chati

MuExcel 2013, unogona kugadzira PivotChart nenzira mbiri. Muchiitiko chekutanga, isu tinoshandisa zvakanakira chishandiso "Machati anokurudzirwa»muExcel. Tichishanda nechishandiso ichi, hatidi kutanga tagadzira tafura yepivot kuitira kuti gare gare tivake pivot chati kubva mairi.

Yechipiri nzira ndeyekugadzira PivotChart kubva kune iripo PivotTable, uchishandisa mafirita neminda yakatogadzirwa.

Sarudzo 1: Gadzira PivotChati Uchishandisa Iyo Inoratidzirwa Machati Turu

1. Sarudza iyo data yaunoda kuratidza muchati.
2. Pa Advanced tabo Insert (Isa) muchikamu Mifananidzo (Machati) tinya Machati anokurudzirwa (Machati anokurudzirwa) kuvhura nhaurirano Isa chati (Isa Chati).
3. Iyo dialog box ichavhura pane tab Machati anokurudzirwa (Machati Anokurudzirwa), apo menyu iri kuruboshwe inoratidza runyoro rwematemplate echati akakodzera. Mukona yepamusoro yekurudyi yechigunwe chetemplate yega yega, pane pivot chart icon:
4. Dzvanya pane chero dhayagiramu kubva pane yakakurudzirwa runyorwa kuti uone mhedzisiro munzvimbo yekutarisa.
5. Sarudza chakakodzera (kana chinenge chakakodzera) chati yerudzi uye tinya OK.

Bepa idzva richaiswa kuruboshwe rwebepa re data, painogadzirwa PivotChart (uye inoperekedza PivotTable).

Kana pasina rimwe remadhayagiramu anokurudzirwa rinokwana, vhara dialog box Isa chati (Isa Chati) uye tevera matanho ari muSarudzo 2 kugadzira PivotChart kubva kutanga.

Sarudzo yechipiri: Gadzira PivotChati kubva kune iripo PivotTable

1. Dzvanya pese paPivotTable kuti uunze boka rematebhu paMenu Ribhoni Kushanda nematafura epivot (PivotTable Tools).
2. Pa Advanced tabo ongororo (Ongorora) tinya Pivot Chati (Pivot Chati), izvi zvinovhura iyo Pivot Chati dialog box. Isa chati (Isa Chati).
3. Kurutivi rworuboshwe rwebhokisi rehurukuro, sarudza mhando yechati yakakodzera. Tevere, sarudza subtype yechati kumusoro kwehwindo. Iyo remangwana pivot chati icharatidzwa munzvimbo yekutarisa.
4. dzvanya OKkuisa PivotChart papepa rimwechete nePivotTable yepakutanga.
5. Kana PivotChart yagadzirwa, unogona kugadzirisa zvinhu zvayo uye mavara uchishandisa rondedzero yeminda paRibhoni menyu kana zvidhori. Chati zvinhu (Chati Zvinhu) uye Zvitaera zvechati (Chati Zvitaera).
6. Tarisa pane chabuda pivot chati. Iwe unogona kubata mafirita zvakananga pane chati kuti uone akasiyana zvidimbu zve data. Zvakanaka, chaizvo!