Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Menene farkon abin da muke tunani akai bayan ƙirƙirar ginshiƙi a cikin Excel? Game da yadda za a ba da zane daidai yadda muka yi zato lokacin da muka sauka zuwa kasuwanci!

A cikin sigar zamani na Excel 2013 da 2016, gyare-gyaren ginshiƙi yana da sauƙi da dacewa. Microsoft ya yi tsayin daka don yin tsarin saitin mai sauƙi kuma zaɓin da ake buƙata cikin sauƙi. Daga baya a cikin wannan labarin, za mu nuna muku wasu hanyoyi masu sauƙi don ƙarawa da keɓance duk mahimman abubuwan ginshiƙi a cikin Excel.

Hanyoyi 3 don Keɓance Zaɓuɓɓukan Chart a cikin Excel

Idan kuna da damar karanta labarinmu na baya kan yadda ake ƙirƙira ginshiƙi a cikin Excel, to kun riga kun san cewa zaku iya samun dama ga kayan aikin ƙira ta ɗaya daga cikin hanyoyi uku:

  1. Zaɓi ginshiƙi kuma yi amfani da shafuka daga rukuni Aiki tare da ginshiƙi (Kayan Aiki) - Constructor (Zane) tsarin (Format).
  2. Danna dama akan sashin ginshiƙi da kake son keɓancewa kuma zaɓi umarnin da ake so daga menu na mahallin.
  3. Yi amfani da gumaka na musamman waɗanda ke bayyana kusa da kusurwar dama ta sama na ginshiƙi lokacin da ka danna shi da linzamin kwamfuta.

Har ma ƙarin zaɓuɓɓuka suna cikin panel Tsarin Yanki na Chart (Format Chart), wanda ke bayyana a gefen dama na takardar aikin lokacin da ka danna Ƙarin zaɓuɓɓuka (Ƙarin zaɓuɓɓuka) a cikin mahallin menu na zane ko akan shafuka na ƙungiyar Aiki tare da ginshiƙi (Kayan Aiki).

tip: Don buɗe sashin da ake so nan da nan don saita sigogin ginshiƙi, danna sau biyu akan abin da ya dace akan ginshiƙi.

Tare da wannan ainihin ilimin, bari mu dubi yadda za mu iya canza abubuwa daban-daban na ginshiƙi a cikin Excel don ba shi ainihin kamannin da muke so ya yi kama.

Yadda ake ƙara take zuwa ginshiƙi na Excel

A cikin wannan sashe, za mu nuna muku yadda ake ƙara take zuwa ginshiƙi a cikin nau'ikan Excel daban-daban kuma mu nuna muku inda manyan kayan aikin zane suke. A cikin sauran labarin, za mu yi la'akari da misalai na aiki kawai a cikin sabuwar version na Excel 2013 da 2016.

Ƙara taken zuwa Chart a cikin Excel 2013 da Excel 2016

A cikin Excel 2013 da Excel 2016, lokacin da ka ƙirƙiri ginshiƙi, rubutun "Taken jadawalin“. Don canza wannan rubutu, kawai zaɓi shi kuma shigar da sunan ku:

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Hakanan zaka iya haɗa taken ginshiƙi zuwa tantanin halitta akan takardar ta amfani da hanyar haɗin yanar gizo ta yadda za a sabunta take ta atomatik a duk lokacin da abun ciki na haɗewar tantanin halitta ya canza. Yadda za a yi wannan an bayyana a kasa.

Idan saboda wasu dalilai ba a ƙara take ta atomatik ba, to danna ko'ina a cikin zane don kawo rukunin shafuka Aiki tare da ginshiƙi (ChartTools). Bude shafi Constructor (Design) kuma latsa Ƙara Ƙimar Chart (Ƙara Jigon Jadawalin) > Taken jadawalin (Tuntu) > Sama ginshiƙi (A sama Chart) ko Cibiyar (mai rufi) (Mai rufi a tsakiya).

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Ko danna alamar Abubuwan da aka tsara (Chart Elements) kusa da kusurwar dama ta sama na ginshiƙi kuma duba akwatin Taken jadawalin (Taken Asali).

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

