Ƙirƙirar da Shirya Layin Shafuka a Excel a 5 Matakai

Lokacin da kake buƙatar layi, akwai matakai masu sauki don amfani

A cikin Microsoft Excel, ƙara jadawalin layi zuwa takarda ko littafi yana ƙirƙirar bayyane na bayanan. A wasu lokuta, hotunan bayanan na iya sake juyayi da canje-canje wanda zai yiwu idan ba a gane shi ba lokacin da aka binne bayanai a layuka da ginshiƙai.

Yin layin layi - The Short Version

Matakai don ƙara hoto ko layin jadawali zuwa takardar aiki na Excel sune:

1. Bayyana bayanan da za a kunshe a cikin zane-zane - hada da jigogi da kuma rubutun shafi amma ba maƙamin don lissafi ba.
2. Danna kan Saka shafin rubutun .
3. A cikin sassan sashe na rubutun, danna kan Saka layin Layin Shafin don buɗe jerin abubuwan da aka samo a jerin shafuka / jigogi.
4. Sauke maɓallin linzamin ka a kan nau'i na chart don karanta bayanin siffin chart / jadawali.
5. Danna maɓallin da ake so.

Hoton da ba a daidaita ba - wanda ke nuna kawai layin da ke wakiltar jerin jerin bayanai , da maɓallin ginshiƙi, da labari, da kuma bayanan axes - za a kara da su zuwa aikin aiki na yanzu.

Differences na Shafin

Matakan da ke cikin wannan koyo suna amfani da samfurori da layout da aka samo a cikin Excel 2013. Wadannan sun bambanta da waɗanda aka samo a farkon fasalin shirin. Yi amfani da hanyoyin da za a bi don biyan darussan layi don wasu sigogin Excel.

• Excel 2010 da 2007 Line Graph Tutorial
• Excel 2003 (da kuma tsohuwar sifofin) Lissafin Zane Shafuka

A Note a kan Excel ta Theme Colors

Excel, kamar duk shirye-shiryen Microsoft Office, yana amfani da jigogi don saita samfurin takardunsa. Dangane da batun da kake amfani da shi yayin bin wannan koyawa, launuka da aka jera a cikin matakai na ƙila bazai kasance daidai da waɗanda kake amfani da su ba. Za ka iya zaɓar duk abin da kake so da kuma ci gaba.

Yin Lissafin Layin - Tsarin Tsarin

Lura: Idan ba ka da bayanai a hannunka don amfani da wannan koyawa, matakai a cikin wannan koyaswa suna amfani da bayanan da aka nuna a hoton da ke sama.

Shigar da bayanan sauran lokaci shine mataki na farko a ƙirƙirar hoto - ko da wane nau'i na hoto ko ginshiƙi an halicce su.

Mataki na biyu yana nuna bayanin da za a yi amfani dashi wajen samar da jadawalin. Zaɓin bayanan da aka zaɓa ya ƙunshi sunayen layi da kuma jigogi na jigogi, waɗanda aka yi amfani da shi azaman alamomi a cikin sigogi.

1. Shigar da bayanai da aka nuna a cikin hoton da ke sama zuwa cikin takardun aiki na daidai.
2. Da zarar ya shiga, ya nuna labaran kwayoyin daga A2 zuwa C6.

Lokacin da zaɓin bayanan, ana sanya jeri na jere da na shafi a cikin zaɓin, amma take a saman bayanan da aka ba da shi ba. Dole ne a kara lakabi a cikin hoto tare da hannu.

Ƙirƙirar Maɓalli na Shafi

Matakan da ke biyowa zai haifar da zane-zane - a fili, launi marar kyau - wanda ke nuna jerin jerin bayanai da kuma axes.

Bayan haka, kamar yadda aka ambata, tutorial ya shafi yadda za a yi amfani da wasu fasalin fasali mafi yawa, wanda, idan aka biyo baya, zai canza ma'auni na musamman don daidaita layin layin da aka nuna a farkon zanewar wannan tutorial.

1. Danna kan Saka shafin rubutun.
2. A cikin sassan sashe na ribbon menu, danna Saka saitin Layin Layin Zane don buɗe jerin jeri na samfuran jigogi / jigogi.
3. Sauke maƙarƙircin linzamin ka a kan wani nau'in hoto don karanta bayanin fasalin.
4. Danna maɓallin jeri na farko na 2-d cikin jerin don zaɓar shi.
5. An tsara jeri na layi kuma an sanya shi a kan takardar aikinka kamar yadda aka nuna a hoton a kan zane na gaba a ƙasa.

Tsarin Maɓallin Lissafi Na Asali: Ƙara Maɓallin Chart

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 ginshiƙi - Matsayi na haɓaka (mm) - a cikin akwatin take

Danna kan ɓangaren ɓangare na Chart

Akwai sassa daban-daban zuwa ginshiƙi a Excel - irin su lakabi da lakabi, yanki na yanki wanda ya ƙunshi layin da ke wakiltar bayanan da aka zaɓa, da hanyoyi masu kwance da tsaye, da kuma jerin grid na kwance.

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 jadawalin da kake son tsara ta danna kan shi tare da maɓallin linzamin kwamfuta don zaɓar shi.

A lokacin wannan koyaswar, idan sakamakonka ba ya kama da wadanda aka lissafa ba, yana da wataƙila ba ka da ɓangaren ɓangaren sashin da aka zaba lokacin da kake amfani da zabin 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, ana iya gyara ta sauri ta hanyar amfani da fasali ta Excel. Bayan haka, danna kan ɓangaren dama na chart kuma sake gwadawa.

