Tse ka Hare
Ba sebetsang khoebong, thekisong, kapa tšimo efe kapa efe e sebelisang kapa e amohelang litlaleho ho tsoa ho software ea khoebo e kanna ea ba ba tloaelane le fani ea thekiso. Leka ho iketsetsa chate ea faniele 'me u tla bona hore ho hloka tsebo e itseng. Excel e fana ka lisebelisoa tsa ho theha liphiramide tse khelohileng, empa ho hloka boiteko bo itseng.
Se latelang se bonts'a mokhoa oa ho theha chate ea funnel ho Excel 2007-2010 le Excel 2013.
Mokhoa oa ho theha Chate ea Funnel ho Excel 2007-2010
Litšoantšo tse karolong ena li nkiloe ho Excel 2010 bakeng sa Windows.
- Totobatsa lintlha tseo u batlang ho li kenyelletsa chate. Mohlala, ha re nkeng palo ea ba ngolisitseng ba hokahaneng le pipeline (column Nomoro ea Liakhaonto tse Pipeline tafoleng e ka tlase).
- Ho Advanced tab kenya (kenya) tobetsa konopo chate ea bareki (Column) khetha Phiramide e phuthetsoeng e tloaelehileng (100% piramite e pakiloeng).
- Khetha lethathamo la data ka ho tobetsa sebakeng sefe kapa sefe sa data.
- Ho Advanced tab Constructor (Moqapi) ka sehlopha Lintlha (Data) tobetsa konopo Kholomo ea mola (Switch Row/Column).
- Tobetsa ka ho le letona piramite ebe u khetha Phetoho ea XNUMXD (3-D Rotation) ho menu e hlahang.
- Fetola angle ea ho potoloha hammoho le lilepe X и Y ka 0 °.
- Tobetsa ka ho le letona ho axis e otlolohileng le ho tsoa ho menu e hlahang khetha Sebopeho sa Axis (Axis ea Format).
- Tšoaea Fetola tatellano ea boleng (Litekanyetso ka tatellano ea morao) - chate ea fani e se e lokile!
★ Bala haholoanyane sengoloa: → Mokhoa oa ho theha chate ea fani ea thekiso ho Excel
Mokhoa oa ho theha Chate ea Funnel ho Excel 2013
Litšoantšo tse karolong ena li nkiloe ho Excel 2013 bakeng sa Windows7.
- Totobatsa lintlha tseo u batlang ho li kenyelletsa chate.
- Ho Advanced tab kenya (kenya) khetha Volumetric stacked histogram (Chate ea Kholomo e Tekiloeng ka 3-D).
- Tobetsa ka ho le letona kholomong efe kapa efe 'me ho tsoa ho menu e hlahang khetha Sebopeho sa lethathamo la data (Format Data Series). Phanele ea lebitso le tšoanang e tla buleha.
- Ho tsoa likhethong tse reriloeng tsa foromo, khetha piramite e felletseng (Pyramid e Feletseng).
- Khetha lethathamo la data ka ho tobetsa sebakeng sefe kapa sefe sa data.
- Ho Advanced tab Constructor (Moqapi) karolong Lintlha (Data) tobetsa konopo Kholomo ea mola (Switch Row/Column).
- Tobetsa ka ho le letona ho piramite le ho tsoa ho menu e hlahang khetha Phetoho ea XNUMXD (3-D Potoloho).
- Phanele e hlahang Sebopeho sa Sebaka sa Chate (Sebaka sa Chate ea Format) karolo Phetoho ea XNUMXD (3-D Rotation) fetola angle ea ho potoloha hammoho le lilepe X и Y ka 0 °.
- Tobetsa ka ho le letona ho axis e otlolohileng le ho tsoa ho menu e hlahang khetha Sebopeho sa Axis (Axis ea Format).
- Tšoaea Fetola tatellano ea boleng (Litekanyetso ka tatellano ea morao) - chate ea fani e se e lokile!
Hang ha chate ea hau ea fani e se e lokile 'me e shebane le tsela eo u e batlang, u ka tlosa lileibole tsa data le sehlooho sa chate,' me u iketsetse moralo ho ea kamoo u ratang.
Ka potlako! Haeba chate ea hau e sa theoa holim'a lethathamo le ikhethileng la data, kapa haeba u batla ho fana ka mohopolo feela eseng linomoro tse itseng, ho bonolo ho sebelisa piramite ho tsoa ho SmartArt graphic set.