Excel 2003 Line Shafin Tutorial

01 na 10

Bayani na Wizard 2003 na Shafuka

Wannan koyaswar yana rufe matakai don ƙirƙirar layin layi a cikin Excel 2003 ta amfani da Wizard na Shafi na Excel.

Ana kammala matakai a cikin batutuwa da ke ƙasa za su samar da layin jeri kwatankwacin hoton da ke sama.

02 na 10

Shigar da Bayanan Shafukan Ligne

Ko da wane nau'i na chart ko hoto kake samarwa, mataki na farko a ƙirƙirar ginshiƙi na Excel shine sau da yawa don shigar da bayanai a cikin takardar aiki .

Lokacin shigar da bayanai, kiyaye waɗannan dokoki a hankali:

1. Kada ku bar layuka marasa launi ko ginshiƙai lokacin shigar da bayanai.
2. Shigar da bayanai a cikin ginshikan.

• A lokacin da ka shimfiɗa takardun ka, ka rubuta sunayen da ke kwatanta bayanai a cikin wani shafi kuma, zuwa dama na wannan, da bayanai kanta.
• Idan akwai jerin jerin bayanai fiye da ɗaya, lissafa su daya bayan daya a ginshiƙai tare da taken don kowane jerin bayanai a saman.

Tutorial Steps

1. Shigar da bayanai kamar yadda aka gani a cikin hoton da ke cikin sel A1 zuwa C6.

03 na 10

Zaɓin Bayanan Shafin Ligne

Amfani da linzamin kwamfuta

1. Jawo zaɓi tare da maballin linzamin kwamfuta don haskaka da kwayoyin dauke da bayanan da za a hada a cikin zane.

Yin amfani da keyboard

1. Danna kan hagu na hagu na bayanai.
2. Riƙe maɓallin SHIFT akan keyboard.
3. Yi amfani da maɓallin kiban a kan keyboard don zaɓin bayanan da za a haɗa a cikin layi na layi.

Lura: Tabbatar zaɓin kowane shafi da jigogi waɗanda ke so a hada su cikin jadawali.

Tutorial Steps

1. Gano gunkin sel daga A2 zuwa C6, wanda ya haɗa da sunayen lakabi da jigo na jeri ta amfani da ɗayan hanyoyin da aka sama.

04 na 10

Fara Wizard na Shafin

Kuna da zaɓi biyu don fara Wizard na Shafuka na Excel.

1. Danna maɓallin Wizard na Chart a kan kayan aiki mai kyau (duba misalin hoto a sama)
2. Danna kan Saka> Shafuka ... a cikin menus.

Tutorial Steps

1. Fara Wizard na Chart ta amfani da hanyar da kuka fi so.

05 na 10

Wizard na Shafi na Excel Mataki 1

Nemi Chart a Tabbaccen Tab

1. Nemo nau'in Shafin daga sashin hagu.
2. Nemi nau'in sashin shafuka daga kwamiti na dama.

Tutorial Steps

1. Zaɓi nau'in layin Lines a hannun hagu.
2. Zaɓi Layin tare da nau'in sashi na alamar alama a hannun dama dama
3. Danna Next.

06 na 10

Wizard na Shafuka na Excel Mataki na 2

Nuna Shafinku

• Bayan zabar bayananku kafin fara Wizard na Shafuka na Excel, ya kamata ku ga misali na ginshiƙi ɗinku a saman taga na akwatin maganganu.
• A kan shafukan yanar gizonku, bayanan da aka kunshe a cikin ginshiƙi an kewaye da tururuwa masu tafiya - da iyakokin baki da ke kewaye da bayanan ku.
• A ƙasa da samfurin samfurin shine akwatin da ke dauke da tantanin labaran labaran da ke cikin jerin. Idan ginshiƙi ɗinka bai duba ba daidai ba, duba don tabbatar da zaɓin tarin bayanai na dama a cikin maƙallan.

Tutorial Steps

1. Danna Next.

07 na 10

Wizard na Shafuka na Excel Mataki na 3

Shafin Zabuka

Kodayake akwai zaɓuɓɓuka da dama a ƙarƙashin shafuka shida don gyaran bayyanar sakonka, a cikin wannan mataki, za mu ƙara kawai sunayen sarauta.

Dukkan ɓangaren ginshiƙi na Excel za a iya gyaggyarawa bayan ka kammala Wizard na Shafuka, saboda haka ba lallai ba ne don yin dukkan zaɓin tsarawa a yanzu.

Tutorial Steps

