Pangani ndi kupanga Line Graph mu Excel mu 5 Steps

Mukangowonjezera mzere, pali malangizo othandiza omwe mungagwiritse ntchito

Mu Microsoft Excel, kuwonjezera graph ya mzere pa pepala kapena buku lothandizira limapanga zithunzi zowunikira. Nthawi zina, chithunzithunzi cha detachi chikhoza kusintha zinthu zomwe zingasokonezedwe pamene deta ikuikidwa mumzere ndi mizere.

Kupanga Mzere Wolemba - The Short Version

Njira zowonjezera mzere wofunikira wa graph kapena mzere wa mzere ku tsamba la Excel ndi awa:

1. Onetsani deta kuti muphatikize pa graph - kuphatikiza mzere ndi mitu ya mutu koma osati mutu wa tebulo la deta.
2. Dinani pa Insert tab ya riboni .
3. Mu gawo la Chitsulo cha nkhono, dinani pa chithunzi cha Inseni Cha Chithunzi kuti mutsegule mndandanda wa mitundu yomwe ilipo.
4. Sungani pointer yanu yamagetsi pa mtundu wa chithunzi kuti muwerenge kufotokozera tchati / graph.
5. Dinani pa graph yomwe mukufuna.

Galasi losaoneka bwino lomwe limangosonyeza mizere yomwe ikuimira mndandanda wa deta , mutu wosasinthika wa tchati, nthano, ndi nkhwangwa zowonjezera - zidzawonjezeredwa pa tsamba lamasamba.

Kusiyana kwa Mabaibulo

Masitepe a pulogalamuyi amagwiritsira ntchito mazokondedwe ndi machitidwe omwe alipo mu Excel 2013. Izi zimasiyana ndi zomwe zapezeka kumayambiriro kwa pulogalamuyi. Gwiritsani ntchito maulumikizi otsatirawa pazithunzithunzi zamagulu a mzere pazolembedwa zina za Excel.

• Excel 2010 ndi 2007 Line Graph Tutorial
• Excel 2003 (ndi matembenuzidwe oyambirira) Maphunziro a Girasi Mzere

Chidziwitso pa mutu wa Excel Colors

Excel, monga mapulogalamu onse a Microsoft Office, amagwiritsa ntchito malemba kuti ayang'ane mawonekedwe ake. Malingana ndi mutu womwe mumagwiritsa ntchito potsatira phunziroli, mitundu yomwe ili muzochitikazi sizingakhale zofanana ndi zomwe mukugwiritsa ntchito. Mukhoza kusankha mutu uliwonse womwe mumakonda ndi kupitiriza.

Kupanga Line Graph - The Long Version

Zindikirani: Ngati mulibe deta yomwe ili pafupi kuti mugwiritse ntchito ndi phunziroli, ndondomeko za phunziroli zimagwiritsa ntchito deta yosonyezedwa pa chithunzi pamwambapa.

Kulowetsa deta ina nthawi zonse kumayambitsa galasi-ziribe kanthu mtundu wa graph kapena tchati chomwe chikulengedwa.

Khwerero yachiwiri ndikuwonetsera deta yomwe ingagwiritsidwe ntchito popanga graph. Deta yosankhidwa kawirikawiri imaphatikizapo maudindo a mndandanda ndi mitu ya mzere, yomwe imagwiritsidwa ntchito ngati malemba mu tchati.

1. Lowetsani deta yosonyezedwa mu chithunzi pamwamba pa maselo ofiira a masamba .
2. Mukalowa, onetsetsani maselo osiyanasiyana kuchokera ku A2 mpaka C6.

Posankha deta, mndandanda ndi mitu ya mndandanda ikuphatikizidwa muchisankho, koma mutu womwe uli pamwamba pa tebulo la deta siili. Mutuwo uyenera kuwonjezeredwa pa graph pamanja.

Kupanga Basic Line Graph

Masitepe otsatirawa adzalenga mzere wofunikira - galasi, yosasinthika - yomwe ikuwonetsera mndandanda wa data ndi zisonga.

Pambuyo pake, monga tafotokozera, phunziroli likufotokoza momwe mungagwiritsire ntchito zina zomwe zimagwiritsidwa ntchito popanga maonekedwe, omwe, ngati atatsatira, adzasintha galasi loyambirira kuti lifanane ndi mzere wa mzere womwe wasonyeza pa phunziro loyamba la phunziroli.

