Momwe mungapangire tchati chazithunzi mu Excel?

Iwo omwe amagwira ntchito yogulitsa, kutsatsa, kapena gawo lina lililonse lomwe amagwiritsa ntchito kapena kulandira malipoti kuchokera ku mapulogalamu abizinesi mwina amadziwa bwino za malonda. Yesani kupanga tchati chanu ndipo muwona kuti pamafunika luso. Excel imapereka zida zopangira mapiramidi otembenuzidwa, koma pamafunika khama.

Zotsatirazi zikuwonetsa momwe mungapangire tchati cha fannel mu Excel 2007-2010 ndi Excel 2013.

Momwe Mungapangire Tchati cha Funnel mu Excel 2007-2010

Zithunzi zomwe zili mugawoli zidatengedwa ku Excel 2010 za Windows.

  • Onetsani deta yomwe mukufuna kuyika mu tchati. Mwachitsanzo, tiyeni titenge chiwerengero cha olembetsa olumikizidwa ndi mapaipi (column Nambala ya Akaunti mu Pipeline mu tebulo ili m'munsimu).
  • Pa Advanced tabu Ikani (Ikani) dinani batani tchati cha bar (Mzere) sankhani Piramidi yokhazikika yokhazikika (100% piramidi yokhazikika).
  • Sankhani mndandanda wa data podina pa data iliyonse.
  • Pa Advanced tabu Constructor (Kupanga) mu gulu Deta (Deta) dinani batani Mzere wa mzere (Sinthani Mzere/Mzere).
  • Dinani kumanja pa piramidi ndikusankha Kuzungulira kwa XNUMXD (Kuzungulira kwa 3-D) mumenyu yomwe ikuwonekera.
  • Sinthani ngodya yozungulira motsatira nkhwangwa X и Y ku 0 °.
  • Dinani kumanja pa axis ofukula ndi kuchokera pa menyu omwe akuwoneka sankhani Mtundu wa Axis (Fomati axis).
  • Sungani Sinthani dongosolo la zinthu (Makhalidwe mu dongosolo la m'mbuyo) - tchati cha faniyo chakonzeka!

★ Werengani zambiri m'nkhaniyo: → Momwe mungapangire tchati cha faneli yogulitsa mu Excel

Momwe Mungapangire Chati cha Funnel mu Excel 2013

Zithunzi zomwe zili mugawoli zidatengedwa ku Excel 2013 za Windows7.

  • Onetsani deta yomwe mukufuna kuyika mu tchati.
  • Pa Advanced tabu Ikani (Ikani) sankhani Volumetric yodzaza histogram (Tchati cha Mzati Zosanjikidwa za 3-D).
  • Dinani kumanja pamndandanda uliwonse ndi kuchokera pa menyu omwe akuwoneka sankhani Mawonekedwe a mndandanda wa data (Format Data Series). Gulu la dzina lomweli lidzatsegulidwa.
  • Kuchokera pamitundu yomwe mwasankha, sankhani piramidi yonse (Piramidi Yathunthu).
  • Sankhani mndandanda wa data podina pa data iliyonse.
  • Pa Advanced tabu Constructor (Kupanga) mu gawo Deta (Deta) dinani batani Mzere wa mzere (Sinthani Mzere/Mzere).
  • Dinani kumanja pa piramidi ndikusankha menyu yomwe ikuwoneka Kuzungulira kwa XNUMXD (Kuzungulira kwa 3D).
  • Mu gulu lomwe likuwoneka Mtundu wa Ma chart (Chigawo cha Tchati cha Format) gawo Kuzungulira kwa XNUMXD (3-D Rotation) sinthani ngodya yozungulira motsatira nkhwangwa X и Y ku 0 °.
  • Dinani kumanja pa axis ofukula ndi kuchokera pa menyu omwe akuwoneka sankhani Mtundu wa Axis (Fomati axis).
  • Sungani Sinthani dongosolo la zinthu (Makhalidwe mu dongosolo la m'mbuyo) - tchati cha faniyo chakonzeka!

Tchati chanu cha fayilo chikakonzeka ndikuyang'ana momwe mukufunira, mutha kuchotsa zilembo za data ndi mutu wa tchati, ndikusintha mawonekedwe momwe mukufunira.

Mwachangu! Ngati tchati chanu sichinakhazikike pagulu lazambiri, kapena ngati mukufuna kungopereka lingaliro osati manambala enieni, ndikosavuta kugwiritsa ntchito piramidi kuchokera pazithunzi za SmartArt.

Siyani Mumakonda