Nzira Yokuumba Bhari Girafu / Column Chati mu Excel

01 ye 09

Gadzira Girafu yeBrafu / Column neChirati Wizard muna Excel 2003

Izvi zvidzidzo zvinoshandisa Cheti Mukati muExcel 2003 kuti uite bar grafu. Inokutungamirira kuburikidza uchishandisa zvinhu zvakajairika zvinowanika pazvikamu zvina zveGatidzi Wizard.

Chati Wizard inoumbwa nemakwikwi emabhokisi ebhokisi anokupa maitiro ose anowanikwa ekuumba chati.

MaBhokisi mana eDhialogo kana Matanho eChadati Wizard

1. Kusarudza chinyorwa chechati chakafanana nechavha yepane, chati yebha, kana chati chati.
2. Kusarudza kana kuongorora iyo inoshandiswa kugadzira chati.
3. Kuwedzera mazita kune chati uye kusarudza zvakasiyana-siyana sarudzo dzakadai sokuwedzera mavara uye nhoroondo.
4. Kusarudza kana kuisa chati pane peji imwechete se data kana pane pepa rakasiyana.

Cherechedza: Zvizhinji zvatiri kudana girafu rinoshandiswa, muExcel, se column column , kana bharati .

Chati Wizard Haichawani

Irodhi wizard yakabviswa kubva kuExcel kutanga nevheji 2007. Yakashandurwa nekusarudzwa kwechati iri pasi pekuisa tab yebhoni .

Kana iwe uine shanduro yepurogiramu gare gare kune Excel 2003, shandisa zvinotevera zvinowanikwa kune mamwe mafirimu / matarenda emitambo mu Excel:

• Excel 2013 Bar Girafu / Column Chart Tutorial
• Excel 2010/2007 Bhuku Girafu / Column Chart Tutorial

02 of 09

Kupinda Data yeGrafu Data

Nhanho yekutanga pakugadzira girafu nderekuisa dhidhiro mumushandi webasa .

Paunopinda munharaunda, chengeta mitemo iyi mupfungwa:

1. Usasiya mitsetse isina kana mabhuroji kana uchinge waisa deta yako.
2. Isa data yako muhurukuro.
   

Cherechedza: Paunenge uchiisa pepa rako, nyora mazita anotsanangura data mune imwe korombo uye kurudyi rweiyo, data pachayo. Kana pane pane imwe nhepfenyuro yedheta, nyora imwe imwe pashure peimwe mumakoroni ane musoro weheji yega yega data kumusoro.

Kuti uite izvi, tumira data iri muchitsauko 9 chekudzidzisa.

03 of 09

Sarudza Dhairi yeGrafu Data - Zvisarudzo zviviri

Kushandisa Mouse

1. Dragradza nebhokisi rekuisa kuti uise pachena masero ane data kuti aiswe mubar bar.

Kushandisa Keyboard

1. Dzvanya kumusoro kumusoro kuruboshwe rwe data yebar bar.
2. Tora pasi SHIFT key pa keyboard.
3. Shandisai mitsetse yemiseve pabhobhoyo kuti musarudze deta kuti iiswe mubhafa rebar.

Cherechedza: Iva nechokwadi chekusarudza chero imwe koromo uye mitsara yemutsara iwe waunoda inowanikwa muirafu.

Pamusoro peTetorial

1. Simbisa bhokisi remasero kubva paA2 kusvika kuD5, iro rinosanganisira mazita emadzorodhe uye mutsara wemutsara

04 of 09

Nzira Yokutangira Cheti Wizard

Iwe une zvisarudzo zviviri zvekutanga Excel Chart Wizard.

1. Dzvanya paChirati cheKadhi Wizard pachidimbu chebhari (ona mufananidzo wepamusoro)
2. Sarudza Faka> Chati ... kubva kumenyu.

Pamusoro peTetorial

1. Tanga Chati Wadhidhiyo uchishandisa nzira yaunoda.

Maji anotevera anoshanda kuburikidza nematanho mana eChirati Wizard.

05 of 09

Danho 1 - Kusarudza Girafu Rudzi

Yeuka: Zvizhinji zvatiri kudana girafu rinoshandiswa kune, mu Excel, se column column , kana bharati .

