Momwe mungapangire tchati cha mathithi

Nthawi zambiri ndimakumana ndi malipoti amakampani osiyanasiyana ndikumva zopempha kuchokera kwa ophunzira kuti afotokoze momwe chithunzithunzi chazolowera chimamangidwira - ndi "mathithi", ndi "mathithi", ndi "mlatho". ", ndi "mlatho", ndi zina zotero. Zikuwoneka motere:

Patali, zikuwoneka ngati mathithi amadzi pamtsinje wamapiri kapena mlatho wopachikidwa - ndani amawona zomwe 🙂

Chodabwitsa cha chithunzi chotere ndi chakuti:

• Tikuwona bwino mtengo woyamba komanso womaliza wa parameter (mizati yoyamba ndi yomaliza).
• Zosintha zabwino (kukula) zimawonetsedwa mumtundu umodzi (nthawi zambiri wobiriwira), ndi zoipa (zochepa) kwa ena (nthawi zambiri wofiira).
  
• Nthawi zina tchaticho chingakhalenso ndi magawo ang'onoang'ono (imvianatera pa nsanamira za x-axis).
  

M'moyo watsiku ndi tsiku, zithunzi zotere zimagwiritsidwa ntchito pazifukwa izi:

• zithunzi chiwonetsero cha dynamics njira iliyonse munthawi yake: kuyenda kwa ndalama (kutuluka kwandalama), mabizinesi (timayika ndalama mu projekiti ndikupeza phindu).
• Kuwonetseratu kukhazikitsa dongosolo (gawo lakumanzere kwambiri lachithunzichi ndi chowonadi, chakumanja kwenikweni ndi pulani, chithunzi chonse chikuwonetsa njira yathu yolowera ku zotsatira zomwe tikufuna)
• Pamene mukufuna zowoneka onetsani zinthuzomwe zimakhudza gawo lathu (factorial kusanthula phindu - zomwe zimapanga).
  

Pali njira zingapo zopangira tchati chotere - zonse zimatengera mtundu wanu wa Microsoft Excel.

Njira 1: Yosavuta: Mtundu womangidwa mu Excel 2016 ndi watsopano

Ngati muli ndi Excel 2016, 2019 kapena mtsogolo (kapena Office 365), ndiye kuti kupanga tchati chotere sikovuta - mitundu iyi ya Excel ili kale ndi mtundu uwu womangidwa mokhazikika. Zidzakhala zofunikira kusankha tebulo ndi deta ndikusankha pa tabu Ikani (Ikani) lamulo kugwedeza (Mathithi):

Zotsatira zake, tipeza chithunzi chokonzekera bwino:

Mutha kukhazikitsa nthawi yomweyo mitundu yodzaza yomwe mukufuna pamagawo abwino komanso oyipa. Njira yosavuta yochitira izi ndikusankha mizere yoyenera Wonjezani и kuchepa mwachindunji mu nthano ndi kuwonekera-kumanja pa iwo, kusankha lamulo Lembani (Dzazani):

Ngati mukufuna kuwonjezera mizati yokhala ndi ma subtotals kapena gawo lomaliza pa tchati, ndiye kuti ndikosavuta kuchita izi pogwiritsa ntchito ntchito. ZONSE ZONSE (ZAMBIRI) or UNIT (AGGREGATE). Awerengera ndalama zomwe zasonkhanitsidwa kuyambira koyambirira kwa tebulo, osaphatikizamo ziwerengero zofanana zomwe zili pamwambapa:

Pachifukwa ichi, mkangano woyamba (9) ndi ndondomeko ya ntchito ya masamu, ndipo yachiwiri (0) imapangitsa kuti ntchitoyi isanyalanyaze ziwerengero zomwe zawerengedwa kale pazotsatira.

Pambuyo powonjezera mizere yokhala ndi ziwopsezo, imatsalira kuti musankhe mizati yonse yomwe yawonekera pazithunzi (pangani kudina kuwiri kotsatizana pamndandanda) ndipo, podina kumanja pa mbewa, sankhani lamulo. Khazikitsani zonse (Khalani zonse):

Mzere wosankhidwa udzatera pa x-axis ndikusintha mtundu kukhala imvi.

Izi, kwenikweni, ndizo zonse - chithunzi cha mathithi chakonzeka:

Njira 2. Universal: mizati yosaoneka

Ngati muli ndi ma Excel 2013 kapena akale (2010, 2007, etc.), ndiye kuti njira yomwe tafotokozayi siyikugwira ntchito kwa inu. Muyenera kuzungulira ndikudula tchati cha mathithi chomwe chikusowa kuchokera pa histogram yokhazikika (kuphatikiza mipiringidzo pamwamba pa inzake).

Chinyengo apa ndikugwiritsa ntchito mizati yowonekera kuti ikweze mizere yathu yofiira ndi yobiriwira mpaka kutalika koyenera:

Kuti tipange tchati chotere, tifunika kuwonjezera mizati yowonjezereka yokhala ndi mafomula ku data yoyambira:

• Choyamba, tiyenera kugawa gawo lathu loyambirira polekanitsa zabwino ndi zoyipa m'mizere yosiyana pogwiritsa ntchito ntchitoyi. IF (NGATI).  
• Kachiwiri, muyenera kuwonjezera ndime kutsogolo kwa mizati pacifiers, pamene mtengo woyamba udzakhala 0, ndipo kuyambira pa selo yachiwiri, ndondomekoyi idzawerengera kutalika kwa mizati yowonekera kwambiri.
  

