Canza launuka masu launi da nuna alamun bayanai

Yawancin lokaci, shafukan shafi ko shafukan shafukan nuna nuna yawanci ko adadin lokuta adadi ya faru don lokacin da aka saita. Matsayin da ya fi girma, yawancin lokuta darajar ta auku.

Bugu da ƙari, shafuka yana nuna yawan jerin bayanai tare da kowane ɓangaren cikin jerin suna launi ɗaya.

Yin amfani da fasalin fasalin da ke cikin Excel, yana yiwuwa a sami ginshiƙi mai siffar mimic zane da nunawa

• harsuna masu launin daban-daban don kowane aya na jerin jinsin guda
• ƙimar adadin da kowanne shafi yana wakilta adadin yawan

Biye da matakai a cikin wannan jagorantar koyawa ta hanyar samar da tsara tsarin shafi wanda aka nuna a cikin hoto a sama.

Lura:
* Idan kana da sha'awar sauya bayanan bayanan don nuna alamu, za'a iya samun bayanin a shafi na 3 na wannan koyawa
* Canza canjin launi za a iya samu a shafi na 4

01 na 06

6 Matakai don Tattauna Shafin Shafi a Excel

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 da shi don wannan koyaswar ita ce taken Tsarin Wood .

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.

02 na 06

Fara Shafin Shafin

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

Ƙirƙirar Shafin Shafin Basic

Matakan da ke biyowa zai haifar da ginshiƙi na asali - a bayyane, ma'auni marar daidaituwa - wanda ke nuna jerin jerin bayanai da kuma hanyoyi.

Matakan da ke tattare da ƙirƙirar mahimman rubutun yadda za a yi amfani da wasu daga cikin siffofin tsarawa na yau da kullum, wanda, idan aka biyo baya, zai sauya ma'auni na ainihi don daidaita ginshiƙi wanda aka nuna a shafi na 1 na wannan tutorial.

1. Danna kan Saka shafin rubutun
2. A cikin akwatin Sharuɗɗan rubutun, danna kan Saka Shafin Shafin Shafin don buɗe jerin jerin sauƙaƙe na samfuran jigogi / sigogi
3. Sauke maƙarƙircin linzaminka a kan nau'i na sutura don karanta bayanin siffin
4. Danna maɓallin Clustered Column - zaɓi na farko a cikin sashi na 2-d na jerin - don zaɓar shi
5. An tsara sashin layi na asali kuma an sanya shi a kan takardun 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 - Yuli 2014 Kudus - cikin akwatin taken

03 na 06

Ƙara Label na Labarai a matsayin Percents

Danna kan ɓangaren ɓangare na Chart

Akwai sassa daban-daban zuwa ginshiƙi a Excel - irin su yanki da ke dauke da ginshiƙan wakiltar jerin bayanan da aka zaɓa, maɓallin kwance da tsaye, da maɓallin lakabi da lakabi, da kuma jerin grid na kwance.

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 tsakiya na jadawali lokacin da niyyar zaɓar dukan jimla.

Hanyar da ta fi dacewa don zaɓar dukan jimlar shine a 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 akan abubuwan da ke cikin sashin - dole ne a zaba dukkan ginshiƙai guda huɗu a cikin zane
2. Danna madaidaici kan rubutun Kayan kayan don bude 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 tsarin mahallin na biyu, danna kan Ƙara Label na Labarin don ƙara alamar bayanai a sama da kowane shafi a cikin tashar

Canza Label na Labarai don Nuna Dashi

Ana iya sabunta alamun bayanai na yanzu don nuna kashi cikin kowane ginshiƙi a cikin ginshiƙi wakiltar yawan kudaden da ake amfani da shi ta amfani da tantancewar salula zuwa kashi adadin da aka lissafa a cikin shafi na C na layinin bayanai a cikin wani tsari .