Sarudza Chati pane Standard Tab

1. Sarudza Chati chechirwere kubva kuruboshwe rworuboshwe.
2. Sarudza chinyorwa chechidimbu kubva pane chakanaka.

Cherechedza: Kana iwe uchida kugadzira magrafu zvisiri zvisinganzwisisiki, sarudza Custom Types tab kumusoro kweBhokisi reTeyi yebhokisi yekubhokisi.

Pamusoro peTetorial
(pane Standard Standard Types tab)

1. Sarudza mufananidzo weColumn chati mune kuruboshwe ruoko pane.
2. Sarudza Ichinyorwa Chinyorwa Chinyorwa chinyorwa-chinyorwa muruoko rworudyi pane.
3. Dhinda Kutevera.

06 of 09

Danho 2 - Tarisa Bhari Yako Girafu

• Kana ukasarudza deta yako usati watanga Excel Chart Wizard, uchaona muenzaniso webha yako grafu muwindo rekukuru rebhokisi rebhokisi.
• Pamapepaneteti ako, data yakanyorwa murafini yakakomberedzwa nemhashu dzinofamba-muganhu wakanga wakaita mhepo yakakomberedza deta yako.
• Pasi pewindo rekuona mahwindo ibhokisi rine zvinyorwa zvinoshandiswa pane dheta re data zvinowanikwa murafu.
• Kana bar bar yako isingatarisi zvakanaka, chengetedza kuti uone kuti wakasarudza yakarurama yedharedheji muparapariti.

Pamusoro peTetorial

1. Kana girafu yako inoratidzika yakarurama muwindo rekuona, tsvaga Next .

07 of 09

Nhanho 3 - Kugadzira Bar Grafu

Kunyange zvazvo pane zvakawanda zvingasarudzwa pasi pemateji matanhatu ekugadzirisa kuonekwa kwemafirimu ako muchigamba ichi, tichava kungowedzera zita rebar graph yedu.

Zvose zvikamu zvegrafu zvinogona kuchinjwa mushure mokunge mazadza Chati Wizard.

Hazvisiko kuita zvese zvekuita maitiro ako maitiro ikozvino.

Pamusoro peTetorial

1. Dzvanya pane zvinyorwa tab pane pamusoro pebhokisi rebhokisi.
2. Mubhokisi rebhokisi rebhokisi, taura zita rinonzi Cookie Shop 2003 - 2005 Mari .

Cherechedza: Sezvaunonyora zvinyorwa, dzinofanira kuwedzerwa kuwindo rekuona kurudyi kusvika kurudyi.

08 of 09

Nhanho 4 - Girafu Nzvimbo

Pane zvingarudzo zviviri chete pane kwaunoda kuisa bar bar yako:

1. Sevheti itsva (isa girafu pane pepa rakasiyana kubva kune data yako mubhuku rebhuku)
2. Sechinhu chiri mudivi 1 (isa girafu pane peji imwechete se data yako mubhuku rebhuku)

Pamusoro peTetorial

1. Dzvanya bhodhi redhiyo kuti uise girafu sechinhu chiri peji 1.
2. Chofoza Finish

Kugadzirisa Bar Grafu

Kana kamwe wadhidhi wadhivha apera, bhagrafu yako ichaiswa pamushandi webasa. Girafu ichiri kudikanwa kuenzanisirwa isati yaonekwa seyo yakakwana.

09 of 09

Girafu Girafu Tutori Dha

Pinda data iri pasi apa mumasero akaratidzirwa kuti ugadzire bar bar yakafukidzwa mune iyi tutorial. Hakuchina maitiro ekushandurwa kwemashizha akafukidzirwa mune iyi tutori, asi izvozvo hazvizokanganisa bhagrafu yako.

Cell - Data
A1 - Inowanikwa Inowanikwa - The Cookie Shop
A3 - Zvikamu Zvose:
A4 - Kushandisa Mari:
A5 - Mhuri / Kurasikirwa:
B2 - 2003
B3 - 82837
B4 - 57190
B5 - 25674
C2 - 2004
C3 - 83291
C4 - 59276
C5 - 26101
D2 - 2005
D3 - 75682
D4 - 68645
D5 - 18492

Dzokera kuChipiri chechidzidzo ichi.