Yadda za a ƙirƙira da kuma tsara wani siginar a cikin Excel

Rubutun takalma, ko kuma zane-zane kamar yadda ake kira su a wasu lokuta, amfani da nau'in harshe don nuna yawan ko girman zumunta na bayanan da ke cikin tashar.

Tun da yake suna nuna nauyin kuɗaɗɗen, sassan shafuka suna da amfani don nuna duk wani bayanan da ke nuna alamar ƙananan ɗakunan da aka kiyasta akan adadin yawan kuɗi - irin su samar da ma'aikata guda ɗaya dangane da fitar da kamfanin gaba ɗaya, ko kudaden shiga wanda samfurin daya ya samar da dangantaka da tallace-tallace na dukan samfurin samfurin.

Da'irar keɓaɓɓen ma'auni daidai 100%. Kowace yanki na keɓaɓɓen ana kiransa nau'i ne da girmansa ya nuna abin da kashi 100% yake wakilta.

Sabanin sauran sigogi, sassan layi sun ƙunshi kawai jerin jerin bayanai , kuma wannan jerin bazai iya ƙunsar nau'i ko nauyin (0) ba.

01 na 06

Nuna kashi tare da Shafin Gum

Wannan koyaswar yana rufe matakan da ake buƙata don ƙirƙirar kuma tsara tsarin zane wanda aka nuna a cikin hoto a sama. Shafin yana nuna bayanai da suka danganci sayarwa cookies don 2013.

Shafin yana nuna duk adadin tallace-tallace na kowane nau'i na kuki ta yin amfani da alamar bayanai da maƙasudin kuɗin kowane kowanne yanki yana wakiltar tallace-tallace na tallace-tallace na kamfani a shekara.

Har ila yau, sigogi ya jaddada sayar da kuki na lemun tsami ta hanyar fashewa wannan yanki daga wasu .

A Note a kan Excel ta Theme Colors

Excel, kamar duk shirye-shiryen Microsoft Office, yana amfani da jigogi don saita samfurin takardunsa.

Batun da aka yi amfani dashi don wannan koyo shine tsoho shafin.

Idan ka yi amfani da wani batu yayin bin wannan koyawa, launuka da aka lakafta a cikin matakai na ƙila bazai samuwa a cikin taken kake amfani ba. In bahaka ba, kawai zaɓi launuka zuwa ga ƙauna kamar maye gurbin kuma ci gaba. Koyi yadda za a bincika da canza canjin littafi na yanzu .

02 na 06

Fara Farar Gum ɗin

Shigar da Zaɓin Bayanan Tutorial

Shigar da bayanan shafukan shine koyaushe mataki na farko a ƙirƙirar ginshiƙi - ko da wane irin nau'i na chart an halicce su.

Mataki na biyu yana nuna bayanin da za a yi amfani dashi wajen samar da ginshiƙi.

1. Shigar da bayanai da aka nuna a cikin hoton da ke sama zuwa cikin takardun aiki na daidai.
2. Da zarar an shiga, ya nuna yawan jigilar sel daga A3 zuwa B6.

Samar da Rubutun Maɓalli

Matakan da ke ƙasa zasu haifar da zane-zane - a fili, marar tsabta - wanda ya nuna nau'i hudu na bayanai, labari, da kuma maɓallin lissafi.

Bayan haka, ana amfani da wasu siffofi na al'ada mafi yawa don sauya ma'auni na ainihi don daidaitawa da aka nuna a shafi na 1 na wannan tutorial.

1. Danna kan Saka shafin rubutun .
2. A cikin akwatin Sharuɗɗa na rubutun, danna kan Saka saitin Gum ɗin Ɗauki don bude jerin jerin sauƙaƙe na iri-iri.
3. Sauke maƙarƙircin linzaminka a kan nau'i na sutura don karanta bayanin siffin.
4. Danna kan 3-D nau'ayi don zaɓar nau'in zane uku kuma ƙara da shi zuwa takardar aiki.

Ƙara Rubutun Shafi

Shirya tsoho Chart Title ta danna sau biyu amma kada ka danna sau biyu.