kusa da zabin Taken jadawalin (Titin Chart), zaku iya danna kibiya mai nuni zuwa dama (duba hoton da ke sama) kuma zaɓi ɗayan zaɓuɓɓukan:

  • Sama ginshiƙi (A sama Chart) - an sanya sunan a sama da wurin ginin ginshiƙi, yayin da aka rage girman ginshiƙi; Ana amfani da wannan zaɓi ta tsohuwa.
  • Cibiyar (mai rufi) (Maballin Tsaya) - taken tsakiya yana saman saman yanki na makirci, yayin da girman ginshiƙi ba ya canzawa.

Don ƙarin zaɓuɓɓuka, danna shafin Constructor (Design) kuma latsa Ƙara Ƙimar Chart (Ƙara Jigon Jadawalin) > Taken jadawalin (Tuntu) > Ƙarin zaɓuɓɓukan kan kai (Ƙarin zaɓuɓɓuka). Ko danna alamar Abubuwan da aka tsara (Chart Elements), sannan Taken jadawalin (Tuntu) > Ƙarin zaɓuɓɓuka (Ƙarin Zaɓuɓɓuka).

Latsa maballin Ƙarin zaɓuɓɓuka (Ƙarin Zaɓuɓɓuka), a cikin duka biyun, yana buɗe panel Tsarin taken Chart (Format Chart Title) a gefen dama na takardar aiki, inda za ka iya samun zaɓuɓɓukan da kake so.

Ƙara taken zuwa Chart a cikin Excel 2010 da Excel 2007

Don ƙara take zuwa ginshiƙi a cikin Excel 2010 da baya, bi waɗannan matakan:

  1. Danna ko'ina a cikin ginshiƙi na Excel don kawo rukunin shafuka akan Menu Ribbon Aiki tare da ginshiƙi (Kayan Aiki).
  2. A kan Babba shafin Layout (Layout) danna Taken jadawalin (Tuntu) > Sama ginshiƙi (A sama Chart) ko Cibiyar (mai rufi) (Mai rufi a tsakiya).Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Haɗa taken ginshiƙi tare da tantanin halitta

Charts iri-iri iri-iri a cikin Excel galibi ana ƙirƙira su da alt rubutu maimakon take. Don saita sunan ku don ginshiƙi, zaku iya zaɓar filin ginshiƙi kuma shigar da rubutu da hannu, ko haɗa shi zuwa kowane tantanin halitta a cikin takardar aikin da ke ɗauke da, misali, sunan tebur. A wannan yanayin, taken ginshiƙi na Excel za a sabunta ta atomatik a duk lokacin da abun ciki na sel ɗin da aka haɗa ya canza.

Don haɗa taken ginshiƙi zuwa tantanin halitta:

  1. Hana taken ginshiƙi.
  2. A cikin mashigin dabara, rubuta alamar daidai (daidai).=), danna kan tantanin halitta mai ɗauke da rubutun da ake so, sannan danna Shigar.

A cikin wannan misalin, muna haɗa taken ginshiƙi na Excel zuwa tantanin halitta A1. Kuna iya zaɓar sel biyu ko fiye (misali, masu rubutun shafi da yawa) kuma taken ginshiƙi zai nuna abubuwan da ke cikin dukkan sel ɗin da aka zaɓa.

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Matsar da take a cikin ginshiƙi

Idan kana son matsar da taken ginshiƙi zuwa wani wuri, zaɓi shi kuma ja shi da linzamin kwamfuta:

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Cire taken ginshiƙi

Idan ginshiƙi na Excel baya buƙatar take, to ana iya cire shi ta hanyoyi biyu:

  • A kan Babba shafin Constructor (Design) danna Ƙara Abubuwan Tsari (Ƙara Jigon Jadawalin) > Taken jadawalin (Tuntu) > A'a (Babu).
  • Danna-dama akan sunan ginshiƙi kuma a cikin mahallin menu danna cire (Share).Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Canja font da ƙirar taken taswirar

Don canza font na taken ginshiƙi a cikin Excel, danna-dama akansa kuma danna font (Font) a cikin mahallin menu. Za a buɗe akwatin maganganu mai suna iri ɗaya, wanda a ciki zaku iya saita saitunan rubutu daban-daban.

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Idan kana buƙatar ƙarin cikakkun bayanai, zaɓi sunan zane, buɗe shafin tsarin (Format) da kuma wasa tare da daban-daban zažužžukan. Ga yadda, alal misali, zaku iya canza taken taswirar ta amfani da Menu Ribbon:

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Hakazalika, zaku iya canza bayyanar wasu abubuwan ginshiƙi, kamar taken axis, lakabin axis, da tatsuniyoyi.