Za a gyara alamar bayanai ta hanyar danna sau biyu a kowannensu, amma, sake, kada ka danna sau biyu.

1. Danna sau ɗaya a kan layin rubutu na 25487 a sama da Rubutun abubuwa a cikin sakon - dukkanin rubutattun bayanai hudu a cikin ginshiƙi ya kamata a zaba
2. Danna sau biyu a kan lakabin labarun Lissafi - ne kawai za a zabi lakabin lakabin 25487
3. Danna sau daya a cikin tsari ta kasa da ke ƙasa da kintinkiri
4. Shigar da ma'anar = C3 a cikin maɓallin tsari kuma latsa maɓallin shigarwa akan keyboard
5. Ya kamata lambar 25487 ta canja don karanta 46%
6. Danna sau ɗaya a kan lakabin lakabin 13275 da ke sama da Shafuka masu amfani a cikin sakon - kawai wannan lakabin labaran ya kamata a zaɓa
7. Shigar da wannan maƙirafi = C4 a cikin wannan tsari kuma latsa maɓallin Shigar
8. Lallafin labaran ya kamata ya canza don karanta 24%
9. Danna sau ɗaya a kan lakabin lakabin 8547 a sama da Shigar sufuri a cikin zane - kawai za a zabi lakabin labaran
10. Shigar da wannan maƙirafi = C5 a cikin wannan tsari kuma latsa maɓallin Shigar
11. Lallafin labaran ya kamata ya canza don karanta 16%
12. Danna sau ɗaya a kan lakabin lakabin 7526 da ke sama da Kayan kayan aiki a cikin sakon - kawai wannan lakabin labaran ya kamata a zaɓa
13. Shigar da wannan maƙirafi = C6 a cikin maɓallin tsari kuma danna maɓallin Shigar
14. Lallafin labaran ya kamata ya canza don karanta 14%

Share Shafin Grid da Labels na Gidan Gida

1. A cikin zane, danna sau ɗaya a kan jerin gundumomi 20,000 da ke gudana ta hanyar tsakiyar hoto - duk fadin grid ya kamata a haskaka (kananan shuɗin blue a karshen kowane gridline)
2. Latsa Maɓallin sharewa a kan maɓallin keɓaɓɓen kalmomi
3. Danna sau ɗaya akan alamomin Y - lambobi a hagu gefen hagu - don zaɓar su
4. Latsa Maɓallin sharewa a kan keyboard don share waɗannan alamu

A wannan batu, idan an bi duk matakan da ke sama, sashin mahaɗinku ya kamata ya zama kama da ginshiƙi a cikin hoto a sama.

04 na 06

Canza Launin Shafin Shafin Shafin da Ƙara Maganin

Shafukan Kayan Shafin Zabuka

Kamar yadda aka nuna a cikin hoton da ke sama, lokacin da aka kirkira wani ginshiƙi a Excel, ko kuma lokacin da aka zaɓa maɓallin da aka riga ta danna kan shi, ana ƙara ƙarin shafuka guda biyu zuwa rubutun .

Wadannan shafukan Rubutun Shafuka - zane da kuma tsari - sun ƙunshi tsarawa da shimfida tsarin musamman don sigogi, kuma za a yi amfani dasu a matakai na gaba don kammala sashen shafi.

Canza Launin Shafin Shafin Shafin

Bugu da ƙari, canza launi na kowanne shafi a cikin sigin, an ƙaddamar da wani gradient a kowane tsarin tsara tsarin kowanne shafi a matakai biyu.

