Nzira yekugadzira Chati yeMvura mumisiyano yapfuura yeMicrosoft Excel yaive nehanya uye yaifungidzirwa seyakanyanya kuoma. Zvakangodaro, zviri nyore kugadzira Waterfall Chart muExcel 2016.
Gadzira Waterfall Chati muExcel
Machati emapopoma anogona kushandiswa zvinobudirira semuenzaniso wekubudirira kwechiitwa pane imwe nguva yakatarwa, inofananidzwa nekuyerera kwemari, mitengo yekushanda, kufambira mberi muvatengi, kufambira mberi muvagari kana kugona kwemari.
Mune yakajairika Waterfall chati, Yekutanga uye Yekupedzisira Koramu inotangisa Yese Yekutanga uye Yese Yekupedzisa Values, nepo ari epakati akayangarara makoramu anoratidza inovaka kana inoparadza mipiro pamusoro penguva yakatarwa.
Machati eMapopoma emvura akakwidziridzwa neanobvunza agency McKinsey & Firm iyo yakavashandisa mumitambo yavo yese kune vatengesi.
Matanho ekugadzira Waterfall Chati muExcel
Kuti tijekese kusikwa kweMapopoma Charts muExcel, tibvumire kufunga nezvenyaya yekufungidzira yekambani ine Mari yekutanga ye5,000 pakutanga kwegore uye webhu mwedzi-kusvika-mwedzi mari inoyerera kukosha kwemwedzi gumi nemiviri inotevera.
Zvakafanana nechero bhizinesi, iyo Internet Mwedzi-kusvika-Mwedzi Mari Inoyerera inosanganisira imwe neimwe inovaka uye inoparadza nhamba, zvichienderana nemusiyano pakati pemihoro nemabhiri mumwedzi wakapihwa.
Nhanho yekutanga mukugadzira Waterfall Chart ndeyekuita kuti zvikwanise kuti ruzivo rwakapihwa ruve nePreliminary uye Ending kukosha. Muchiitiko chedu, Ending Worth ($ 24,700) ndiyo yakazara mari yekutanga uye Mwedzi-kusvika-mwedzi mari inokosha.
Paunenge uchingomufadza nesangano reruzivo, iwe unogona kungoona nhanho dziri pasi pekugadzira mvura yemvura muExcel.
1. Sarudzai ruzivo kuti iwe unongoda kugadzira iyo Waterfall Chati kubva.
2. Zvadaro, tinya pane iyo Insert tab mushure mezvo tinya pa Machati anobatsira chaizvo.
3. Pa Insert Chart kuratidza, tinya pa All Charts > Waterfall Chart sarudza mukati meiyo chikamu menyu uye tinya pane iyo OK bhatani.
4. Paunodzvanya pakanzi OK, Microsoft Excel ichagadzira marobhoti Chati yeMapopoma zvichibva paruzivo rwako uye Chati ichaonekwa mukati mebepa rako rebasa.
Iwe unogona kufambisa iyo Waterfall Chati nekuidhonza uye nekuwedzera shandura kuyerwa kwayo sezvinodiwa.
5. Ikozvino, kugadzira Waterfall kukanganisa, iwe unofanirwa kuseta yega yega Yekutanga uye Pedzisa Ruzivo Zvinhu seMakoshi Akazara.
Kuti uite izvozvo, sarudza Preliminary yakakosha chete (nekudzvanya kaviri pairi), tinya-kurudyi pane Preliminary Worth wobva wadzvanya pa Set as Whole chisarudzo.
Zvakangofanana, sarudza iyo Finish Worth, tinya-kurudyi pane Finish Worth wobva wadzvanya pa Set as Whole sarudza mukati memenu inoratidzika.
6. Kana maPreliminary and Finish Values achinge asungwa, unogona kuFometa iyo Waterfall Chart. Muchiitiko chedu, takashandura ruvara rwemhando dzinovaka kune Unexperienced uye Inoparadza tsika kuva Purple.
Tip: Iwe unogona kusarudza zvese Zvinoparadza kana Kuvaka Ruzivo zvinhu mukati meChati nekudzvanya kaviri pakanzi "Kuvandudza" uye "Kudzika" mukati meNgano (Ona mufananidzo uri pazasi).
Mushure mekufunga nezvezvinhu zveruzivo, zvinokwanisika kuti iwe usiyane yavo Ruvara uye Format ivo sezvinodiwa.
Sezvambotaurwa pamusoro apa, chete Excel 2016 uye gare gare misiyano inofanirwa kuchinjika kugadzira marobhoti kugadzira Waterfall Charts kubva kune ruzivo rwakapihwa.
- Munhu angagadzira sei Pivot Tafura muExcel
- Munhu angashandisa sei INDEX MATCH Perform muExcel
Zita rangu ndiJavier Chirinos uye ndine shungu nezve tekinoroji. Kwenguva yakareba sezvandinogona kuyeuka, ndaifarira makombiyuta nemitambo yemavhidhiyo uye chitandadzo ichocho chakaguma ndava kubasa.
Ndanga ndichiburitsa nezve tekinoroji uye zvishandiso paInternet kweanopfuura makore gumi nemashanu, kunyanya mu mundobytes.com
Ini zvakare ndiri nyanzvi mukukurukurirana kwepamhepo uye kushambadzira uye ndine ruzivo rwekuvandudza WordPress.