Canza Launin Yaren Shafuka Amfani da Shafuka Masu Tafiyar Shafi

Lokacin da aka kirkiro hoto / jigo a Excel, ko kuma duk lokacin da aka zaɓa wani zane mai amfani 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 Tsarin - sun ƙunshi tsarawa da kuma saɓo na musamman musamman don sigogi, kuma za a yi amfani dasu a matakan da zasu biyo baya don canza bayanan da launi na launi.

Canza Shafin Girman Bayanin

Don wannan hoton, zanen bayanan abu ne na mataki guda biyu saboda an ƙara dan gradient don nuna wasu canje-canje a cikin launi a fadin fadin.

1. Danna kan bayanan don zaɓar dukan jimla.
2. Danna Rubutun shafin na kintinkiri.
3. Danna kan Zaɓin Ƙarin Shafi , wanda aka gano a cikin hoton da ke sama, don buɗe Ƙungiyar Fill ta saukar da panel.
4. Zaɓi Black, Rubutun 1, Sauke 35% daga Sashin Launin Labarai na lissafi.
5. Danna kan Zaɓin Ƙarin Shafi a karo na biyu don buɗe jerin menu na Yankuna.
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 Bambanci na cikin rukuni, danna kan zaɓi hagu na Linear don ƙara wani gradient wanda ke ci gaba da hankali daga hagu zuwa dama a fadin jadawali.

Canza Labarin Launi

Yanzu cewa bayanan baƙar fata ne, tsohuwar rubutu baƙar fata ba ta gani ba. Wannan ɓangaren na gaba ya canza launi na duk rubutun a cikin zane zuwa fari

1. Danna kan bayanan don zaɓar dukan jimla.
2. Danna Rubutun shafin na kintinkin idan ya cancanta.
3. Danna Zaɓin Rubutun Rubutun don buɗe Rubutun Labaran Rubutun Labarai.
4. Zabi Fatar, Bayani na 1 daga Yanayin Launuka na Jigogi na jeri.
5. Duk rubutun a cikin taken, x da y axes, da labari ya kamata ya canza zuwa fari.

Canza Launin Lines: Tsarin a Tashoshin Task

Matakan karshe na karshe na koyawa suna yin 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.

Canza Layin Launi na Acapulco

1. A cikin jadawalin, danna sau ɗaya a kan layin orange don Acapulco don zaɓar shi - ƙananan karin bayanai zasu bayyana tare da tsawon layin.
2. Danna kan Rubutun shafin na kintinkin idan ya cancanta.
3. A gefen hagu na rubutun, danna kan Zaɓin Zaɓin Zaɓuɓɓukan don buɗe Harshen Taskar Tashoshin .
4. Tun da aka riga aka zaba layin don Acapulco, taken a cikin abincin ya kamata karanta Siffofin Data Format.
5. A cikin aikin, danna kan gunkin Fill (zanen launi) don buɗe jerin zaɓin Lissafi.
6. A cikin jerin zaɓuɓɓuka, danna kan gunkin Fill kusa da lakabin Launi don buɗe jerin layin Lissafin Lines.
7. Zabi Green, Haɗir 6, Sauƙi 40% daga Yanayin Launuka na Jerin jerin - layin don Acapulco ya canza zuwa launi mai haske.

Canza Amsterdam

1. A cikin jadawalin, danna sau ɗaya a kan blue line don Amsterdam don zaɓar shi.
2. A cikin Shirye-shiryen ayyuka na aikin, launi na halin yanzu Kun cika da aka nuna a ƙarƙashin icon ya kamata ya canja daga kore zuwa blue nuna cewa aikin yana nuna zažužžukan don Amsterdam.
3. Danna kan gunkin Fill don buɗe jerin layin Lissafin Lines.
4. Zaɓi Blue, Gyara 1, Sauƙi 40% daga Yanayin Launuka na Jerin jerin - layin don Amsterdam ya canza zuwa launin launi mai haske.

Fading Outlines Gridunan

Tsarin canji na karshe shine a daidaita matakan grid da ke gudana a fadin jimla.

Shafin layi na ainihi ya haɗa da waɗannan labaran don yin sauki don karanta dabi'u don ƙayyadaddun bayanai a kan layin bayanai.

Ba su, duk da haka, suna bukatar su kasance sosai don haka aka nuna su sosai. Wata hanyar da za ta iya sauƙaƙe su ita ce daidaita daidaitarsu ta yin amfani da aikin Ayyukan Taswira.

Ta hanyar tsoho, matakin da suke nuna gaskiya shine 0%, amma ta hanyar ƙaruwa, ɗakunan grid za su ɓace cikin ɗakin da suke ciki.

1. Danna kan Zaɓin Zaɓin Zaɓuɓɓuka a kan Rubutun shafin shafin rubutun idan ya cancanci bude Opin Taskar Tashoshin
2. A cikin jadawalin, danna sau ɗaya akan madaidaicin mita 150 da ke gudana ta tsakiya tsakanin jimlar - duk fadin grid ya kamata a hankalta (dige mai launin shuɗi a ƙarshen kowane gridline)
3. A cikin sauye-sauye canza matakin nuna gaskiyan zuwa 75% - wajan grid a kan mujallar ya kamata ya ƙare