Dala i-Pictograph ku-Excel

I-pictograph isebenzisa izithombe ukumela idatha yamanani eshadini noma igrafu. Ngokungafani nemidwebo ejwayelekile, i-pictograph ifaka izithombe ukufaka esikhundleni samakholomu ezinemibala noma imigoqo evame ukubonwa ekubonisweni, ukubamba isithakazelo sethameli zakho ngokusebenzisa umbala nezithombe.

Yenza isethulo sakho esilandelayo sibe mnandi kakhulu futhi kulula ukuyiqonda ngokufaka i-pictograph ku-Excel.

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

Ku-pictograph, izithombe zifaka esikhundleni samakholomu ezinemibala noma imigoqo eshadini elivamile lekholomu noma ibrafu yebha. Lesi sifundo sihlanganisa indlela yokushintsha igrafu elula yebha yegraphy e-Microsoft Excel.

Ukufundisa okuhlobene: Dala i-Pictograph ku-Excel 2003

Izinyathelo zokufundisa ziyi:

• Isinyathelo 1: Yakha igrafu ye-bar ku-Excel
  
• Isinyathelo 2: Khetha uchungechunge olulodwa lwedatha kugrafu
  
• Isinyathelo sesi-3: Ukungeza isithombe ku-Pictograph
  
• Isinyathelo 4: Idatha yokufundisa

01 ngo-04

Isibonelo se-Pictograph Isinyathelo soku-1: Dala igrafu yebha

1. Ukuqedela lesi sinyathelo ngesinyathelo sesifundo, engeza idatha etholakala esiteji 4 ku-spreadsheet ye-Excel 2007.
   
2. Hudula ukhethe amaseli A2 kuya ku-D5.
   
3. Ebhebheni, khetha Faka> Ikholomu> Ikholomu ehlanganisiwe engu-2-d .

Ishadi lamakholomu eyisisekelo lidalwa futhi lifakwe ekhasini lakho lokusebenzela.

02 ka 04

Isibonelo se-Pictograph Isinyathelo sesi-2: Khetha u-Series Single Data Series

Ukuze uthole usizo ngalesi sinyathelo, bheka isithombe esingenhla.

Ukudala i-pictograph udinga ukufaka ifayela lesithombe ukuze ugcwalise umbala ngamunye wamatayela wegrafu.

1. Chofoza ngakwesokudla kweminye imishayo yedatha eluhlaza okwesibhakabhaka kugrafu bese ukhetha I- Format Data Series kusukela kumenyu yokuqukethwe.
   
2. Isinyathelo esingenhla sivula ibhokisi lengxoxo ye- Format Data Series .

03 ka 04

Isibonelo se-Pictograph Isinyathelo sesi-3: Ukungeza isithombe ku-Pictograph

Ukuze uthole usizo ngalesi sinyathelo, bheka isithombe esingenhla.

Esikhathini sebhokisi lengxoxo ye- Format Data Series esivuliwe esinyathelweni sesi-2:

1. Chofoza kuzinketho zokugcwalisa ngakwesokunxele ukuze ufinyelele izinketho zokugcwalisa ezitholakalayo.
   
2. Ewindini lokunene, chofoza ku- Isithombe noma ukhetho lokugcwalisa .
   
3. Chofoza inkinobho ye- Clip Art ukuvula iwindi le- Picture Picture .
   
4. Thayipha "ikhukhi" ku-Ibhokisi lokusesha bese ucindezela inkinobho ye- Go ukuze ubone izithombe ze-clip art etholakalayo.
   
5. Chofoza esithombeni kusuka kulabo abatholakalayo bese ucindezela inkinobho OK ukuze ukhethe.
   
6. Chofoza inketho ye- Stack ngezansi inkinobho yobuciko bokunamathisela.
   
7. Cindezela inkinobho Evale phansi ebhokisini lengxoxo ukuze ubuyele kumagrafu wakho.
   
8. Imigoqo eluhlaza okwesibhakabhaka egrafu kufanele ishintshwe ngesithombe sekhukhi esikhethiwe.
   
9. Phinda izinyathelo ezingenhla ukuze ushintshe enye imigoqo egrafu ezithombeni.
   
10. Uma usuqedile, isithombe sakho se-pictograph kufanele sifane nesibonelo ekhasini 1 salesi sifundo.

04 ka 04

Idatha yokufundisa

Ukuze ulandele le tutorial, engeza idatha engenhla kwispredishithi se-Excel esuka kuseli A3.