Momwe mungapangire PivotChart kuchokera pa PivotTable mu Excel

vuto: Pali zambiri za opereka zikwi zingapo ndi zopereka zawo zapachaka. Gome lachidule lomwe lapangidwa kuchokera ku deta iyi silingathe kufotokoza bwino lomwe opereka amapereka kwambiri, kapena ndi angati opereka ndalama omwe akupereka m'gulu lililonse.

Kusankha: Muyenera kupanga pivot chart. Chiwonetsero chazithunzi chazomwe zasonkhanitsidwa mu PivotTable zitha kukhala zothandiza pofotokoza za PowerPoint, kugwiritsidwa ntchito pamsonkhano, lipoti, kapena kusanthula mwachangu. PivotChart imakupatsani chithunzithunzi cha zomwe mukufuna (monga tchati chokhazikika), koma imabweranso ndi zosefera zolumikizana mwachindunji kuchokera ku PivotTable zomwe zimakulolani kusanthula mwachangu magawo osiyanasiyana a data.

Pangani tchati cha pivot

Mu Excel 2013, mutha kupanga PivotChart m'njira ziwiri. Poyamba, timagwiritsa ntchito zabwino za chida "Ma chart ovomerezeka»mu Excel. Pogwira ntchito ndi chida ichi, sitiyenera kupanga kaye tebulo la pivot kuti pambuyo pake tipange tchati cha pivot kuchokera pamenepo.

Njira yachiwiri ndikupanga PivotChart kuchokera ku PivotTable yomwe ilipo, pogwiritsa ntchito zosefera ndi minda yomwe idapangidwa kale.

Njira 1: Pangani PivotChart Pogwiritsa Ntchito Chida Chowonetsedwa

1. Sankhani deta yomwe mukufuna kuwonetsa patchati.
2. Pa Advanced tabu Ikani (Ikani) mu gawo Zithunzi (Matchati) dinani Ma chart ovomerezeka (Matchati Ovomerezeka) kuti mutsegule zokambirana Ikani tchati (Chotsani Tchati).
3. Bokosi la zokambirana lidzatsegulidwa pa tabu Ma chart ovomerezeka (Matchati Ovomerezeka), pomwe menyu kumanzere akuwonetsa mndandanda wa ma templates oyenera. Pakona yakumanja ya kachithunzi kakang'ono ka template iliyonse, pali chizindikiro cha pivot chart:
4. Dinani pa chithunzi chilichonse kuchokera pamndandanda wovomerezeka kuti muwone zotsatira mugawo lowoneratu.
5. Sankhani mtundu wa tchati woyenera (kapena pafupifupi woyenera) ndikudina OK.

Tsamba latsopano lidzayikidwa kumanzere kwa pepala la deta, pomwe PivotChart (ndi PivotTable yotsagana nayo) idzapangidwira.

Ngati palibe zithunzi zomwe zikuyenera kukwanira, tsekani bokosilo Ikani tchati (Lowetsani Tchati) ndipo tsatirani njira zomwe zili mu Njira 2 kuti mupange PivotChart kuyambira poyambira.

Njira 2: Pangani PivotChart kuchokera pa PivotTable yomwe ilipo

1. Dinani paliponse mu PivotTable kuti mubweretse gulu la ma tabu pa Menyu Riboni Kugwira ntchito ndi pivot tables (Zida za PivotTable).
2. Pa Advanced tabu Analysis (Yendetsani) dinani Tchati cha Pivot (Pivot Chart), izi zidzatsegula bokosi la zokambirana la Pivot Chart. Ikani tchati (Chotsani Tchati).
3. Kumanzere kwa bokosi la zokambirana, sankhani mtundu woyenera wa tchati. Kenako, sankhani mtundu wocheperako wa tchati pamwamba pazenera. Pivot tchati yamtsogolo iwonetsedwa mugawo lowoneratu.
4. Press OKkuti muyike PivotChart patsamba lomwelo ngati PivotTable yoyambirira.
5. PivotChart ikapangidwa, mutha kusintha mawonekedwe ake ndi mitundu yake pogwiritsa ntchito mndandanda wa magawo omwe ali pa Ribbon menyu kapena zithunzi. Ma chart a zinthu (Zinthu Zachati) ndi Masitayilo a ma chart (Masitayelo a Ma chart).
6. Onani tchati chotsatira. Mutha kuyang'anira zosefera mwachindunji pa tchati kuti muwone magawo osiyanasiyana a data. Ndizopambana, kwenikweni!