1. Danna sau ɗaya akan abubuwan da ke cikin sashin - dole ne a zaba dukkan ginshiƙai guda huɗu a cikin zane
2. Danna sau biyu a kan Rubutun Matakan a cikin zane - kawai Rubutun Lambobi ya kamata a zaɓa
3. Danna kan Rubutun shafin na kintinkiri
4. Danna kan gunkin Shafi Fila don buɗe Fill Colors menu
5. A cikin Ƙananan Launuka sashe na menu zaɓi Blue
6. Danna kan Zaɓin Ƙarin Shafi a karo na biyu don sake buɗe menu
7. Sauke maɓallin linzamin kwamfuta a kan zaɓi na Gradient a kusa da ƙasa na menu don bude menu na Gudun
8. A cikin Ƙarin Bayani ɓangaren ɓangaren menu na Gradient , danna kan zaɓin farko ( Linear Diagonal - Hagu zuwa Hagu zuwa dama ) don ƙara wannan digiri zuwa Rubutun Matakan
9. Danna sau ɗaya a kan ginshiƙan Utilities a cikin zane - kawai ya kamata a zaɓa mahallin Shafuka masu amfani
10. Danna kan gunkin Shafi sannan ka zaɓa Red daga Ƙungiyar Launuka Tsare na menu
11. Yi maimaita matakai 6 zuwa 8 a sama don ƙara ƙwararren zuwa shafi na Utilities
12. Danna sau ɗaya a cikin sakin sufuri kuma sake maimaita matakai 10 da 11 a sama don canja wurin sufuri zuwa Green kuma don ƙara gradient
13. Danna sau ɗaya a kan Kayan na'ura sannan kuma maimaita matakai 10 da 11 a sama don canza kundin kayan aikin zuwa ƙare kuma don ƙara gradient
14. Launuka na ginshiƙai huɗu a cikin zane ya dace ya dace da waɗanda aka nuna a hoton a shafi na 1 na tutorial

Ƙara Bayani da Share Hotunan X Axis

Yanzu cewa kowanne shafi yana da launi daban-daban, za'a iya ƙara labari a ƙarƙashin layin maƙallan da maɓallin X axis a ƙarƙashin ginshiƙi da aka share

1. Danna maɓallin bayanan don zaɓar dukan ginshiƙi
2. Danna kan Shafin zane na kintinkiri
3. Danna maɓallin Ƙara Shafin Zaɓuɓɓuka a hagu na gefen hagu na rubutun don buɗe menu da aka sauke
4. Zaba Legend> Siffar daga lissafi don ƙara labari a kan filin yanki
5. Danna sau ɗaya akan alamar X - sunayen mahallin da ke ƙasa da chart - don zaɓar su
6. Latsa Maɓallin sharewa a kan keyboard don share waɗannan alamu

05 na 06

Matsar da Labarun Labarai da Ƙara ginshiƙan ginshiƙi

Sanya Tashoshin Ɗawainiya

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.

Matsar da Labarun Bayanan

Wannan mataki zai motsa alamar bayanai a cikin saman kowane shafi.

1. Danna sau ɗaya a kan ma'auni na 64% a sama da Rubutun Lambobi a cikin ginshiƙi - dole ne a zaɓa dukkan 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ɓi a gefen hagu na rubutun don buɗe Maɓallin Taswirar Ɗaukaka 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. Danna maɓallin Ƙungiyar Inside a cikin filin matsayi na aikin don motsa duk bayanan marubuta hudu zuwa cikin ciki na ginshiƙai

Ƙara ginshiƙan ginshiƙi

Gyara ginshiƙan ginshiƙi zai ƙyale mu mu ƙara girman rubutu na bayanan bayanan, yana sa su sauƙi don karantawa.

Tare da aikin Ayyukan Ɗaukakawa bude,

1. Danna sau ɗaya a kan Rubutun Lambobi a cikin zane - dole ne a zaɓi dukkan ginshiƙai guda huɗu a cikin zane
2. Idan ya cancanta, danna kan madogarar Zabuka a cikin aikin don buɗe jerin jerin
3. Saita Width Gap zuwa 40% don ƙara yawan nisan dukkanin ginshiƙai a cikin zane

Ƙara Shadow zuwa Kowane Yanki

Matakan zai ƙara inuwa a bayan kowane ginshiƙan a cikin sigogi.