Don ƙarin bayani game da wannan, duba labarin Yadda ake ƙara take zuwa ginshiƙi a Excel.

Kafa ginshiƙi axes a cikin Excel

Don yawancin nau'ikan ginshiƙi a cikin Excel a tsaye tsaye (shi ne kuma axis darajar ko Y axis) da axis a kwance (shi ma axis na nau'in ko axis X) ana ƙara ta atomatik lokacin ƙirƙirar ginshiƙi.

Don ɓoye ko nuna gatari na ginshiƙi, danna gunkin Abubuwan da aka tsara (Chart Elements), sannan danna kibiya a jere Gatura (Axes) kuma ka yi alama ga gatura da kake son nunawa, ko cire alamar akwatunan kusa da waɗanda kake son ɓoyewa.

Ga wasu nau'ikan ginshiƙi, kamar taswirar haduwa, ana iya nuna axis na biyu.

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Lokacin ƙirƙirar sigogi XNUMXD, zaku iya nunawa zurfin axis:

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Ga kowane nau'i na gatura na ginshiƙi a cikin Excel, zaku iya saita sigogi daban-daban (zamu yi magana game da wannan dalla-dalla daga baya):

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Ƙara taken Axis zuwa Chart

Lokacin ƙirƙirar ginshiƙi a cikin Excel, zaku iya ƙara taken ga gatari na tsaye da a kwance don sauƙaƙa wa masu amfani don fahimtar menene bayanan da aka nuna a cikin ginshiƙi. Don ƙara taken axis, kuna buƙatar yin abubuwa masu zuwa:

  1. Danna ko'ina a cikin ginshiƙi na Excel, sannan danna gunkin Abubuwan da aka tsara (Chart Elements) kuma duba akwatin Sunayen axis (Axis Titles). Idan kawai kuna son nuna taken ɗaya daga cikin gatura (ko dai a tsaye ko a kwance), danna kibiya a hannun dama kuma cire alamar ɗaya daga cikin akwatunan.Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari
  2. Danna kan ginshiƙi a cikin filin rubutu na axis kuma shigar da rubutun.

Don siffanta bayyanar taken axis, danna-dama akansa kuma a cikin mahallin menu danna Tsarin sunan axis (Format Axis Title). Wannan zai buɗe kwamiti na suna iri ɗaya tare da babban zaɓi na zaɓuɓɓukan ƙira na al'ada. Hakanan zaka iya amfani da zaɓuɓɓukan da aka bayar akan shafin tsarin (Tsarin) Menu ribbon, kamar yadda muka yi lokacin saita zaɓukan taken ginshiƙi.

Haɗin taken axis tare da sel takardar aiki da aka bayar

Kamar taken ginshiƙi, ana iya haɗa taken axis zuwa tantanin halitta da aka bayar ta amfani da hanyar haɗin yanar gizo ta yadda za a sabunta take ta atomatik lokacin da bayanan da ke cikin haɗewar tantanin halitta suka canza.

Don ƙirƙirar irin wannan hanyar haɗin yanar gizon, zaɓi sunan axis kuma a cikin mashaya dabara shigar da alamar daidai.=), sannan danna kan tantanin halitta wanda kake son danganta sunan axis, sannan danna Shigar.

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Canja ma'auni na axis ɗin ginshiƙi