1. Dinani pa Insert tab ya riboni.
2. M'chigawo cha Chitsamba cha menyu yachitsulo, dinani chithunzi cha Insert Chart kuti mutsegule mndandanda wa ma graph / tchati.
3. Sungani pointer yanu ya mouse pamtundu wa graph kuti muwerenge kufotokoza kwa graph.
4. Dinani pa mtundu woyamba wa mzere wa mzere wolemba mndandanda kuti muwasankhe.
5. Mzere watsopano wajambula umapangidwira ndi kuikidwa pa tsamba lanu la ntchito monga momwe tawonetsera pa chithunzichi pamzere wotsatira pansipa.

Kupanga Malemba Oyamba Mzere Gawo: Kuwonjezera Mutu wa Chati

Sinthani Chinthu Chachidule cha Chinthu podindikiza pawiri kawiri koma osawirikizapo

1. Dinani kamodzi pa mutu wosasinthika wa chithunzi kuti muwusankhe - bokosi liyenera kuwonekera kuzungulira mawu Chart Title.
2. Dinani kachiwiri kuti muike Excel mu edit mode , yomwe imaika cursor mkati mwa mutu wa bokosi.
3. Chotsani malemba osasintha pogwiritsa ntchito makiyi Otsala / Backspace pa makiyi.
4. Lowani mutu wa tchati - Avereji Kutha (mm) - mu mutu wa mutu

Kulimbana ndi Gawo Lolakwika la Tchati

Pali zigawo zambiri pa tchati mu Excel - monga mutu wa tchati ndi malemba, malo amaloli omwe ali ndi mizere yomwe ikuimira deta yosankhidwa, zowonongeka ndi zowoneka bwino, ndizithunzi zoyendetsera.

Zonsezi zimaonedwa ngati zosiyana ndi pulogalamuyo, ndipo, motere, aliyense akhoza kupangidwa mosiyana. Mumawuza Excel yomwe gawo la graph mukufuna kulisintha mwa kuyika pa iyo ndi ndondomeko ya mouse kuti muisankhe.

Phunziroli, ngati zotsatira zanu sizifanana ndi zomwe zalembedwa, ndizotheka kuti mulibe gawo loyenerera la tchati yomwe mwasankha pamene mukugwiritsa ntchito njirayi.

Kulakwitsa kowonjezeka kwambiri ndiko kukudutsa gawo la chiwembu pakati pa graph pamene cholinga chake ndi kusankha grafu yonse.

Njira yosavuta yosankhira galasi lonse ndikukweza pamwamba kumanzere kapena kumanzere kumbali ya mutu wa tchati.

Ngati kulakwitsa kuli kupangidwa, ikhoza kusinthidwa mofulumira pogwiritsa ntchito chithunzi cha Excel. Pambuyo pake, dinani mbali yoyenera ya tchati ndikuyesanso.

Kusintha Magulu a Girasi Kugwiritsira Ntchito Zida Zamatcha Chachi

Pamene tchati / graph imapangidwa mu Excel, kapena pamene pali grafu yomwe imakhala yosankhidwa podalira pa iyo, ma tebulo awiri akuwonjezeredwa ku riboni monga momwe tawonetsera pa chithunzi pamwambapa.

Ma tebulo a Chart Tools - Kulinganiza ndi Mafomu - ali ndi mawonekedwe ndi machitidwe omwe angapangidwe pazithunzi, ndipo adzagwiritsidwa ntchito pamasitepe otsatirawa kusintha masomphenya ndi zithunzi za graph.

Kusintha Maonekedwe a Girasi

Pa grayiyi, kujambula maziko ndi magawo awiri chifukwa chophatikizidwa chikuwonjezeredwa kusonyeza kusintha pang'ono kwa mtundu wozungulira pa graph.

1. Dinani kumbuyo kuti musankhe grafu yonse.
2. Dinani Tabu ya Tsamba ya Riboni.
3. Dinani pa Fomu Yodzaza njira, yotchulidwa mu chithunzi pamwamba, kuti mutsegule Zotsitsa Zotsitsa pansi.
4. Sankhani Black, Text 1, Lighter 35% kuchokera gawo la Masewera a Mndandanda wa mndandanda.
5. Dinani pazomwe Mungakwaniritse Zomwe mwasankha kachiwiri kuti mutsegule Masewera otsika pansi.
6. Sungani pointer ya mouse pamasankhidwe a Gradient pafupi ndi pansi pa mndandanda kuti mutsegule gulu lalikulu.
7. Mu gawo la Kusiyana kwa Mdima kwa gululo, dinani pa Linear kumanzere mungachite kuti muwonjezere chizindikiro chomwe chimakhala chakuda mdima pang'ono kuchokera kumanzere kupita kumanja.

