Mmene Mungapangire Chithunzi cha Girasi / Column mu Excel

01 ya 09

Pangani Tchati cha Galasi / Gulu la Galasi ndi Wachitsulo wa Chati mu Excel 2003

Maphunzirowa akugwiritsira ntchito Wowonjezera Mchati mu Excel 2003 kuti apange bar graph. Ikutsogolerani kudzera muzochitika zomwe zimawoneka pazithunzi zinai za Watsati wa Chati.

Mtsati wa Chati wapangidwa ndi mndandanda wa ma bokosi a dialog omwe amakupatsani zonse zomwe mungapeze popanga tchati.

Mabokosi Anai Akutanthauzira

1. Kusankha mtundu wojambula monga tchati cha pie, tchati cha bar, kapena tchati cha mzere.
2. Kusankha kapena kutsimikizira deta yomwe ingagwiritsidwe ntchito kupanga tchati.
3. Kuwonjezera maudindo ku tchati ndi kusankha zosankha zosiyanasiyana za tchati monga kuwonjezera malemba ndi nthano.
4. Kusankha ngati kuyika tchati pa tsamba lomwelo monga deta kapena pa pepala lapadera.

Zindikirani: Ambiri a ife timachitcha bar graph akutchulidwa, mu Excel, ngati tchati chachindunji , kapena tchati cha bar .

Palibe Wowonjezera Chart

Mdiresi wamatchi achotsedwa kuchoka ku Excel kuyambira pa 2007. Iwo asinthidwa ndi zosankha zachitsulo zomwe ziri pansi pa tsamba loyikira laboni .

Ngati muli ndi ndondomeko ya pulogalamuyi kuposa Excel 2003, gwiritsani ntchito maulumikizi otsatirawa kwa otsogolera ma graph / chart mu Excel:

• Excel 2013 Bar Graph / Column Chakuphunzitsani
• Excel 2010/2007 Girasi / Gulu la Tchati Phunziro

02 a 09

Kulowa Deta ya Grafu ya Bar

Gawo loyamba pakupanga grafu ya bar ndilowetsa deta muzenera .

Mukalowetsa deta, kumbukirani malamulo awa:

1. Musasiye mzere kapena mizere yopanda kanthu mutalowa deta yanu.
2. Lowani deta yanu muzitsulo.
   

Zindikirani: Pamene mutulutsa tsamba lanu, lembani mayina omwe akufotokoza deta mukhola limodzi ndi ufulu wake, deta yokha. Ngati pali zowonjezereka zotsatila deta, lembani mndandanda wa zigawozo pamutu ndi mutu wa mndandanda uliwonse wa deta pamwamba.

Kuti muwone phunziro ili, lowetsani deta yomwe ili pa sitepe 9 ya phunziroli.

03 a 09

Sankhani Dera la Grafu - Zosankha ziwiri

Kugwiritsa ntchito Mouse

1. Kokani osankha ndi batani kuti musonyeze maselo okhala ndi deta kuti aphatikizidwe mu bar graph.

Kugwiritsa ntchito Keyboard

1. Dinani pamwamba kumanzere kwa deta ya graph.
2. Gwiritsani chinsinsi cha SHIFT pa kambokosi.
3. Gwiritsani ntchito mafungulo pa makina kuti musankhe deta kuti muphatikizidwe mu bar graph.

Zindikirani: Onetsetsani kuti muzisankha maulendo aliwonse omwe mukufuna kuphatikizidwa.

Phunziroli

1. Onetsetsani chigawo cha maselo kuchokera ku A2 mpaka D5, zomwe zikuphatikizapo maudindo a mitu ndi mitu ya mzere

04 a 09

Momwe Mungayambitsire Mkonzi Wamatchi

Muli ndi zisankho ziwiri zomwe mungayambe poyambitsa Wofalitsa Chart Chart.

1. Dinani pa chithunzi cha Wachitsulo cha Chati pazitsulo (onani chitsanzo cha chithunzi pamwambapa)
2. Sankhani Insani> Tchati ... kuchokera ku menyu.

Phunziroli

1. Yambitsani Wotchi wa Chati pogwiritsa ntchito njira yomwe mukufuna.

Masamba otsatirawa amagwira ntchito kudzera muzitsulo zinayi za Mkonzi wa Tchati.

