Zamkatimu
Ngati nthawi zambiri mumapanga malipoti okhala ndi zizindikiro zachuma (KPI) mu Excel, ndiye kuti muyenera kukonda tchati chachilendochi - tchati cha sikelo kapena tchati cha thermometer (Bullet Chart):
- Mzere wofiira wopingasa umasonyeza mtengo womwe tikufuna.
- Kudzaza kwamitundu itatu kwa sikeloyo kumawonetsa bwino madera "oipa-zapakatikati-zabwino" komwe timapeza.
- Rectangle yapakati yakuda ikuwonetsa mtengo wapano wa parameter.
Zachidziwikire, palibe zikhalidwe zam'mbuyomu za parameter pachithunzi chotere, mwachitsanzo, sitiwona zosintha kapena zochitika, koma kuti tiwonetsere zotsatira zomwe zapezedwa motsutsana ndi zolinga pakadali pano, ndizoyenera.
Video
Gawo 1. histogram yokhazikika
Tiyenera kuyamba ndi kupanga histogram yokhazikika kutengera deta yathu, yomwe tidzabweretsa ku mawonekedwe omwe tikufuna munjira zingapo. Sankhani gwero deta, kutsegula tabu Ikani ndi kusankha mbiriyakale ya histogram:
Tsopano tikuwonjezera:
- Kupanga mizati kukhala mzere osati mzere, koma pamwamba pa mzake, kusinthana mizere ndi mizati ntchito batani. Mzere/Chigawo (Mzere/Mzere) tsamba Wopanga (Design).
- Timachotsa nthano ndi dzina (ngati zilipo) - tili ndi minimalism pano.
- Sinthani kudzaza kwamitundu pamizatiyo malinga ndi tanthauzo lake (sankhani imodzi ndi imodzi, dinani kumanja pa yosankhidwa ndikusankha Mtundu wa data point).
- Kuchepetsa tchati m'lifupi
Zotsatirazi ziyenera kuoneka ngati izi:
Gawo 2. Mzere wachiwiri
Sankhani mzere mtengo (rectangle wakuda), tsegulani katundu wake ndi kuphatikiza Ctrl + 1 kapena dinani kumanja pa izo - Format Row (Format Data Point) ndipo pawindo la magawo sinthani mzerewo Mgwirizano wothandizira (Secondary axis).
Mzere wakuda umayenda motsatira nsonga yachiwiri ndikuyamba kuphimba makona ena onse amitundu - musachite mantha, zonse zimagwirizana ndi dongosolo 😉 Kuti muwone sikelo, onjezerani. Chilolezo cham'mbali (Gap) mpaka pamlingo waukulu kuti mupeze chithunzi chofananira:
Kwatentha kale, sichoncho?
Gawo 3. Khalani ndi cholinga
Sankhani mzere Goal (Rectangle yofiira), dinani kumanja kwake, sankhani lamulo Sinthani mtundu wa tchati kukhala mndandanda ndi kusintha mtundu kukhala Madontho (mwaza). Rectangle yofiira iyenera kusandulika kukhala cholembera chimodzi (chozungulira kapena chooneka ngati L), mwachitsanzo:
Popanda kuchotsa zomwe zasankhidwa pano, yatsani Mipiringidzo Yolakwika tsamba Kuyika. kapena pa tabu Constructor (mu Excel 2013). Mitundu yaposachedwa ya Excel imapereka zosankha zingapo pamipiringidzo iyi - yesani nawo ngati mukufuna:
Kuchokera pamalingaliro athu, "ndevu" ziyenera kupatukana mbali zonse zinayi - nthawi zambiri zimagwiritsidwa ntchito kuwonetsa zololera zolondola kapena kubalalika (kubalalitsidwa) kwa zikhalidwe, mwachitsanzo, mu ziwerengero, koma tsopano timazigwiritsa ntchito pazifukwa za prosaic. Chotsani mipiringidzo yoyimirira (sankhani ndikudina batani Chotsani), ndikusintha zopingasa ndikudina kumanja ndikusankha lamulo Mabala Olakwika a Format:
Pazenera la katundu la mipiringidzo yopingasa ya zolakwika mu gawoli Vuto lolakwika Sankhani mtengo wokhazikika or Mwamakonda (Mwambo) ndikuyika mtengo wabwino ndi woipa wa cholakwikacho kuchokera pa kiyibodi yofanana ndi 0,2 - 0,5 (yosankhidwa ndi diso). Apa mutha kuwonjezera makulidwe a bar ndikusintha mtundu wake kukhala wofiira. Cholembera chitha kuyimitsidwa. Chifukwa chake, ziyenera kuchitika motere:
Gawo 4. Kumaliza kukhudza
Tsopano padzakhala matsenga. Yang'anani manja anu: sankhani njira yowonjezera yoyenera ndikusindikiza Chotsani pa keyboard. Mizati yathu yonse yopangidwa, cholozera cholakwika ndi rectangle yayikulu yakuda ya mtengo wapano wamtengo wapatali amachepetsedwa kukhala dongosolo limodzi lolumikizirana ndikuyamba kukonzedwa motsatira mbali imodzi:
Ndi zimenezo, chithunzicho chakonzeka. Zokongola, sichoncho? 🙂
Mwachidziwikire mudzakhala ndi magawo angapo omwe mukufuna kuwonetsa pogwiritsa ntchito ma chart otere. Kuti musabwerezenso saga yonse ndi zomangamanga, mutha kungotengera tchati, ndiyeno (posankha) kukoka rectangle yabuluu ya malo oyambira kuzinthu zatsopano:
- Momwe mungapangire tchati cha Pareto mu Excel
- Momwe mungapangire tchati cha mathithi opatuka ("mathithi" kapena "mlatho") mu Excel
- Zomwe Zatsopano mu Ma chart mu Excel 2013