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

Wadanda ke aiki a cikin tallace-tallace, tallace-tallace, ko duk wani filin da ke amfani da ko karɓar rahotanni daga software na kasuwanci tabbas sun saba da mazubin tallace-tallace. Yi ƙoƙarin ƙirƙirar ginshiƙi na mazurari kuma za ku ga cewa yana ɗaukar ɗan fasaha. Excel yana ba da kayan aiki don ƙirƙirar pyramids masu jujjuya, amma yana ɗaukar ɗan ƙoƙari.

Mai zuwa yana nuna yadda ake ƙirƙirar ginshiƙi a cikin Excel 2007-2010 da Excel 2013.

Yadda ake Ƙirƙirar Taswirar Funnel a cikin Excel 2007-2010

Hotunan da ke wannan sashin an ɗauko su daga Excel 2010 don Windows.

  • Hana bayanan da kuke son haɗawa a cikin ginshiƙi. Misali, bari mu dauki adadin masu biyan kuɗi da aka haɗa da bututun mai (column Adadin Asusun a Bututun a cikin tebur da ke ƙasa).
  • A kan Babba shafin Saka (Saka) danna maɓallin ginshiƙi na banki (Shafi) zaɓi Dala da aka daidaita (100% stacked dala).
  • Zaɓi jerin bayanai ta danna kowane wurin bayanai.
  • A kan Babba shafin Constructor (Design) a cikin rukuni data (Data) danna maɓallin Rukunin layi (Canja Layi/Shafi).
  • Dama danna kan dala kuma zaɓi Juyawa XNUMXD (3-D Juyawa) a cikin menu wanda ya bayyana.
  • Canja kusurwar juyawa tare da gatura X и Y ku 0°.
  • Danna dama akan axis na tsaye kuma daga menu wanda ya bayyana zaɓi Tsarin Axis (Format Axis).
  • kaska Juya tsarin dabi'u (Dabi'u a cikin tsari na baya) - tsarin mazurari yana shirye!

★ Kara karantawa a cikin labarin: → Yadda ake gina mazugiyar tallace-tallace a cikin Excel

Yadda za a Ƙirƙiri Chart na Funnel a cikin Excel 2013

Hotunan da ke cikin wannan sashe an ɗauko su daga Excel 2013 don Windows7.

  • Hana bayanan da kuke son haɗawa a cikin ginshiƙi.
  • A kan Babba shafin Saka (Saka) zaɓi Histogram mai juzu'i (Tsarin ginshiƙi Stacked 3-D).
  • Danna-dama akan kowane shafi kuma daga menu wanda ya bayyana zaɓi Tsarin bayanai (Format Data Series). Tambarin suna ɗaya zai buɗe.
  • Daga zaɓuɓɓukan tsari da aka tsara, zaɓi cikakken dala (Cikakken Dala).
  • Zaɓi jerin bayanai ta danna kowane wurin bayanai.
  • A kan Babba shafin Constructor (Design) a cikin sashin data (Data) danna maɓallin Rukunin layi (Canja Layi/Shafi).
  • Danna dama akan dala kuma daga menu wanda ya bayyana zaɓi Juyawa XNUMXD (Juyawa 3-D).
  • A cikin panel da ya bayyana Tsarin Yanki na Chart (Format Chart Area) sashe Juyawa XNUMXD (3-D Juyawa) canza kusurwar juyawa tare da gatura X и Y ku 0°.
  • Danna dama akan axis na tsaye kuma daga menu wanda ya bayyana zaɓi Tsarin Axis (Format Axis).
  • kaska Juya tsarin dabi'u (Dabi'u a cikin tsari na baya) - tsarin mazurari yana shirye!

Da zarar ginshiƙi na mazurari ya shirya kuma yana fuskantar hanyar da kuke so, zaku iya cire alamun bayanai da taken ginshiƙi, kuma ku tsara ƙirar yadda kuke so.

Da sauri! Idan ginshiƙi ba ya dogara ne akan takamaiman jerin bayanai ba, ko kuma idan kuna son isar da ra'ayi ne kawai ba takamaiman lambobi ba, yana da sauƙin amfani da dala daga saitin hoto na SmartArt.

Leave a Reply