Gadzira Pictograph mu Excel

A pictograph inoshandisa mifananidzo kuti inomiririra nhamba yedata mu chati kana grafu. Kusiyana nemifananidzo yakawanda, pictograph inosanganisira mifananidzo kuti ishandise mapuranga emifananidzo kana mazariro kakawanda anoonekwa muhurukuro, kubata vateereri vako kufarira kuburikidza nekushandiswa kwemavara nemifananidzo.

Itai kuti mharidzo yenyu inotevera iwedzere kufadza uye iri nyore kuinzwisisa nekubatanidza pictograph mu Excel.

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

Mumufananidzo wepa pictograph, mifananidzo inotsiva mahwendefa emifananidzo kana mabheji mune imwe nguva yekhombe chati kana bar bar. Iyi tutorial inoshandura nzira yekushandura bhari nyore girafu pane pictograph mu Microsoft Excel.

Related tutorial: Shandisa Pictograph mu Excel 2003

Matanho emudzidzisi ndeaya:

• Danho 1: Gadzira bar bar muExcel
  
• Danho 2: Sarudza imwe nyaya dzakanyatsotariswa mumufananidzo
  
• Nhanho 3: Kuwedzera Mufananidzo kuPytograph
  
• Nhanho yechina: Tutori Dhakira

01 ye 04

Pictograph Muenzaniso Step 1: Gadzira Bar Grafu

1. Kuti upedze danho rino nhanho dzidziso, wedzera dhesi rinowanikwa muchitsauko 4 kuenda kuExpcel 2007 spreadsheet.
   
2. Draganisa sarudza masero A2 kuD5.
   
3. Paibhoni, sarudza Insert> Column> 2-d Yakagadzirwa Column .

Chinokosha chinyorwa chati chakasikwa uye chakaiswa pane pepa rako rekushanda.

02 of 04

Pictograph Muenzaniso Step 2: Sarudza Single Data Series

Kuti ubatsirwe neshato iyi, ona mufananidzo uri pamusoro.

Kugadzira pictograph iwe unofanirwa kuisa firimu yemufananidzo yehuwandu hwemifananidzo yakazara yebhadha yega yega yega mu grafu.

1. Tsanangurira pane imwe yemapapu epepuru yebhuruu mugrafu uye sarudza Format Data Series kubva mumenyu yemamiriro.
   
2. Nhanho iri pamusoro apa inovhura Format Data Series dialog box.

03 of 04

Pictograph Muenzaniso Step 3: Kuwedzera Mufananidzo ku Pictograph

Kuti ubatsirwe neshato iyi, ona mufananidzo uri pamusoro.

Mune Fomu Data Data Series dialog box yakazarurwa muchikamu chepiri:

1. Dzvanya paZvizadza zororo muwindo rweruboshwe kuti uwane mawaniro ekuzadza anowanikwa.
   
2. Muruwindo rworudyi, chengetera paMifananidzo kana mavara ekuzadza .
   
3. Dzvanya paKiki Clip Art kuti uzarure chinyorwa cheZvi Picture .
   
4. Tora "cookie" mu Search Search box uye fairira Go go kuti uone iyo inowanikwa mufananidzo wemifananidzo.
   
5. Dzvanya pamufananidzo kubva kune avo varipo uye shandisa bhodhi OK kuti uisarudze.
   
6. Dzvanya paScack sarudzo pasi pekipi yekodhi yemifananidzo.
   
7. Dhinda bhatani Rakavhara pasi pebhokisi rebhokisi kuti udzoke kugrafu yako.
   
8. Mabharuvara mavara machena ari mugrafu anofanira kunge akachinjwa nechoko chechifananidzo chakasarudzwa.
   
9. Dzokorora matanho ari pamusoro apa kuti uchinje mamwe mazariro mufrafu kufananidzo.
   
10. Kana imwe nguva yapera, pictograph yako inofanira kufanana nemuenzaniso uri papeji 1 yemudzidzi uyu.

04 we 04

Tutorial Data

Kuti uite izvi zvidzidzo, wedzera iyo data iri pamusoro apa kuExpcel spreadsheet kubva muchitokisi A3.