1. Danna kan shafin Tituka a saman akwatin zane na Shafuka.
2. A cikin akwatin shafuka, rubuta lakabi: Matsakaicin Yanayi na Acapulco da Amsterdam .
3. A cikin akwatin Xbox (X), rubuta: Watan .
4. A cikin akwatin (A) na Category (Y), rubuta: Yanayi (mm) (Lura: mm = millimeters).
5. Lokacin da chart a cikin samfoti taga ya dubi dama, click Next.

Lura: Lokacin da kake rubuta sunayen sarauta, ya kamata a kara su zuwa ga samfurin dubawa zuwa dama

08 na 10

Wizard na Shafuka na Excel Mataki na 4

Shafin Hanya

Akwai zabi biyu kawai inda kake so ka sanya hotonka:

1. A matsayin sabon takardar (sanya shafukan a kan daban-daban takarda daga littafinku)
2. A matsayin abu a cikin takarda 1 (sanya sashin a kan takarda kamar bayaninka a cikin littafin aiki)

Tutorial Steps

1. Latsa maɓallin rediyo don sanya jeri a matsayin abu a cikin takarda 1.
2. Danna Ƙarshe.

An tsara jeri na layi kuma an sanya shi a kan takardar aikinku. Shafuka masu shafe suna shafe tsara wannan jadawali don daidaita layin layin da aka nuna a Mataki na 1 na wannan tutorial.

09 na 10

Tsarin layin zane

Sanya jigogi a kan layi biyu

1. Danna sau ɗaya tare da maɓallin linzamin kwamfuta a ko'ina a cikin mahaɗin hoto don nuna alama.
2. Latsa sau na biyu tare da maɓallin linzamin kwamfuta daidai a gaban kalmar Acapulco don gano wuri mai sakawa.
3. Latsa maɓallin ENTER a kan keyboard don rarraba take a cikin layi biyu.

Canja launin launi na jadawali

1. Danna-dama sau ɗaya tare da maɓallin linzamin kwamfuta a ko'ina a farar fata na jadawalin don buɗe jerin menu da aka sauke.
2. Danna tare da maɓallin linzamin kwamfuta a kan zaɓi na farko a cikin menu: Tsarin Shafin Farko don buɗe akwatin maganganun Shafukan Siffar.
3. Danna kan Alamomin shafin don zaɓar shi.
4. A cikin Yanki yanki, danna kan mai launin launi don zaɓar shi.
5. Don wannan koyo, zaɓi launin launi mai haske a kasa na akwatin maganganu.
6. Danna Ya yi.

Canja launin launi / cire iyakar daga labari

1. Right -click sau ɗaya tare da maɓallin linzamin kwamfuta a ko'ina a baya na jadawali ta labari don buɗe menu saukarwa.
2. Danna tare da maɓallin linzamin kwamfuta a kan zaɓi na farko a cikin menu: Tsarin Legend don buɗe akwatin maganganu na Legend.
3. Danna kan Alamomin shafin don zaɓar shi.
4. A cikin Yankin Ƙauren gefen hagu na maganganun, danna kan Babu wani zaɓi don cire iyakar.
5. A cikin Yanki yanki, danna kan mai launin launi don zaɓar shi.
6. Don wannan koyo, zaɓi launin launi mai haske a kasa na akwatin maganganu.
7. Danna Ya yi.

10 na 10

Tsarin layin Shafin (Ci gaba)

Canja launi / cire iyakar filin yanki

1. Dama -click sau ɗaya tare da maɓallin linzamin kwamfuta a ko'ina a kan ƙananan launin fata na daga cikin zane don buɗe jerin menu na saukewa.
2. Danna tare da maɓallin linzamin kwamfuta a kan zaɓi na farko a cikin menu: Tsarin Sanya Yanayi don buɗe akwatin maganganu na Plot Area.
3. Danna kan Alamomin shafin don zaɓar shi.
4. A cikin Yankin Ƙauren gefen hagu na maganganun, danna kan Babu wani zaɓi don cire iyakar.
5. A cikin Yanki yanki zuwa dama, danna kan mai launi don zaɓar shi.
6. Don wannan koyo, zaɓi launin launi mai haske a kasa na akwatin maganganu.
7. Danna Ya yi.

Cire hanyar Y

1. Dama -click sau ɗaya tare da maɓallin linzamin kwamfuta a kan y Y (wanda yake tsaye a gefe da haɓakar haɗin) daga cikin zane don bude jerin menu.
2. Danna tare da maɓallin linzamin kwamfuta a kan zaɓi na farko a cikin menu: Tsarin Axis don buɗe akwatin maganganun Axis.
3. Danna kan Alamomin shafin don zaɓar shi.
4. A cikin sassan Lines a gefen hagu na maganganun, danna kan Babu wani zaɓi don cire layin axis.
5. Danna Ya yi.

A wannan batu, zane-zanenku ya dace da layin jadawalin da aka nuna a Mataki na 1 na wannan koyawa.