Tare da aikin Ayyukan Ɗaukakawa bude,

1. Danna sau ɗaya a kan Rubutun Lambobi a cikin zane - dole ne a zaɓi dukkan ginshiƙai guda huɗu a cikin zane
2. Danna sau ɗaya a kan Hotunan tasirin a cikin aikin tsarawa don buɗe jerin jerin
3. Danna sau ɗaya a kan Shadow asalin don buɗe zaɓin inuwa
4. Bude ɓangaren shafuka da aka saita ta danna kan gunkin Saiti
5. A cikin Siffofin Siffar , danna maɓallin Maɓalli na Diagonal Upper Dama
6. Ya kamata inuwa ya bayyana a bayan kowane ginshiƙan ginshiƙi

06 na 06

Ƙara Maɓallin Bayanin Ƙarshe Mai Girma da Tsarin rubutu

Ƙara Shafin Farko Mai Girma

Wannan mataki zai ƙara ƙarar launi zuwa bango ta amfani da zaɓuɓɓuka a cikin Ayyukan Taskar Taskar kamar yadda aka nuna a cikin hoto a sama.

Idan ba'a tsaya uku ba a lokacin da aka buɗe aikin, yi amfani da ƙara / cire gumakan tashoshi na gradient kusa da bargon bargo na gradient don saita lambar zuwa uku.

Tare da aikin Ayyukan Ɗaukakawa bude,

1. Danna kan bayanan don zaɓar dukan jimla
2. Danna kan Fill & Layin layin (fenti na iya) a cikin aikin
3. Danna maɓallin Ƙarshe don buɗe zažužžukan cikawa
4. Danna kan Zaɓin Gradient cikin jerin don bude sashen gradient a ƙasa a cikin aikin
5. A cikin ɓangare na gradient, bincika don tabbatar da cewa an zaɓi Siffar nau'in zuwa Linear na tsoho
6. Saita Zaɓin Hanya zuwa Linear Down don ƙirƙirar digiri na kwance a kwance kamar yadda aka gani a hoton a shafi na 1
7. A cikin Barikin Ƙunƙwasa , danna haɓurin hagu na hagu
8. Tabbatar cewa Matsayi na matsayi shi ne 0%, kuma saita launin sa mai launi zuwa Farin Farko 1 ta amfani da launi mai launi a ƙarƙashin dakatarwar gradient
9. Danna kan dakatarwar digiri na tsakiya
10. Tabbatar cewa Matsayi na matsayi yana da kashi 50%, kuma saita launin launi don Tan Background 2 Darker 10% don canza launin layin ƙarewa mai ƙare zuwa haske mai haske
11. Danna kan dakatar da mafi kusantar dama
12. Tabbatar da cewa Matsayi na matsayi yana da 100%, kuma saita launin sa mai launi zuwa Farin Farko 1

Canza Nau'in Font, Girma, da Launi

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 : Girman layin yana auna a maki - sau da yawa ya ragu 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 sashin layi na rubutun, danna kan akwatin Font don buɗe jerin jerin sauƙaƙe na fonutun da aka samo
4. Gungura don nemo kuma danna font Bondini MT Black 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 labari don zaɓar shi
7. Amfani da matakan da ke sama, saita rubutu na rubutu zuwa 10 pt Bondini MT Black
8. Danna sau ɗaya a kan lakabi na 64% a cikin rubutun Lambobi a cikin ginshiƙi - dole ne a zaɓa duk alamun bayanai hudu a cikin ginshiƙi
9. Sanya bayanai zuwa 10.5 pt Bondini MT Black
10. Tare da bayanan bayanan da aka zaba har yanzu, danna kan Font Color icon da kintinkiri (harafin A) don buɗe Font Color panel
11. Danna kan zaɓi na launi na Farko 1 a cikin kwamitin don canza lakabin launi na launi zuwa launin fari

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