Yadda ake ƙirƙirar PivotChart daga PivotTable a cikin Excel

matsala: Akwai bayanai kan masu ba da gudummawa dubu da yawa da gudummawar su na shekara-shekara. Teburin taƙaitaccen bayani da aka gina daga wannan bayanan ba zai iya ba da cikakken hoto na waɗanda masu ba da gudummawa suka fi ba da gudummawar ba, ko adadin masu ba da gudummawar ke bayarwa a kowane nau'i.

Yanke shawara: Kuna buƙatar gina taswirar pivot. Hoton hoto na bayanan da aka tattara a cikin PivotTable na iya zama da amfani ga gabatarwar PowerPoint, amfani da shi a cikin taro, a cikin rahoto, ko don bincike mai sauri. A PivotChart yana ba ku hoton bayanan ban sha'awa (kamar ginshiƙi na yau da kullun), amma kuma yana zuwa tare da masu tacewa kai tsaye daga PivotTable wanda ke ba ku damar bincika sassa daban-daban na bayanan da sauri.

Ƙirƙiri taswirar pivot

A cikin Excel 2013, zaku iya ƙirƙirar PivotChart ta hanyoyi biyu. A cikin yanayin farko, muna amfani da fa'idodin kayan aiki "Shafukan da aka ba da shawarar» a cikin Excel. Yin aiki tare da wannan kayan aikin, ba ma buƙatar fara ƙirƙirar tebur pivot domin daga baya mu gina taswirar pivot daga gare ta.

Hanya ta biyu ita ce ƙirƙirar PivotChart daga PivotTable data kasance, ta amfani da filtata da filayen da aka riga aka ƙirƙira.

Zabin 1: Ƙirƙiri PivotChart Ta Amfani da Kayan Aikin Haruffa da Aka Fito

1. Zaɓi bayanan da kuke son nunawa a cikin ginshiƙi.
2. A kan Babba shafin Saka (Saka) a cikin sashe Diagrams (Charts) danna Shafukan da aka ba da shawarar (Shawarwarin Charts) don buɗe maganganun Saka ginshiƙi (Saka Chart).
3. Akwatin maganganu zai buɗe akan shafin Shafukan da aka ba da shawarar (Shawarwarin Charts), inda menu na hagu yana nuna jerin samfuran ginshiƙi masu dacewa. A kusurwar dama ta sama na ɗan yatsa na kowane samfuri, akwai gunkin ginshiƙi mai tushe:
4. Danna kowane zane daga lissafin da aka ba da shawarar don ganin sakamako a yankin samfoti.
5. Zaɓi nau'in ginshiƙi mai dacewa (ko kusan dacewa) kuma danna OK.

Za a saka sabon takardar zuwa hagu na takardar bayanan, wanda akansa za'a ƙirƙiri PivotChart (da rakiyar PivotTable).

Idan babu ɗayan zane-zanen da aka ba da shawarar da ya dace, rufe akwatin maganganu Saka ginshiƙi (Saka Chart) kuma bi matakai a Zabin 2 don ƙirƙirar PivotChart daga karce.

Zabin 2: Ƙirƙiri PivotChart daga PivotTable da ke da

1. Danna ko'ina a cikin PivotTable don kawo rukunin shafuka akan Ribbon Menu Yin aiki tare da tebur pivot (Kayan aikin PivotTable).
2. A kan Babba shafin analysis (Bincike) danna Ginshiƙi mai mahimmanci (Pivot Chart), wannan zai buɗe akwatin maganganu na Pivot Chart. Saka ginshiƙi (Saka Chart).
3. A gefen hagu na akwatin maganganu, zaɓi nau'in ginshiƙi mai dacewa. Na gaba, zaɓi nau'in ginshiƙi a saman taga. Za a nuna taswirar pivot na gaba a yankin samfoti.
4. latsa OKdon saka PivotChart akan takarda ɗaya da ainihin PivotTable.
5. Da zarar an ƙirƙiri PivotChart, za ku iya keɓance abubuwansa da launuka ta amfani da jerin filaye akan menu na Ribbon ko gumaka. Abubuwan da aka tsara (Chart Elements) и Salon ginshiƙi (Chat Styles).
6. Dubi ginshiƙi mai fitowa. Kuna iya sarrafa matattara kai tsaye akan ginshiƙi don ganin sassa daban-daban na bayanan. Yana da kyau, da gaske!