Yadda za a ƙirƙiri Bar Shafi / Shafin Shafin a Excel

01 na 09

Ƙirƙirar Bar Shafi / Shafin Shafi tare da Rufin Wizard a Excel 2003

Wannan koyaswar ta rufe yin amfani da Wizard na Chart a cikin Excel 2003 don ƙirƙirar hoton bar. Yana shiryar da ku ta hanyar amfani da siffofin da suka fi kowa a kan fuska hudu na Wizard na Shafin.

Wizard na Shafuka ya ƙunshi jerin zane-zane na zane-zane da ke baka dukkan zaɓuɓɓukan da aka samo don samar da ginshiƙi.

Kwafi Tattaunawa huɗu ko Matakai na Wizard na Shafuka

1. Zaɓin nau'in siginar irin su zane-zane, ma'auni, ko layin layi.
2. Zaɓin ko tabbatar da bayanan da za a yi amfani da ita don ƙirƙirar ginshiƙi.
3. Ƙara sunayen sarauta a tasirin kuma zaɓi zabuka daban-daban na zane kamar ƙara rubutu da labari.
4. Yankan shawara idan za a sanya ginshiƙi a kan wannan shafi a matsayin bayanai ko a takardar raba.

Lura: Abin da yawancin mu ke kira fasalin bar ɗin ana kiransa, a cikin Excel, a matsayin ginshiƙi , ko sashin shafuka .

Wizard na Tashoshi Babu Ƙari

An cire wizard na asali daga Excel farawa da version 2007. An maye gurbinsu tare da zaɓuɓɓukan zaɓi waɗanda suke ƙarƙashin saitin shafin shafin rubutun .

Idan kana da wani ɓangaren shirin a baya fiye da Excel 2003, yi amfani da hanyoyin da za a bi don wasu zane-zane / shafuka a Excel:

• Excel 2013 Bar Graph / Shafin Tutorial
• Excel 2010/2007 Bar Shafi / Shafin Takardun Shafi

02 na 09

Shigar da Bar Graph Data

Mataki na farko a ƙirƙirar zanen shafuka shine shigar da bayanai a cikin takardun 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.
   

Lura: Lokacin da aka shimfiɗa takardunku, jera sunayen da ke kwatanta bayanan a ɗaya shafi da kuma dama na wannan, bayanan 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.

Don bi wannan koyawa, shigar da bayanan da ke cikin mataki na 9 na wannan koyawa.

03 na 09

Zaɓi Bar Graph Data - Biyu Zabuka

Yin 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 shafukan bar.

Yin amfani da maɓallin rubutu

1. Danna kan hagu na hagu na bayanan bar.
2. Riƙe maɓallin SHIFT akan keyboard.
3. Yi amfani da makullin maɓallin keɓaɓɓiyar keyboard don zaɓin bayanan da za a haɗa a cikin shafukan bar.

Lura: Tabbatar zaɓin kowane lakabi da layi da kake son kunshe cikin jadawali.

Don Wannan Koyarwar

1. Gano gunkin sel daga A2 zuwa D5, wanda ya haɗa da sunayen shafi da jigogi na jigogi

04 of 09

Yadda za a 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. Zaɓi Saiti> Shafuka ... daga menu.

Don Wannan Koyarwar

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

Shafuka masu zuwa suna aiki ta hanyar matakai hudu na Wizard na Shafin.

05 na 09

Mataki na 1 - Zaɓi nau'in Shafi

Ka tuna: Abin da mafi yawancinmu suna kiran fasalin shafuka ana kiransa, a cikin Excel, a matsayin ginshiƙi , ko sashin shafuka .

Nemi Chart a Tabbaccen Tab

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

Lura: Idan kana son ƙirƙirar hotunan da suka fi dacewa, zaɓar Rubutun Dabbobi a saman akwatin kwance na Chart.

Don Wannan Koyarwar
(a kan Tsararren Shafuka Tsarin shafi)

1. Zaɓi nau'in ginshiƙi a shafi na hagu.
2. Zaɓi Madogararren rubutun allon Clustered Column a hannun dama.
3. Danna Next.

06 na 09

Mataki na 2 - Bincika Bar Bar ɗinku

• Idan ka zaɓa bayananka kafin ka fara Wizard na Shafuka na Excel, za ka ga wani misali na shafukan bar ɗinka a saman bene na akwatin maganganu.
• A kan shafukan yanar gizonku, bayanan da aka kunshe a cikin hoton yana kewaye da tururuwa masu tafiya - da iyakokin baki mai ba da izini game da bayanan ku.
• Ƙarƙashin samfurin duba shi ne akwatin da ke tattare da tantanin labaran da ke cikin jeri.
• Idan ma'auni ɗin bar ɗinka bai yi daidai ba, duba don tabbatar da zaɓin keɓaɓɓen bayanin bayanai a cikin maƙallan rubutu.

Don Wannan Koyarwar

1. Idan hotonka ya bayyana daidai a cikin samfurin dubawa, danna Next .

07 na 09

Mataki na 3 - Tsarin Bar Shafi

Kodayake akwai zaɓuɓɓuka da dama a ƙarƙashin shafuka shida don gyaran bayyanar hotonku a cikin wannan mataki, zamu ƙara wani take a ma'auni na ma'auni kawai.

Dukkan sassan jadawali za a iya canzawa bayan ka kammala Wizard na Shafin.

Ba lallai ba ne don yin dukkan zaɓin tsarawa a yanzu.

Don Wannan Koyarwar

1. Danna maɓallin sunayen sarauta a saman akwatin maganganu.
2. A cikin akwatin Shafin, rubuta maƙallin The Cookie Shop 2003 - 2005 Kudin .

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

08 na 09

Mataki na 4 - Shafi Location

Akwai zabi biyu kawai don inda kake so ka sanya shafukan bar ka:

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

Don Wannan Koyarwar

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

Shirya Bar Shafi

Da zarar an tsara sakon tsara, za a sanya hoton shafukanka a kan takardun aiki. Har ila yau, har yanzu ana ɗaukar hotunan kafin a yi la'akari da shi.

09 na 09

Bar Graph Tutorial Data

Shigar da bayanan da ke ƙasa a cikin kwayoyin da aka nuna don ƙirƙirar hoton bar da aka rufe a cikin wannan koyo. Babu tsarin tsara ayyukan da aka rufe a cikin wannan koyo, amma wannan ba zai shafar shafukan bar ɗin ku ba.

Cell - Data
A1 - Ra'ayin Gari - Kayan Kuki
A3 - Rahotan kuɗi:
A4 - Kudin Kuɗi:
A5 - Riba / Rushe:
B2 - 2003
B3 - 82837
B4 - 57190
B5 - 25674
C2 - 2004
C3 - 83291
C4 - 59276
C5 - 26101
D2 - 2005
D3 - 75682
D4 - 68645
D5 - 18492

Komawa zuwa Mataki na 2 na wannan koyawa.