Microsoft Excel ta atomatik yana ƙayyade mafi ƙanƙanta da matsakaicin ƙima, da kuma raka'a don axis na tsaye, dangane da abin da ake amfani da bayanai don gina ginshiƙi. Idan ya cancanta, zaku iya saita sigogin da suka fi dacewa da ku don axis na tsaye.

  1. Zaɓi axis a tsaye na ginshiƙi kuma danna gunkin Abubuwan da aka tsara (Abubuwan Chart).
  2. Danna kibiya a jere Gatura (Axis) kuma a cikin menu da ya bayyana, zaɓi Ƙarin zaɓuɓɓuka (Ƙarin zaɓuɓɓuka). Za a buɗe kwamitin Tsarin Axis (Format Axis).
  3. A cikin sashe sigogi na axis (Zaɓuɓɓukan Axis) yi ɗaya daga cikin masu zuwa:
    • Don saita ƙimar farawa da ƙarshen ƙarshen axis, shigar da ƙimar da suka dace a cikin filayen mafi qarancin (Mafi ƙarancin) ko Maximum (Mafi girman).
    • Don canza ma'aunin axis, shigar da dabi'u a cikin filayen Manyan sassa (Major) da Rarraba tsaka-tsaki (Ƙananan).
    • Don juyar da ƙimar axis, duba akwatin Juya tsarin dabi'u (Dabi'u a cikin tsari na baya).

    Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Axis a kwance, ba kamar na tsaye ba, galibi yana da alamun bayanan rubutu maimakon na lambobi, don haka wannan axis yana da ƙananan saitunan ma'auni. Koyaya, zaku iya canza adadin nau'ikan da za'a nuna tsakanin tambarin, tsarin nau'ikan, da wurin da gatura biyu suka haɗu:

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Canza tsarin lamba don alamun axis

Idan kana son a nuna lambobin da ke cikin alamun axis azaman kuɗi, kashi, lokuta, ko a wani tsari, danna-dama akan lakabin kuma a cikin menu na mahallin danna. Tsarin Axis (Format Axis). A cikin rukunin da ya buɗe, je zuwa sashin Number (Lambar) kuma zaɓi ɗaya daga cikin nau'ikan lambobi:

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

tip: Don saita tsarin bayanan tushen lambobi (wanda ke cikin sel na takardar aiki), duba akwatin Hanyar haɗi zuwa tushe (An danganta shi da tushe). Idan ba za ku iya samun sashin ba Number (Lambar) a cikin bangarori Tsarin Axis (Format Axis), duba cewa an zaɓi axis darajar akan ginshiƙi (wannan yawanci shine axis a tsaye).

Ƙara Lambobin Bayanai zuwa Chart na Excel

Don sauƙaƙe ginshiƙi don fahimta a cikin Excel, ƙara alamun bayanai waɗanda ke nuna cikakkun bayanai game da jerin bayanai. Dangane da abin da kuke son masu amfani su kula da shi, zaku iya ƙara lakabi zuwa jerin bayanai guda ɗaya, zuwa duk jerin abubuwa, ko zuwa maki ɗaya.

  1. Danna jerin bayanan da kake son ƙara lakabi don su. Don ƙara lakabin zuwa wurin bayanai ɗaya kawai, sake danna wannan wurin bayanan.Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari
  2. Danna alamar Abubuwan da aka tsara (Chart Elements) kuma duba akwatin Sa hannun Data (Lambobin Bayanai).

Misali, wannan shine yadda ginshikin mu na Excel yayi kama da lakabin daya daga cikin jerin bayanai.

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

A wasu lokuta, zaku iya zaɓar yadda za'a sanya alamun. Don yin wannan, danna kibiya a cikin layi Sa hannun Data (Lambobin Bayanai) kuma zaɓi zaɓin da ya dace. Don nuna alamun cikin filayen rubutu masu iyo, zaɓi Bayanan Kira (Data Callout).

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Yadda ake canza bayanan da aka nuna a cikin labels

Don canza abun ciki na alamun bayanan akan ginshiƙi, danna gunkin Abubuwan da aka tsara (Chart Elements)> Sa hannun Data (Labels Data) > Ƙarin zaɓuɓɓuka (Ƙarin zaɓuɓɓuka). Za a buɗe kwamitin Tsarin Lakabin Bayanai (Format Data Labels) a gefen dama na takardar aiki. A kan shafin Zaɓuɓɓukan Sa hannu (Zaɓuɓɓukan Lakabi) a cikin sashin Haɗa cikin Sa hannu (Label ya ƙunshi) zaɓi daga zaɓuɓɓukan da aka bayar.

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Idan kana son ƙara rubutu na al'ada zuwa ɗaya daga cikin bayanan, danna alamar wannan batu, sannan danna sake don adana lakabin kawai da aka zaɓa, sannan kuma a kan rubutun alamar don zaɓar shi. Na gaba, shigar da naku rubutun.

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Idan ya zama cewa alamun da yawa sun cika ginshiƙi na Excel, to zaku iya share kowane ɗayan su. Danna kan sa hannu tare da maɓallin linzamin kwamfuta na dama kuma a cikin mahallin menu danna cire (Share).

