Sida loo sameeyo jaantus funnel gudaha Excel?

Kuwa ka shaqeeya iibinta, suuq-geynta, ama goob kasta oo kale oo adeegsata ama ka hesha warbixinnada software-ka ganacsiga waxay u badan tahay inay yaqaanaan marinka iibka. Isku day in aad samaysato jaantuska funnel-kaaga oo waxaad arki doontaa in ay u baahan tahay xirfad. Excel wuxuu bixiyaa qalab lagu abuurayo Ahraamta rogan, laakiin waxay qaadataa xoogaa dadaal ah.

Kuwa soo socdaa waxay tusiyaan sida loo sameeyo jaantuska maduunka ee Excel 2007-2010 iyo Excel 2013.

Sida Loo Sameeyo Shaxda Funnel ee Excel 2007-2010

Sawirada qaybtan waxaa laga soo qaatay Excel 2010 ee Windows.

  • Muuji xogta aad rabto inaad ku darto jaantuska. Tusaale ahaan, aynu soo qaadano tirada macaamiisha ku xidhan dhuumaha (column Tirada Xisaabaadka ee Dhuumaha shaxda hoose).
  • On the Advanced tab insert ( Geli ) dhagsii badhanka shaxanka shaxda (Column) dooro Ahraamta is dulsaaran ee caadiga ah (100% Ahraamta la dulsaaray).
  • Dooro taxane xog ah adigoo gujinaya barta kasta oo xog ah.
  • On the Advanced tab Constructor (Naqshada) koox ahaan Data (Xogta) dhagsii badhanka Tiirka safka (Beddel Saf/Column).
  • Midig ku dhufo Ahraamta oo dooro Wareega XNUMXD (3-D Rotation) ee menu ka soo muuqda.
  • Beddel xagasha wareega ee faasasyada X и Y iyo 0 °.
  • Midig ku dhufo dhidibka toosan oo ka dooro liiska soo muuqda Qaabka dhidibka (Format Axis).
  • sax Celcelis habka qiyamka (Qiimaha siday u kala horreeyaan) - jaantuska funnel waa diyaar!

★ Wax badan ka sii akhri maqaalka: → Sida loo dhiso jaantuska funnel-ka iibka ee Excel

Sida loo abuuro jaantus Funnel gudaha Excel 2013

Sawirada qaybtan waxaa laga soo qaatay Excel 2013 ee Windows7.

  • Muuji xogta aad rabto inaad ku darto jaantuska.
  • On the Advanced tab insert ( Geli ) dooro Hestogram mug leh (3-D jaantuska tixda is dulsaaran).
  • Midig ku dhufo tiir kasta oo ka dooro liiska soo muuqda Qaabka taxanaha xogta (Qaabka Xogta Taxanaha). Guddiga isku magaca ah ayaa furmi doona.
  • Laga soo bilaabo xulashooyinka foomka la soo jeediyay, dooro Ahraamta dhamaystiran ( Ahraamta Buuxa).
  • Dooro taxane xog ah adigoo gujinaya barta kasta oo xog ah.
  • On the Advanced tab Constructor (Naqshadeynta) ee qaybta Data (Xogta) dhagsii badhanka Tiirka safka (Beddel Saf/Column).
  • Midig ku dhufo Ahraamta oo ka dooro liiska soo muuqda Wareega XNUMXD (3-wareejin).
  • In guddiga soo muuqda Qaabka Aagga Jaantuska (Format Chart Area) qaybta Wareega XNUMXD (3-D rotation) beddel xagasha wareega ee faasasyada X и Y iyo 0 °.
  • Midig ku dhufo dhidibka toosan oo ka dooro liiska soo muuqda Qaabka dhidibka (Format Axis).
  • sax Celcelis habka qiyamka (Qiimaha siday u kala horreeyaan) - jaantuska funnel waa diyaar!

Marka jaantuska maqaarkaaga uu diyaar yahay oo uu u jeedo sidaad rabto, waxaad ka saari kartaa sumadaha xogta iyo cinwaanka jaantuska, oo waxaad u habayn kartaa nashqada sida aad jeceshahay.

degdeg ah! Haddii jaantuskaagu aanu ku salaysnayn taxane xog gaar ah, ama haddii aad rabto inaad dhiibto fikrad oo keliya oo aanad tirooyin gaar ah ahayn, way kuu fududahay inaad isticmaasho Ahraamta shaxda garaafyada SmartArt.

Leave a Reply