Kusintha Maonekedwe a Mtundu

Tsopano kuti mazikowo ndi ofiira, malemba osasinthika wakuda sakuwonekeranso. Gawo lotsatirali likusintha mtundu wa malemba onse pa graph kuti ayambe kuyera

1. Dinani kumbuyo kuti musankhe grafu yonse.
2. Dinani Tabu ya Tsamba ya Riboni ngati kuli kofunikira.
3. Dinani Lembalo Lembani njira kuti mutsegule ndandanda yolemba pansi.
4. Sankhani White, Background 1 kuchokera ku gawo la Masewera a Mitu ya mndandanda.
5. Zonsezi mu mutu, x ndi y axes, ndi nthano ziyenera kusintha.

Kusintha Mizere Yowonjezera: Kupangidwira mu Pawindo la Ntchito

Mapazi awiri omaliza a phunziroli amagwiritsira ntchito mapangidwe a ntchito pamanja , omwe ali ndi mitundu yambiri yopangira ma chart.

Mu Excel 2013, pamene atsegulidwa, mawonekedwewo akuwonekera kumanja kwa dzanja la Excel pulogalamu monga momwe tawonetsera pa chithunzi pamwambapa. Mutu ndi zosankha zomwe zikuwonekera pazithunzi zimasintha malinga ndi dera lomwe lasankhidwa.

Kusintha Mzere Wa Mtundu wa Acapulco

1. Mu graph, dinani kamodzi pa mzere wa lalanje wa Acapulco kuti muisankhe - zilembo zazing'ono ziyenera kuonekera pamtunda wa mzere.
2. Dinani pa tabu ya foni ya riboni ngati kuli kofunikira.
3. Kumanzere kumanzere kwa riboni, dinani pa Chosankha Chosintha Chojambula kuti mutsegule Pulogalamu Yoyenera Kujambula .
4. Popeza kuti mzere wa Acapulco unasankhidwa kale, mutu womwe uli pamtunduwu uyenera kuwerengera Format Data Series.
5. M'kati, dinani pazithunzi Zodzaza (utoto ukhoza) kutsegula mndandanda wa Zolemba.
6. Pa mndandanda wa zosankha, dinani pazithunzi Zodzaza pafupi ndi chizindikiro Chakumanja kuti mutsegule mndandanda wa Line Colors.
7. Sankhani Zobiriwira, Zozizwitsa 6, Zowonongeka 40% kuchokera ku gawo la Mndandanda wa Mndandanda wa mndandanda - mzere wa Acapulco uyenera kusintha ku mtundu wobiriwira.

Kusintha Amsterdam

1. Mu graph, dinani kamodzi pa mzere wofiira wa Amsterdam kuti muisankhe.
2. Mu Formatting task pane, mtundu wa Zamakono zodzazidwa pansi pa chizindikirocho ziyenera kusintha kuchokera kubiriwira kupita ku buluu zosonyeza kuti mawonekedwewa tsopano akuwonetsera zosankha za Amsterdam.
3. Dinani pa Chithunzi chodzaza kuti mutsegule mndandanda wa Line Colours.
4. Sankhani Buluu, Mphindi 1, Wowonongeka 40% kuchokera ku gawo la Mndandanda wa Masewera - mzere wa Amsterdam uyenera kusinthika ku mtundu wobiriwira.

Inachotsedwa pa Gridlines

Kusinthika kotsirizira kotsirizira komwe kumapangidwira ndikusintha magalasi omwe amayenderera pamzere pa graph.

Mzere wotsatira wa graph umaphatikizapo ma gridlineswa kuti apange mosavuta kuwerengera mfundo zenizeni pazitsulo.

Komabe, iwo samayenera kukhala otchuka kwambiri. Njira imodzi yosavuta kuiwongolera ndiyo kusintha malingaliro awo pogwiritsa ntchito Masitimu a Tasintha.

Mwachibadwidwe, chiwonetsero chawo ndi 0%, koma powonjezera, magalasiwa adzafalikira kumbuyo komwe ali.

1. Dinani pa Chosankhidwa Chosintha Maonekedwe pa Tabu ya Tsamba la Riboni ngati kuli kofunikira kuti mutsegule Pulogalamu Yoyenera Kujambula
2. Pa graph, dinani kamodzi pamtunda wa 150mm womwe ukuyenda pakati pa galasi - magalasi onse ayenera kufotokozedwa (madontho a buluu kumapeto kwa gulu lililonse)
3. M'kati mwake kusintha msinkhu kufika pa 75% - ma filimu pa graph ayenera kufota kwambiri