Yenza i-Pictograph kwi-Excel

I-pictograph isebenzisa imifanekiso ukumela idatha yeenombolo kwitshati okanye igrafu. Ngokungafani nemifanekiso eqhelekileyo, umfanekiso we-pictograph uquka imifanekiso ukubeka indawo yamakholomu enemibala okanye imivalo edlalwa ngokubanzi kwimiboniso, ebamba umdla wabaphulaphuli bakho ngokusebenzisa umbala nemifanekiso.

Yenza umboniso wakho olandelayo unomdla ngakumbi kwaye ulula ukuwuqonda ngokufaka i-pictograph kwi-Excel.

kwi http://www.inbox.com/article/how-do-create-pictograph-in-excel-2010.html

Kwidraftograph, imifanekiso ithatha indawo yamacolomns okanye imivalo ekhompyutheni yemibala okanye ibrafu. Le tutorial iquka indlela yokutshintsha ibrafu elula yegrafu kwi-pictographic kwi-Microsoft Excel.

Izifundo ezihambelanayo: Yakha i-Pictograph kwi-Excel 2003

Amanyathelo okufundisa a:

• Inyathelo 1: Yakha igrafu yebar kwi-Excel
  
• Inyathelo 2: Khetha uchungechunge olulodwa lweedatha kwigrafu
  
• Inyathelo 3: Ukongeza umfanekiso kwi-Pictograph
  
• Inyathelo 4: Iinkcukacha zeTutorial

01 ngo 04

Umzekelo we-Pictograph Isinyathelo soku-1: Yenza igrafu yeBhara

1. Ukugqiba le nyathelo ngesifundo senqanaba, engeza idatha efunyenwe kwisinyathelo 4 kwiSpredishithi ye-Excel 2007.
   
2. Hudula ukhetha iiseli A2 ukuya kwi-D5.
   
3. Kwi-Ribbon, khetha Faka Faka> Ikholamu> I-Column e-2-d eneklasi .

Isalathisi yesalathisi esisiseko idalwe kwaye ifakwe kwiphepha lakho lokusebenzela.

02 we 04

Umzekelo we-Pictograph Isinyathelo 2: Khetha iSahlulo seDatha esisodwa

Ukuze uncede ngale nqanaba, jonga umfanekiso ongentla.

Ukwenza i-pictograph kufuneka ufake indawo yefayile yefayile ngokugcwalisa umbala webar nganye yedata kwigrafu.

1. Nqakraza ngakwesinye semibhobho yedatha eluhlaza kwigrafu uze ukhethe Iifomathi zoLwazi lweeFomathi ukusuka kwimenyu yomongo.
   
2. Ibhokisi elingentla elingenayo livula ibhokisi yencoko yababini yoCwangciso lweDatha .

03 we 04

Umzekelo we-Pictograph Isinyathelo sesi-3: Ukongeza umfanekiso kwi-Pictograph

Ukuze uncede ngale nqanaba, jonga umfanekiso ongentla.

Kwibhokisi yencoko yababini yoCwangciso lweDatha evuliwe kwisinyathelo 2:

1. Cofa kwiIfayile yokugcwalisa kwiwindow yokunxele ukufikelela kwiinketho zokuzalisa ezikhoyo.
   
2. Kwiwindow yesandla sokunene, nqakraza kwiSithombe okanye ukhetho lokugcwalisa .
   
3. Cofa kwiqhosha le- Clip Art ukuvula iwindow Khetha yefayile .
   
4. Thayipha "cookie" kwiBhokisi yombhalo we-Search kwaye cinezela iqhosha laseGo ukuya kubona i-clip art ekhoyo.
   
5. Cofa kumfanekiso ukusuka kulabo bafumanekayo kwaye cinezela iqhosha le- OK ukulikhetha.
   
6. Cofa kwiStack inketho phantsi kweqhosha lobugcisa beklip.
   
7. Cinezela iqhosha elivaliweyo phantsi kwebhokisi yencoko yababini ukubuyela kwigrafu yakho.
   
8. Imivalo eluhlaza okwesibhakabhaka kwigrafu kufuneka ithathelwe indawo kunye nekiso lwecookie ekhethiweyo.
   
9. Phinda uphawule amanyathelo angentla apha ukuba utshintshe enye imivalo kwigrafu ukuya kwimifanekiso.
   
10. Xa ugqityiwe, i-pictograph yakho ifane nomzekelo kwiphepha 1 yale khokelo.

04 we 04

Idatha yeTutorial

Ukuze ulandele le khosi, faka idatha engentla apha kwi-spreadsheet ye-Excel ukususela kwi-cell A3.