1. Danna sau ɗaya a kan tsohuwar lambar layin don zaɓar shi - akwatin ya kamata ya bayyana a cikin kalmomin Chart Title.
2. Latsa sau na biyu don saka Excel a yanayin gyare-gyare , wanda ke sanya siginan kwamfuta cikin akwatin take.
3. Share da rubutun tsoho ta amfani da maɓallin Delete / Backspace akan keyboard.
4. Shigar da maɓallin lissafin - Kayan Kuki na Kasuwanci 2013 Raba daga Tallace-tallace - cikin akwatin taken.
5. Sanya siginan kwamfuta tsakanin 2013 da Raba a take kuma danna maballin shigarwa a kan keyboard don raba lakabi zuwa zuwa layi biyu.

03 na 06

Ƙara Label na Labarai zuwa Rubutun Gum

Akwai sassa daban-daban zuwa ginshiƙi a Excel - irin su yanki da ke dauke da nau'in zane wanda ke wakiltar jerin bayanan da aka zaɓa, da labari, da kuma lakabi da lakabi.

Duk waɗannan sassa suna dauke da abubuwa daban-daban ta hanyar shirin, kuma, saboda haka, kowanne zai iya tsara shi daban. Kuna gaya Excel wanda sashi na ginshiƙi da kake son tsara ta danna kan shi tare da maɓallin linzamin kwamfuta.

A cikin matakan da suka biyo baya, idan sakamakonku ba su da kama da waɗanda aka jera a cikin koyawa, yana da wataƙila ba ku da wani ɓangaren ɓangaren sashin da aka zaɓa lokacin da kuka ƙara wani zaɓi na tsarawa.

Mafi kuskuren da ake yi shine danna maɓallin yanki a tsakiyar zane lokacin da niyya shine zaɓar dukan sigin.

Hanyar da ta fi dacewa don zaɓar kowane ginshiƙi shine danna a saman hagu ko kusurwar dama daga maɓallin ginshiƙi.

Idan an yi kuskure, za'a iya gyara ta hanyar amfani da Excel ta gyara fasalin don gyara kuskuren. Bayan haka, danna kan ɓangaren dama na chart kuma sake gwadawa.

Ƙara Labels na Labarai

1. Danna sau ɗaya a kan zane-zane a filin filin don zaɓar shi.
2. Danna-dama a kan zane don buɗe jerin abubuwan da ke cikin jerin bayanai.
3. A cikin mahallin mahallin, haɓaka linzamin kwamfuta a sama da Ƙarin Label na Ƙara Labarun don buɗe jerin abubuwan mahallin na biyu.
4. A cikin menu na biyu na mahallin, danna kan Ƙara Label na La'akari don ƙara dabi'un tallace-tallace ga kowane kuki - ga kowane yanki na keɓaɓɓun a cikin zane.

Share Shafin Girma

A wani mataki na gaba, za a kara sunayen sunayen sunayen tare da dabi'un da aka nuna a yanzu, saboda haka, ba a buƙatar labarin da ke ƙasa ba a kuma za a iya share shi.

1. Danna sau ɗaya a kan labari a ƙasa da filin yanki don zaɓar shi.
2. Latsa Maɓallin sharewa a kan keyboard don cire tarihin.

A wannan batu, sakonku ya kamata ya kasance kama da misali da aka nuna a hoton da ke sama.

04 na 06

Canje-canje Canjin a kan Tab ɗin Tab

Lokacin da aka kirkiro wani nau'i a Excel, ko kuma duk lokacin da aka zaɓi wani zaɓi wanda aka zaba ta danna kan shi, ana ƙara ƙarin shafuka guda biyu a rubutun kamar yadda aka nuna a cikin hoto a sama.

Wadannan shafukan Rubutun Shafuka - zane da kuma tsari - sun ƙunshi tsarawa da shimfidawa musamman don sigogi, kuma za a yi amfani dasu a matakai na gaba don tsara fasali.

Canja launin Launi na Gurasar Abincin