Pambuyo pake, imatsalira kusankha tebulo lonse kupatula gawo loyambirira otaya ndi kupanga histogram yokhazikika yokhazikika kudutsa Inset - Histogram (Lowetsani - Mzere Tchati):

Ngati tsopano mwasankha mizati yabuluu ndikupangitsa kuti isawoneke (dinani kumanja pa izo - Mtundu wa Mzere - Dzazani - Palibe Kudzaza), ndiye timangopeza zomwe tikufuna. 

Ubwino wa njirayi ndi kuphweka. Mu minuses - kufunika kowerengera mizati yothandizira.

Njira 3. Ngati tipita ku zofiira, zonse zimakhala zovuta kwambiri

Tsoka ilo, njira yapitayi imangogwira ntchito mokwanira pamakhalidwe abwino. Ngati osachepera m'madera ena mathithi athu amapita kudera loipa, ndiye kuti zovuta za ntchitoyi zimakula kwambiri. Pankhaniyi, padzakhala kofunikira kuwerengera mzere uliwonse (dummy, wobiriwira ndi wofiira) padera pazigawo zoipa ndi zabwino ndi mafomu:

Kuti musavutike kwambiri komanso kuti musayambitsenso gudumu, template yokonzedwa bwino yamilandu yotere ikhoza kutsitsidwa pamutu wa nkhaniyi.

Njira 4. Zachilendo: magulu okwera-pansi

Njirayi idakhazikitsidwa pakugwiritsa ntchito chinthu chapadera chodziwika bwino cha ma chart athyathyathya (histograms ndi ma graph) - Magulu apamwamba (Mabala Okwera Pansi). Maguluwa amalumikiza mfundo za ma graph awiri awiriawiri kuti awonetse bwino kuti ndi mfundo ziti zomwe zili zapamwamba kapena zotsikirapo, zomwe zimagwiritsidwa ntchito mwachangu powonera mfundo ya pulani:

N'zosavuta kudziwa kuti ngati tichotsa mizere ya ma chart ndikusiya magulu okhawo omwe ali pamwamba pa tchati, ndiye kuti tidzapeza "mathithi" omwewo.

Pakumanga kotereku, tifunika kuwonjezera mizati iwiri yowonjezera patebulo lathu ndi mafomu osavuta omwe angawerengere momwe ma graph awiri osawoneka amafunikira:

Kuti mupange "mathithi", muyenera kusankha ndime yokhala ndi miyezi (yosaina pa X axis) ndi zigawo ziwiri zowonjezera. Sungani 1 и Sungani 2 ndi kupanga graph yokhazikika yoyambira kugwiritsa ntchito Ikani – Grafu (Lowetsani - Line Сhart):

Tsopano tiyeni tiwonjeze magulu okwera-pansi pa tchati chathu:

• Mu Excel 2013 ndi zatsopano, izi ziyenera kusankhidwa pa tabu Constructor lamulo Onjezani Chart Element - Miyezo yowonjezera-kuchepa (Kupanga - Onjezani Chart Element - Mipiringidzo Yokwera Pansi)
• Mu Excel 2007-2010 - pitani ku tabu Kamangidwe - Mipiringidzo Yochepetsera Patsogolo (Masanjidwe - Mipiringidzo Yokwera Pansi)

Kenako tchaticho chidzawoneka motere:

Zimatsalira kusankha ma graph ndikuwapangitsa kukhala owonekera podina pawo ndi batani lakumanja la mbewa ndikusankha lamulo. Mawonekedwe a mndandanda wa data (Fomati mndandanda). Momwemonso, mutha kusintha mawonekedwe, m'malo mowoneka ngati mizere yakuda ndi yoyera kukhala yobiriwira ndi yofiira kuti mukhale ndi chithunzi chabwino pamapeto pake:

M'matembenuzidwe aposachedwa a Microsoft Excel, kukula kwa mipiringidzo kungasinthidwe podina pazithunzi zowonekera (osati mipiringidzo!) Ndi batani lakumanja la mbewa ndikusankha lamulo. Mawonekedwe a Mndandanda wa Data - Chilolezo Chammbali (Mndandanda wamtundu - Gap wide).

M'mitundu yakale ya Excel, mumayenera kugwiritsa ntchito Visual Basic lamulo kuti mukonze izi:

1. Onetsani chithunzi chomangidwa
2. Dinani njira yachidule ya kiyibodi alt+F11kuti mulowe mu Visual Basic Editor
3. Dinani njira yomasulira Ctrl+Gkuti mutsegule zolowetsa zachindunji ndi gulu lowongolera mwamsanga (nthawi zambiri imakhala pansi).

4. Koperani ndi kumata lamulo ili pansipa: ActiveChart.ChartGroups(1).GapWidth = 30 Ndi kukanikiza Lowani:

Mukhoza, ndithudi, kusewera mozungulira ndi mtengo wa parameter ngati mukufuna. GapWidthkuti mupeze chilolezo chomwe mukufuna:

• Momwe mungapangire tchati cha bullet mu Excel kuti muwone KPI  
• Zomwe Zatsopano mu Ma chart mu Excel 2013
• Momwe mungapangire tchati cha "live" mu Excel