Pangani Pictograph mu Excel

Chithunzi chojambula chimagwiritsa ntchito zithunzi kuti ziyimirire deta pamndandanda kapena graph. Mosiyana ndi mizere yeniyeni, zithunzi zojambulajambula zimaphatikizapo zithunzi kuti zitsatire mazithunzi kapena mabala obiriwira omwe amawoneka pazomwe akuwonetsera, kutenga chidwi cha omvetsera anu pogwiritsa ntchito mtundu ndi zithunzi.

Pangani nkhani yanu yotsatira kukhala yosangalatsa komanso yosavuta kumvetsetsa mwa kuphatikizapo zithunzi zojambula mu Excel.

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

Mu zithunzi zojambulajambula, zithunzi zimalowetsa zipilala zamitundu kapena mipiringidzo muzithunzi zam'ndandanda zamatabwa. Phunziro ili likukhudza momwe mungasinthire galafa losavuta kujambula pazithunzi za Microsoft Excel.

Maphunziro ofanana: Pangani Pictograph mu Excel 2003

Maphunziro a phunziroli ndi awa:

• Khwerero 1: Pangani bar graph ku Excel
  
• Khwerero 2: Sankhani zojambulazo chimodzi pazithunzi
  
• Gawo 3: Kuwonjezera Chithunzi ku Pictograph
  
• Gawo 4: Zophunzitsira Zophunzitsa

01 a 04

Chithunzi cha Pictograph Khwerero 1: Pangani Girafa la Bar

1. Kuti mutsirizitse masitepe awa, yonjezerani deta yomwe imapezeka pa step 4 ku Excel 2007 spreadsheet.
   
2. Kokani osankha maselo A2 mpaka D5.
   
3. Pakaboni, sankhani Insert> Column> 2-d yokhala ndi Phukusi .

Chithunzi chachinsinsi chadongosolo chimayikidwa ndikuyikidwa pa tsamba lanu.

02 a 04

Pictograph Chitsanzo Chachiwiri: Sankhani Single Data Series

Pothandizidwa ndi sitepe iyi, onani chithunzi pamwambapa.

Kuti mupange pepalagraph muyenera kuikapo fayilo ya chithunzi kuti muzitha kujambula pazithunzi zonse zam'majambula.

1. Dinani pamanja pazithunzi zamtundu wa blue pa graph ndi kusankha Format Data Series kuchokera mndandanda wa menyu.
   
2. Khwerero ili pamwamba likutsegula bokosi la Format Data Series .

03 a 04

Chithunzi cha Pictograph Khwerero 3: Kuwonjezera Chithunzi ku Pictograph

Pothandizidwa ndi sitepe iyi, onani chithunzi pamwambapa.

Mu bokosi la Format Data Series linatsegulidwa pagawo 2:

1. Dinani pa Zodzaza zosankha muwindo lamanzere kuti mupeze zotsatila zotsatila.
   
2. Muwindo lamanja, dinani pa Chithunzi kapena mawonekedwe odzaza .
   
3. Dinani pa batani la Clip Art kuti mutsegule Zithunzi zowonekera.
   
4. Lembani "cookie" mu Search Text box ndipo pindikizani Bwerani kuti muwone zithunzi zowonera zithunzi.
   
5. Dinani pa chithunzi kuchokera kwa omwe alipo ndipo yesani botani loyenera kuti muzisankhe.
   
6. Dinani pa Chotsitsa Chotsatira pansi pa batani lazamakono.
   
7. Dinani batani Yowonekera pansi pa dialog box kuti mubwerere ku graph yanu.
   
8. Mabala a buluu pa graph ayenera kuti asinthidwa ndi chithunzi chakhuki chomwe wasankha.
   
9. Bwezerani masitepewa pamwamba kuti musinthe mipiringidzo ina ku graph ku zithunzi.
   
10. Mukamaliza, zithunzi zanu ziyenera kufanana ndi chitsanzo patsamba 1 la phunziroli.

04 a 04

Dongosolo la Maphunziro

Kuti mutengere phunziro ili, onjezerani deta ili pamwambapa ku Excel spreadsheet kuyambira mu selo A3.