Avo vanoshanda mukutengesa, kushambadzira, kana chero imwe nzvimbo inoshandisa kana kugamuchira mishumo kubva kune bhizinesi software vanogona kunge vakajairana nekutengesa funnel. Edza kugadzira yako funnel chati uye iwe uchaona kuti zvinoda humwe hunyanzvi. Excel inopa maturusi ekugadzira inverted mapiramidhi, asi zvinoda kushanda nesimba.
Izvi zvinotevera maitiro ekugadzira fanicha chati muExcel 2007-2010 uye Excel 2013.
Maitiro ekugadzira Funnel Chati muExcel 2007-2010
Mifananidzo iri muchikamu ichi yakatorwa kubva kuExcel 2010 yeWindows.
- Simbisa iyo data yaunoda kuisa muchati. Semuyenzaniso, ngatitorei nhamba yevanyoresa vakabatana nepombi (column Nhamba Yeakaundi muPipeline mutafura iri pazasi).
- Pa Advanced tabo Insert (Isa) tinya bhatani bha chati (Column) sarudza Normalized stacked piramidhi (100% yakaturikidzana piramidhi).
- Sarudza rondedzero yedata nekudzvanya pane chero data point.
- Pa Advanced tabo Constructor (Design) muboka Data (Data) tinya bhatani Row column (Chinja Row/Column).
- Kurudyi tinya pane piramidhi uye sarudza XNUMXD Kutenderera (3-D Kutenderera) mune menyu inooneka.
- Shandura kona yekutenderera nematemo X и Y pa 0 °.
- Tinya-kurudyi pane vertical axis uye kubva pane menyu inooneka sarudza Axis Format (Format Axis).
- gupa Reverse order of values (Values in reverse order) - iyo funnel chati yakagadzirira!
★ Verenga zvakawanda muchinyorwa: → Maitiro ekugadzira cheti yekutengesa funnel muExcel
Maitiro ekugadzira Funnel Chati muExcel 2013
Mifananidzo iri muchikamu ichi yakatorwa kubva kuExcel 2013 yeWindows7.
- Simbisa iyo data yaunoda kuisa muchati.
- Pa Advanced tabo Insert (Isa) sarudza Volumetric yakarongedzwa histogram (3-D Yakarongedzerwa Koramu chati).
- Tinya-kurudyi pane chero column uye kubva pane menyu inooneka sarudza Data series format (Format Data Series). Pani yezita rimwechete ichavhurwa.
- Kubva pane zvakarongwa fomu sarudzo, sarudza piramidhi yakakwana (Piramidhi Yakazara).
- Sarudza rondedzero yedata nekudzvanya pane chero data point.
- Pa Advanced tabo Constructor (Design) muchikamu Data (Data) tinya bhatani Row column (Chinja Row/Column).
- Tinya-kurudyi papiramidhi uye kubva pane menyu inooneka sarudza XNUMXD Kutenderera (3-D Kutenderera).
- Mupaneru inooneka Chart Area Format (Format Chart Area) chikamu XNUMXD Kutenderera (3-D Rotation) shandura kona yekutenderera nematemo X и Y pa 0 °.
- Tinya-kurudyi pane vertical axis uye kubva pane menyu inooneka sarudza Axis Format (Format Axis).
- gupa Reverse order of values (Values in reverse order) - iyo funnel chati yakagadzirira!
Kana yako funnel chati yagadzirira uye yakatarisana nenzira yaunoda, unogona kubvisa zvinyorwa zvedata uye zita rechati, uye ita dhizaini sezvaunoda.
Prompt! Kana chati yako isina kubva pane yakatarwa data nhevedzano, kana iwe uchingoda chete kuburitsa pfungwa kwete chaiyo manhamba, zviri nyore kushandisa piramidhi kubva kuSmartArt graphic set.