Nasihu don aiki tare da alamun bayanai:

  • Don canza matsayi na sa hannu ɗaya, kawai ja shi tare da linzamin kwamfuta zuwa wurin da ake so.
  • Don canza launin font da cika alamun bayanai, zaɓi su, sannan danna shafin tsarin (Format) kuma saita zaɓuɓɓukan tsarawa da kuke so.

Ƙara, Cire, Motsawa, da Keɓance Tsarin Taswirar Taswira

Lokacin da ka ƙirƙiri ginshiƙi a cikin Excel 2013 da Excel 2016, ana ƙara almara a kasan yankin ginshiƙi ta tsohuwa. A cikin Excel 2010 da baya, zuwa dama na yankin ginin.

Don cire almara, danna gunkin Abubuwan da aka tsara (Abubuwan Chart) kusa da kusurwar dama ta sama na ginshiƙi kuma cire alamar akwatin Legend (Legend).

Don matsar da tatsuniyoyi zuwa wani wuri daban, zaɓi ginshiƙi, buɗe shafin Constructor (Design), danna Ƙara Ƙimar Chart (Ƙara Jigon Jadawalin) > Legend (Legend) kuma zaɓi sabon matsayi don almara. Don cire labari, danna A'a (Babu).

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Wata hanyar da za a motsa labarin shine danna sau biyu akan shi kuma zaɓi matsayin da ake so a cikin sashin. Zaɓuɓɓukan labari (Legend Options) bangarori Tsarin almara (Format Legend).

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Don tsara tsarin almara, akwai zaɓuɓɓuka da yawa akan shafuka Shading da Borders (Cika & Layi) da effects (Tasirin) bangarori Tsarin almara (Format Legend).

Nuna kuma ɓoye grid a cikin ginshiƙi na Excel

A cikin Excel 2013 da 2016, nunawa ko ɓoye grid al'amari ne na daƙiƙai. Kawai danna gunkin Abubuwan da aka tsara (Chart Elements) kuma duba ko cire alamar akwatin Grid (Gridlines).

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Microsoft Excel yana ƙayyade ta atomatik waɗanne gridlines suka fi dacewa don nau'in ginshiƙi da aka bayar. Misali, ginshiƙin mashaya zai nuna manyan layukan tsaye, yayin da ginshiƙi zai nuna manyan layukan grid a kwance.

Don keɓance nau'in layin grid da aka nuna, danna kibiya dama a jere Grid (Gridlines) kuma zaɓi wanda ya dace daga zaɓin da aka tsara, ko danna Ƙarin zaɓuɓɓuka (Ƙarin Zaɓuɓɓuka) don buɗe panel Tsarin Layi Main Grid (Major Gridlines).

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Boyewa da gyara jerin bayanai a cikin ginshiƙi na Excel

Lokacin da ginshiƙi na Excel ya nuna bayanai da yawa, wani lokaci ya zama dole a ɓoye ɓangaren jerin abubuwan na ɗan lokaci don mai da hankali kan waɗanda kuke buƙata a yanzu.

Don yin wannan, danna gunkin dama na jadawali. Tace Tace (Filters Chart) kuma cire alamar waɗancan layuka da/ko nau'ikan da kuke son ɓoyewa.

Don shirya jerin bayanai, danna maɓallin Canja jere (Edit Series) zuwa dama na sunansa. Maɓallin yana bayyana lokacin da kake matsar da linzamin kwamfuta akan sunan wannan jere. Wannan zai haskaka layin da ya dace a kan jadawali, saboda haka zaka iya gani cikin sauƙi wanda za a gyara shi.

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Canja nau'in ginshiƙi da salo

Idan ginshiƙi da kuka ƙirƙira ba shine mafi dacewa ga bayanan da kuke nunawa ba, zaku iya canza nau'in ginshiƙi cikin sauƙi. Don yin wannan, zaɓi zane, buɗe shafin Saka (Saka) kuma a cikin sashe Diagrams (Charts) zaɓi nau'in ginshiƙi na daban.