1. Danna maɓallin bayanan don zaɓar dukan ginshiƙi.
2. danna kan Zaɓuɓɓukan Launin Canji wanda aka saita a gefen hagu na Shafin zane na ribbon don buɗe jerin jerin launi na launi.
3. Sauke maɓallin linzamin ka a kowane layi na launuka don ganin sunan zaɓi.
4. Danna kan zaɓi na 5 a cikin jerin - farkon zabi a cikin sashen Monochromatic na jerin.
5. Hanyoyi guda huɗu a keɓaɓɓen keɓaɓɓun kalmomi a cikin sigin na ya kamata su canza su da sauƙi masu launin shuɗi.

Canza layin Tushen Shafin

Don wannan mataki na musamman, tsarawa baya shi ne matakan mataki biyu don an ƙara wani digiri don nuna canje-canje kadan a cikin launi daga tsaye zuwa kasa a cikin ginshiƙi.

1. Danna kan bango don zaɓar dukan ginshiƙi.
2. Danna kan Rubutun shafin na kintinkiri.
3. Danna kan Zaɓin Ƙarin Shafi don buɗe Ƙungiyar Fill ta saukar da panel.
4. Zaɓi Blue, Haɗo 5, Darker 50% daga Sashin Launin Launin kwamitin don canza launin launi na launin launin shuɗi.
5. Danna kan Zaɓin Ƙarin Shafi a karo na biyu don buɗe Rukunin saukarwa na Launi.
6. Gyara maɓallin linzamin kwamfuta a kan zaɓi na Gradient a kusa da kasan jerin don buɗe ɗayan Gudun.
7. A cikin ɓangaren Variations na Dark , danna kan Zaɓin Linear Up don ƙara wani gradient da ke ci gaba da duhu daga ƙasa zuwa sama.

Canza Labarin Launi

Yanzu cewa bayanan shine shuɗi mai duhu, tsoho rubutu baƙar fata ne kawai bayyane. Wannan sashe na gaba ya canza launi na duk rubutun a cikin zane zuwa fari

1. Danna kan bango don zaɓar dukan ginshiƙi.
2. Danna kan Rubutun shafin na kintinkin idan ya cancanta.
3. Danna kan zaɓin Rubutun Rubutun don buɗe Rubutun Launin Rubutun Labarai.
4. Zabi Fatar, Bayani na 1 daga Yanayin Launuka na Jigogi na jeri.
5. Duk rubutun a cikin taken da kuma bayanan bayanan ya kamata ya canza zuwa fari.

05 na 06

Adding Category Names kuma Kunna Chart

Matakan da za a biyo baya na koyawa suna amfani da nau'in aikin ɗawainiya , wanda ya ƙunshi mafi yawan zaɓuɓɓukan tsarawa don sigogi.

A Excel 2013, lokacin da aka kunna, aikin yana bayyana a gefen dama na allo na Excel kamar yadda aka nuna a hoton da ke sama. Rubutun da zaɓuɓɓukan da suke bayyana a cikin sauye-sauyen ayyuka sun danganta kan yankin da aka zaba.

Adding Category Names kuma Matsar da Labarun Bayanan

Wannan mataki zai ƙara sunan kowane nau'in kuki ga bayanan bayanan tare da darajar hat a halin yanzu an nuna. Har ila yau, za ta tabbatar da cewa an nuna alamar bayanai a cikin ginshiƙi don haka bazai buƙatar nuna alamun jagoran da ke danganta lakabin zuwa layinsa ba.

1. Danna sau ɗaya a kan ɗaya daga cikin bayanan bayanan da ke cikin chart - dole ne a zaɓa duk alamun bayanai hudu a cikin ginshiƙi.
2. Danna kan Rubutun shafin na kintinkin idan ya cancanta.
3. Danna kan Zaɓin Zaɓin Zaɓin zaɓi a gefen hagu na rubutun don buɗe Maɓallin Ayyukan Ɗauki a gefen dama na allon.
4. Idan ya cancanta, danna kan madogarar Zabuka a cikin aikin don buɗe zaɓukan lakabi kamar yadda aka nuna a cikin hoto a sama.
5. A karkashin Label Ya ƙunshi sashe na jerin, ƙara alamar rajistan shiga zuwa sunan Yankin Category don nuna sunayen kuki da tallace-tallace tallace-tallace, kuma cire alamar rajistan shiga daga Zaɓin Lissafin Jagora .
6. A karkashin Ƙaƙidar Label sashe na lissafin, danna kan Ƙungiyar Ƙofar don motsa dukkanin rubutattun bayanai huɗu zuwa gaɓin gefen sassan sassan su.

