Ngati mukufuna kupanga tchati mu Excel ndi / kapena mapepala a Google, ndizofunika kumvetsa tanthauzo la deta, zizindikiro za deta, ndi ma data.
Kumvetsetsa Kugwiritsa Ntchito Data Series ndi Zojambula Zina Zina mu Excel
Mfundo ya deta ndi mtengo umodzi womwe uli mu selo lopangira ntchito lomwe lakonzedwa mu tchati kapena graph .
Chizindikiro cha deta ndi chidutswa chachitsulo, chidutswa, chidutswa cha pie, kapena chizindikiro china mu tchati chomwe chikuimira kufunika kwake pa tchati. Mwachitsanzo, mu gradi ya mzere, mfundo iliyonse pa mzere ndi chizindikiro cha deta choyimira chiwerengero chimodzi cha deta chomwe chili mu selo lopangira .
Deta ya deta imapereka chidziwitso chodziwitsa munthu aliyense, monga kufunika kukhala graphed kaya nambala kapena peresenti.
Zolemba zomwe zimagwiritsidwa ntchito kawirikawiri zimaphatikizapo:
- Mawerengedwe a Numeri - otengedwa kuchokera kuzipangizo zapadera pa tsamba la ntchito ;
- Mayina a mndandanda - onetsetsani zikhomo kapena mizere ya deta zadongosolo pamtundu. Amagwiritsidwa ntchito kawirikawiri pamabuku a timapepala, timatabwa timatabwa, ndi ma graph;
- Maina a mndandanda - amadziŵikitsa mfundo zapadera pa deta limodzi. Amagwiritsidwa ntchito kawirikawiri pamapirati a pie;
- Malemba a chiwerengero - amawerengedwa pogawaniza munda pawokha mndandanda ndi chiwerengero cha mndandanda. Amagwiritsidwa ntchito kawirikawiri pamapirati a pie;
Mndandanda wa deta ndi gulu la mfundo zofanana kapena zolemba zomwe zalongosoledwa m'ma chart ndi ma grafu. Zitsanzo za mndandanda wa deta ndi:
- Mzere uliwonse pa graph ya mzere
- Zithunzi payekha m'ndandanda
Pamene mndandanda wa deta wambiri umakonzedwa mu tchati imodzi, mndandanda uliwonse wa deta umadziwika ndi mtundu wapadera kapena mthunzi.
Pankhani yachitsulo kapena timatabwa ta bar, ngati mizati yambiri kapena mipiringidzo ndi yofanana, kapena ali ndi chithunzi chomwecho pa zojambulajambula , zimakhala ndi mndandanda umodzi wa deta.
Mapepala a piya nthawi zambiri amangokhala pa mndandanda umodzi wa deta pa tchati. Zigawo zapadera za pie ndi zizindikiro za deta m'malo mndandanda wa deta.
Kusintha Momwe Mungagwiritsire Ntchito Chizindikiro Chake
Ngati ndondomeko iliyonse ya deta ndi yofunika m'njira inayake, kukonzekera kwa chiwerengero cha deta chomwe chikuimira ndondomekoyi pa tchatichi kungasinthidwe kuti chikhomocho chidziwike pazinthu zina mndandanda.
Mwachitsanzo, mtundu wa chigawo chimodzi m'ndandanda ya mzere kapena ndime imodzi mu mzere wa mzere ungasinthidwe popanda kukhudza mfundo zina mndandanda mwa kutsatira ndondomeko zotsatirazi.
Kusintha Mtundu wa Khola Limodzi
- Dinani kamodzi pa mndandanda wa deta mndandanda wa mndandanda. Mizere yonse ya mtundu womwewo mu tchati iyenera kuwonetsedwa. Mzere uliwonse uli ndi malire omwe ali ndi madontho ang'onoang'ono pamakona.
- Dinani kachiwiri pa ndimeyo mu tchati kuti isinthidwe-kokha ndimeyo iyenera kuwonetsedwa.
- Dinani pa tabu Yopangidwira ya riboni, imodzi mwazolemba zomwe zawonjezeredwa ku riboni pamene chithunzi chasankhidwa.
- Dinani pazithunzi Pangani mawonekedwe kuti mutsegule Menyu Yodzaza Mitambo.
- Mu gawo la Standard Colors la menyu musankhe Buluu.
Mndandanda womwewo ungagwiritsidwe ntchito kusintha mfundo imodzi pamzere wa mzere. Ingosankha kadontho kayekha (chizindikiro) pa mzere m'malo mwa chigawo chimodzi.
Kugwiritsa ntchito Pie
Popeza magawo awiri a tchati cha pie amayamba ndi mitundu yosiyanasiyana, kutsindika kagawo kamodzi kapena deta kumafunika njira yosiyana ndi yomwe imagwiritsidwa ntchito pazithunzi ndi mzere.
Kugogomezedwa kumawonjezeredwa kuti apange mapepala amapepala powatulutsa chidutswa chimodzi cha chitumbuwa kuchokera pazithunzi zonsezo.
Onjezerani Kulimbitsa Ndi Chithunzi cha Combo
Njira ina yosindikizira mitundu yosiyanasiyana ya chithunzi pa tchati ndikuwonetsa mitundu iwiri kapena yambiri ya tchati mu tchati imodzi, monga tchati cha mzere ndi graph.
Njirayi imatengedwa pamene zoyenera kukhala graphed zimasiyanasiyana, kapena pamene deta zosiyanasiyana zimakhala graphed. Chitsanzo chofala ndi climatograph kapena graph ya nyengo, yomwe imagwirizanitsa dera ndi kutentha deta pamalo amodzi pa tchati chimodzi.
Zokambirana kapena zojambulazo zimapangidwa mwa kukonza chimodzi kapena zingapo zotsatizana za deta pambali yowonjezera kapena Y yotsatizana.