Wata hanya ita ce danna-dama a ko'ina a cikin ginshiƙi kuma daga menu na mahallin danna Canja nau'in ginshiƙi (Canja Nau'in Chart).

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Domin saurin canza salon ginshiƙi da aka ƙirƙira, danna gunkin Salon ginshiƙi (Chart Styles) zuwa dama na wurin ginin kuma zaɓi wanda ya dace daga salon da aka tsara.

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Ko zaɓi ɗaya daga cikin salo a cikin sashin Salon ginshiƙi (Charts Styles) tab Constructor (Zane):

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Canza launin ginshiƙi

Don canza jigon launi na ginshiƙi a cikin Excel, danna gunkin Salon ginshiƙi (Chart Styles), bude shafin Launi (Launi) kuma zaɓi ɗayan jigogin launi da aka ba da shawarar. Za a yi amfani da launuka da aka zaɓa nan da nan zuwa zane, kuma za ku iya kimantawa nan da nan ko yana da kyau a cikin sabon launi.

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Don zaɓar launi don kowane jeri daban-daban, zaɓi jerin bayanai a cikin ginshiƙi, buɗe shafin tsarin (Format) kuma a cikin sashe Siffar salo (Shape Styles) danna Kunya ta cika (cika siffar).

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Yadda ake musanya gatari x da y na ginshiƙi

Lokacin ƙirƙirar ginshiƙi a cikin Excel, ana ƙaddamar da daidaitawar jerin bayanai ta atomatik bisa adadin layuka da ginshiƙan bayanan tushen da aka gina ginshiƙi akan su. A takaice dai, Microsoft Excel da kansa yana yanke shawarar yadda mafi kyawun zana hoto don layuka da ginshiƙai da aka zaɓa.

Idan tsayayyen tsarin layuka da ginshiƙai a kan ginshiƙi bai dace da ku ba, to kuna iya musanya gatura a kwance da a tsaye cikin sauƙi. Don yin wannan, zaɓi zane kuma a kan shafin Constructor (Design) danna Rukunin layi (Canja Layi/Shafi).

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Yadda ake juya ginshiƙi a cikin Excel daga hagu zuwa dama

Shin kun taɓa ƙirƙirar ginshiƙi a cikin Excel kuma a ƙarshe kawai kun gane cewa wuraren bayanan suna cikin sabanin tsarin abin da kuke son samu? Don gyara wannan yanayin, kuna buƙatar juyawa tsarin da aka gina nau'ikan a cikin zane, kamar yadda aka nuna a ƙasa.

Dama danna kan axis a kwance na ginshiƙi kuma danna Tsarin Axis (Format Axis) a cikin mahallin menu.

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Idan kun saba da aiki tare da Ribbon, buɗe shafin Constructor (Design) kuma latsa Ƙara Ƙimar Chart (Ƙara Jigon Jadawalin) > Gatura (Axes) > Ƙarin Zaɓuɓɓukan Axis (Ƙarin Zaɓuɓɓukan Axis).

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Ko ta yaya, panel zai bayyana. Tsarin Axis (Format Axis) inda akan shafin sigogi na axis (Zaɓuɓɓukan Axis) kuna buƙatar yi alama zaɓi Juya tsari na rukunoni (Cegories a baya domin).

Keɓance sigogi a cikin Excel: ƙara take, gatari, almara, alamun bayanai da ƙari

Baya ga jujjuya ginshiƙi a cikin Excel daga hagu zuwa dama, zaku iya canza tsari na nau'i, ƙima, ko jerin bayanai a cikin ginshiƙi, juya tsarin ƙirƙira na maki bayanai, juya taswirar kek zuwa kowane kusurwa, da ƙari. Wani labarin dabam ya keɓe ga batun jujjuyawar sigogi a cikin Excel.

A yau kun koyi yadda zaku iya keɓance sigogi a cikin Excel. Tabbas, wannan labarin yana ba ku damar zazzage saman jigon jigon saiti da tsarin tsarawa a cikin Excel, kodayake ana iya faɗi da yawa game da wannan. A cikin labarin na gaba, za mu gina ginshiƙi daga bayanan da ke kan takaddun aiki daban-daban. A halin yanzu, ina ba da shawarar ku yi aiki don ƙarfafa ilimin da aka samu a yau.

Leave a Reply