Gyara Rigon Gum ɗin a kan X da Y Axes

Tsarin tsari na ƙarshe shine zai jawo ko kuma ya kwashe launi daga lemun daga sauran kullun don ƙara karfafawa a ciki. A halin yanzu, an samo ƙarƙashin maɓallin ginshiƙi, kuma jawo shi yayin da yake cikin wannan wuri zai sa shi a cikin taken.

Gyara ginshiƙi a kan X axis - zana layin a kusa da haka yankin lemun tsami yana nuna zuwa gefen dama na kusurwar chart - zai samar da sararin samaniya don fashewa shi daga sauran sassan.

Gyara zane a kan tashar Y zai cire fuskar fuskar da aka saukar domin ya fi sauƙi don karanta rubutun bayanan da ke cikin sakon.

Tare da Ayyukan Ɗawainiyar Ɗawainiya bude:

1. Danna sau ɗaya a kan shafukan baya don zaɓar dukan ginshiƙi.
2. Danna maɓallin Hanya a cikin aikin don buɗe jerin jerin zaɓin sakamako.
3. Danna kan Rotation 3-D a cikin jerin don duba samfuran da aka samo.
4. Saita X Rotation zuwa 170 ^o don yada zane don yadin lemun ya fuskanci gefen dama na kusurwar.
5. Sanya Y Rotation zuwa 40 ^na don cire fuskar fushin.

06 na 06

Canza Nau'in Fonts da Magana a Kayan Shafin

Canza girman da kuma irin takardun da aka yi amfani da shi a cikin tasirin, ba kawai zai kasance inganta game da takardun da aka yi amfani dashi ba a cikin sigogi, amma zai sa ya fi sauƙi a karanta sunayen sunaye da ma'auni a cikin chart.

Lura : An auna girman girman launi a cikin maki - haɓata ƙuntata zuwa pt .
Nau'in 72 pt daidai yake da ɗaya inch - 2.5 cm - a cikin girman.

1. Danna sau ɗaya a kan maɓallin ginshiƙi don zaɓar shi.
2. Danna kan shafin shafin shafin rubutun.
3. A cikin ɓangaren ɓangaren rubutun, danna kan akwatin Font don buɗe jerin ɓangaren samfuran da aka samo.
4. Gungura don nemo kuma danna font Britannic Bold a cikin jerin don canza lakabi zuwa wannan font.
5. A cikin Font Size akwatin kusa da akwatin rubutu, saita matakan lakabi zuwa 18 pt.
6. Danna sau ɗaya a kan bayanan bayanan bayanai a cikin zane don zaɓar duk alamu hudu.
7. Yin amfani da matakan da ke sama, saita bayanan rubutu zuwa 12 pt Britannic Bold.

Yin amfani da wani ɓangaren sashin layi

Wannan mataki na ƙarshe shine jawowa ko fashewa launi mai lemun tsami daga sauran kullun don ƙara karfafawa akan shi.

Bayan dawatsar da zafin , za a rage sauran sifofin a cikin girman don saukar da canji. A sakamakon haka, yana iya zama wajibi ne a mayar da ɗaya ko fiye da rubutun bayanai don sanya su cikakke a cikin sassansu.

1. Danna sau ɗaya a kan zane-zane a filin filin don zaɓar shi.
2. Danna sau ɗaya a kan layin zane na zane-zane don zaɓar wannan ɓangare na ginshiƙi - tabbatar cewa kawai yanki lemun tsami ne ke kewaye da ƙananan ɗigon haske.
3. Danna ka kuma janye layin Lemon daga tayi don fashe shi.
4. Don sauya lakabin labaran, danna sau ɗaya a kan lakabin labaran - dole ne a zaba dukkan labaran bayanan.
5. Latsa sau biyu a kan lakabin labaran da za a motsa kuma ja shi zuwa wurin da kake so.

A wannan lokaci, idan kun bi duk matakai a cikin wannan koyawa, sashinku ya dace da misali da aka nuna a shafi na 1 na tutorial.