Yadda ake ƙirƙirar ginshiƙi a cikin Excel?

Sabuntawa ta ƙarshe: 26/10/2023
Marubuci: Sebastian Vidal

Yadda ake ƙirƙirar ginshiƙi a cikin Excel? Idan kuna neman hanya mai sauƙi da inganci don dubawa bayananka, Excel shine cikakken kayan aiki a gare ku. Tare da dannawa kaɗan kawai, zaku iya canza lambobinku zuwa fayyace, taƙaitacciyar jadawali waɗanda zasu taimaka muku fahimtar bayanan da ke gaban ku. Ko kuna aiki akan rahoton kasuwanci, gabatarwar makaranta, ko kuna son yin nazari kawai ku na sirri kudi, wannan labarin zai nuna maka mataki-mataki Yadda ake ƙirƙirar ginshiƙi a cikin Excel cikin sauri da sauƙi. A'a Kada ku rasa shi!

Mataki-mataki ➡️ Yadda ake ƙirƙirar ginshiƙi a cikin Excel?

  • Yadda ake ƙirƙirar ginshiƙi a cikin Excel?
  • Mataki na 1: A buɗe Microsoft Excel a kwamfutarka.
  • Mataki na 2: Danna "Insert" tab a ciki kayan aikin kayan aiki mafi girma.
  • Mataki na 3: A cikin rukunin zaɓuɓɓukan "Charts", zaɓi nau'in ginshiƙi da kuke son ƙirƙira, kamar "Shafin," "Layi," ko "Stacked Bars."
  • Mataki na 4: Wani sabon taga zai bayyana inda zaku iya zaɓar bayanan da kuke son haɗawa a cikin jadawalin ku. Zaɓin kewayon tantanin halitta wanda ya ƙunshi bayanan da kuke son wakilta.
  • Mataki na 5: Danna maɓallin "Amsa".
  • Mataki na 6: Excel zai samar da ginshiƙi ta atomatik bisa bayanan da aka zaɓa.
  • Mataki na 7: Kuna iya tsara ginshiƙi ta danna-dama akansa kuma zaɓi "Zaɓuɓɓukan Chart." A can za ku iya canza take, launuka, sikelin da sauran abubuwan gani.
  • Mataki na 8: Idan kana son ƙara ko canza bayanan ginshiƙi, kawai danna shi sau biyu sannan taga bayanan zai buɗe.
  • Mataki na 9: Da zarar kun keɓance kuma kun gyara ginshiƙi zuwa abubuwan da kuke so, zaku iya ajiye shi azaman ɓangaren naku Fayil ɗin Excel ko fitar da shi azaman hoto na tsaye.
Keɓaɓɓen abun ciki - Danna nan  Yadda ake shigar da sandunan LED?

Tambaya da Amsa

Q&A: Yadda ake ƙirƙirar ginshiƙi a cikin Excel?

1. Yadda ake bude Excel?

Don buɗe Excel, bi waɗannan matakan:

  1. Danna maɓallin "Fara" a cikin ƙananan kusurwar hagu daga allon.
  2. Bincika kuma zaɓi shirin Microsoft Excel.

2. Yadda ake saka bayanai a cikin Excel?

Don sakawa data a cikin Excel, yi waɗannan matakai:

  1. Bude fayil ɗin Excel na yanzu ko ƙirƙirar sabo.
  2. Zaɓi tantanin halitta inda kake son shigar da bayanai.
  3. Buga bayanan cikin tantanin halitta kuma latsa "Shigar" don matsawa tantanin halitta na gaba.

3. Yadda za a zabi bayanai don ginshiƙi a cikin Excel?

Bi waɗannan matakan don zaɓar bayanai don ginshiƙi a cikin Excel:

  1. Danna kuma ja don zaɓar kewayon sel da kake son haɗawa a cikin ginshiƙi.
  2. Tabbatar cewa bayanan da aka zaɓa sun ƙunshi duka lakabin layi/shafi da ƙima.

4. Yadda ake ƙirƙirar ginshiƙi a cikin Excel?

Don ƙirƙirar ginshiƙi a cikin Excel, bi waɗannan matakan:

  1. Zaɓi bayanan da kuke son haɗawa a cikin ginshiƙi.
  2. Danna shafin "Saka" a cikin kayan aiki daga Excel.
  3. Zaɓi nau'in ginshiƙi da kuke son ƙirƙira (misali, ginshiƙi, jadawalin layi).
  4. Zaɓi ƙirar da ka fi so.
Keɓaɓɓen abun ciki - Danna nan  Yadda Ake Yin Wurin Ajiye Wayar Salula Da Naɗin Takardar Bayan Gida

5. Yadda ake tsara ginshiƙi a cikin Excel?

Don tsara ginshiƙi a cikin Excel, bi waɗannan matakan:

  1. Zaɓi jadawali ta danna shi.
  2. Yi amfani da maballin "Layout" da "Format" a kan kayan aiki don gyara launi, salo, da sauran bangarorin ginshiƙi.
  3. Bincika zaɓuɓɓukan da ke akwai don canza taken ginshiƙi, gatari, almara, da sauran halaye.

6. Ta yaya zan canza nau'in jadawalin a Excel?

Idan kuna son canza nau'in ginshiƙi a cikin Excel, yi haka:

  1. Danna-dama akan ginshiƙi kuma zaɓi "Canja Nau'in Chart" daga menu na mahallin.
  2. Zaɓi sabon nau'in jadawalin da kake son amfani da shi.
  3. Keɓance sabon ginshiƙi gwargwadon buƙatun ku.

7. Yadda ake ƙara lakabi da almara zuwa ginshiƙi a cikin Excel?

Don ƙara lakabi da tatsuniyoyi zuwa ginshiƙi a cikin Excel, bi waɗannan matakan:

  1. Danna kan ginshiƙi kuma zaɓi shafin "Design" a cikin kayan aiki.
  2. Danna "Ƙara Chart Element" kuma zaɓi nau'in take ko almara da kake son ƙarawa.
  3. Buga take ko rubutun almara a wurin da ya dace a cikin ginshiƙi.
Keɓaɓɓen abun ciki - Danna nan  Yadda Ake Yin Murhu

8. Yadda ake ajiye ginshiƙi a Excel azaman hoto?

Idan kana son adana ginshiƙi a cikin Excel azaman hoto, yi haka:

  1. Danna-dama akan ginshiƙi kuma zaɓi "Ajiye azaman Hoto" daga menu na mahallin.
  2. Zaɓi wurin da kake son adana hoton sannan ka danna "Ajiye".

9. Yadda ake buga ginshiƙi a cikin Excel?

Bi waɗannan matakan don buga ginshiƙi a cikin Excel:

  1. Danna kan jadawalin don zaɓar sa.
  2. Je zuwa shafin "Fayil" a cikin kayan aikin Excel.
  3. Zaɓi "Buga" daga menu na gefe.
  4. Daidaita zaɓuɓɓukan bugawa bisa ga abubuwan da kake so sannan ka danna "Buga".

10. Yadda ake share ginshiƙi a cikin Excel?

Don share ginshiƙi a cikin Excel, yi haka:

  1. Dama danna kan ginshiƙi da kake son gogewa.
  2. Zaɓi "Share" daga menu na mahallin.