05 ya 09

Khwerero 1 - Kusankha Mtundu wa Grafu

Kumbukirani: Chimene ambiri a ife timachitcha bar graph akutchulidwa, mu Excel, ngati tchati chachithunzi , kapena tchati cha bar .

Sankhani Chati pa Standard Tab

1. Sankhani mtundu wa Chati kuchokera kumanzere.
2. Sankhani chithunzi chachitsulo kuchokera ku gulu labwino.

Zindikirani: Ngati mukufuna kupanga ma grafu omwe ndi ovuta kwambiri, sankhani Mafupa Amtundu Amtundu pamwamba pa Bokosi la Tchati la Chati.

Phunziroli
(pa tebulo la Standard Chart Types)

1. Sankhani mtundu wa tchati wamtundu kumanzere pamanja.
2. Sankhani ndondomeko yowonjezeredwa yachitsulo kumanja lamanja.
3. Dinani Zotsatira.

06 ya 09

Khwerero 2 - Yang'anani Zithunzi Zanu Zamatabwa

• Ngati musankha deta yanu musanayambe Excel Chart Wizard, mudzawona chitsanzo cha bar graph yanu pawindo lapamwamba la bokosi.
• Pa tsamba lanu, deta yomwe yaphatikizidwa pa graph imayendetsedwa ndi nyerere zoyenda-mzere wakuda wakuda kuzungulira deta yanu.
• Pansi pazenera zowonetserako ndi bokosi lomwe liri ndi mafotokozedwe a selo a ma data omwe ali mu graph.
• Ngati galasi yanu yayang'ana bwino, onetsetsani kuti mwasankha deta yolondola mu spreadsheet.

Phunziroli

1. Ngati graph yanu ikuwoneka yolondola pazenera zowonetsera, dinani Zotsatira .

07 cha 09

Khwerero 3 - Kujambula Galama la Bar

Ngakhale pali zosankha zambiri pansi pa ma tebulo asanu ndi limodzi kuti musinthe maonekedwe a graph yanu mu sitepe iyi, tidzangowonjezera mutu wa graph yathu.

Zonsezi za graph zikhoza kusinthidwa mutatha kumaliza Mtsati wa Tchati.

Sikofunika kupanga zonse zomwe mungasankhe pakali pano.

Phunziroli

1. Dinani pa maudindo tabu pamwamba pa dialog box.
2. Mu bokosi la chithunzi cha Chati, lembani mutu wakuti Cookie Shop 2003 - 2005 Phindu .

Dziwani: Pamene mukulemba maudindo, ayenera kuwonjezeredwa pawindo lawonetserako.

08 ya 09

Gawo 4 - Malo a Girasi

Pali zosankha ziwiri zokha zomwe mukufuna kuyika galasi lanu la bar:

1. Monga pepala latsopano (ikani graph pa pepala losiyana kuchokera ku deta yanu mu bukhu la ntchito)
2. Monga chinthu pa pepala 1 (onetsani graph pa pepala limodzi ndi deta yanu m'buku)

Phunziroli

1. Dinani batani lawailesi kuti muike galasi ngati chinthu chojambula 1.
2. Dinani Kutsiriza

Kujambula Galama la Bar

Kamodzi kawotchi ikadzatha, galasi yanu ya galasi idzaikidwa pa tsamba. Chithunzichi chikafunikiranso kusinthidwa isanati chikhale chokwanira.

09 ya 09

Zithunzi za Girasi za Bar Graph

Lowani deta ili m'munsiyi mu maselo omwe akuwonetsedwa kuti mupange bar graph yomwe ili ndi phunziroli. Palibe maonekedwe a pepala lopangira mapepala omwe akuphunzitsidwa, koma izi sizidzakhudza bar graph yanu.

Cell - Data
A1 - Chidule cha Ndalama - The Shop Cookie
A3 - Ndalama Zonse:
A4 - Ndalama Zonse:
A5 - Phindu / Kutaya:
B2 - 2003
B3 - 82837
B4 - 57190
B5 - 25674
C2 - 2004
C3 - 83291
C4 - 59276
C5 - 26101
D2 - 2005
D3 - 75682
D4 - 68645
D5 - 18492

Bwererani ku Gawo 2 la phunziroli.