Madzulo abwino
Nkhani yamakono ili ndi zithunzi. Mwinamwake aliyense yemwe anayamba wapanga ziwerengero, kapena kupanga mapulani ena - nthawizonse amayenera kupereka zotsatira zawo mwa mawonekedwe a grafu. Kuwonjezera apo, zotsatira za mawerengedwe mu mawonekedwe awa zimadziwika mosavuta.
Ine ndinathamanga ku grafu kwa nthawi yoyamba pamene ndikupereka ndemanga: kuti ndisonyeze bwino omvetsera kumene angakonzekere phindu, simungaganizepo kanthu ...
M'nkhaniyi ndikufuna ndikuwonetseni chitsanzo cha momwe mungapangire grafu ku Excel m'mawu osiyana: 2010 ndi 2013.
Mndandanda wapadera kuchokera mu 2010 (mu 2007 - mofananamo)
Tiyeni tiwoneke mosavuta, kumanga mu chitsanzo changa, ndikutsogolera ndi masitepe (monga m'nkhani zina).
1) Tiyerekeze kuti Excel ili ndi tebulo yaying'ono ndi zizindikiro zingapo. Mu chitsanzo changa, ndinatenga miyezi ingapo ndi mitundu yambiri ya phindu. Mwachidziwikire, sikofunika kwambiri kuti tikhale ndi manambala, ndikofunikira kumvetsa mfundo ...
Kotero, timangosankha malo a tebulo (kapena tebulo lonse), pa maziko omwe tidzamanga galasi. Onani chithunzi pansipa.
2) Pambuyo pake, pamutu wapamwamba wa Excel, sankhani gawo la "Insert" ndipo dinani pa "Galama" ndime, kenako sankhani grafu yomwe mukufunikira kuchokera kumenyu yotsitsa. Ndasankha imodzi yosavuta - yowerengeka, pamene mzere wolunjika wamangidwa motsatira mfundozo.
3) Chonde dziwani kuti molingana ndi piritsi, tili ndi mizere itatu yosweka pa graph, kusonyeza kuti phindu likugwa mwezi ndi mwezi. Mwa njira, Excel imangotanthauzira mzere uliwonse pa graph - ndi yabwino kwambiri! Ndipotu ndondomekoyi ingakopedwe mpaka kuwonetsero, ngakhale mu lipoti ...
(Ndikukumbukira momwe kusukulu tinatengera graph yaing'ono kwa theka la tsiku, tsopano ikhoza kulengedwa maminiti asanu pa kompyuta iliyonse pomwe pali Excel ... Njira inayake ikupita patsogolo, komabe.)
4) Ngati simukukonda zojambulajambula zojambulajambula, mukhoza kuzikongoletsa. Kuti muchite izi, dinani kawiri pa graph ndi batani lamanzere - zenera liwonekera pamaso panu momwe mungasinthe mosavuta kupanga. Mwachitsanzo, mukhoza kudzaza grafu ndi mtundu wina, kapena kusintha mtundu wa malire, mafashoni, kukula, ndi zina zotero. Pendani ma tepi - Excel iwonetseratu zomwe graph idzawoneka ngati mutasunga zonse zomwe zidalowa.
Mungamange bwanji graph ku Excel kuyambira 2013.
Mwa njira, yomwe ndi yachilendo, anthu ambiri amagwiritsa ntchito mapulogalamu atsopano, amasinthidwa, Ofesi ndi Mawindo okha sagwiritsa ntchito izi ... Ambiri a abwenzi anga akugwiritsabe ntchito Windows XP ndi machitidwe akale a Excel. Zimanenedwa kuti anali atapatsidwa mphamvu, ndipo n'chifukwa chiyani amasintha pulogalamu ya ntchito ... Kuyambira Ndasinthidwa kale ku 2013, ndinaganiza kuti ndikufunika kusonyeza momwe angapangire grafu mu Excel yatsopano. Mwa njira, kuchita zonse kumakhala zofanana, chinthu chokhacho muchinenero chatsopano ndicho chakuti okonzanso achotsa mzere pakati pa graph ndi chithunzi, kapena, mofananamo, akuphatikiza.
Ndipo kotero, mu masitepe ...
1) Mwachitsanzo, ndinatenga ndondomeko yomweyo monga kale. Chinthu choyamba chimene timachita ndi kusankha piritsi kapena gawo losiyana, limene tidzamanga galasi.
2) Kenako, pitani ku gawo la "INSERT" (pamwambapa, pafupi ndi "FILE" menyu) ndipo sankhani batani "Makalata Ovomerezedwa". Pawindo lomwe likuwoneka, timapeza graph yomwe tikusowa (Ndinasankha njira yamakono). Kwenikweni, mutatha kuwonekera "Chabwino" - ndondomeko idzawonekera pafupi ndi piritsi lanu. Ndiye mukhoza kusunthira ku malo abwino.
3) Kusintha ndondomeko ya ndondomekoyi, gwiritsani ntchito mabatani omwe amawonekera kumanja pomwe mutsegula pa mbewa. Mungasinthe mtundu, kalembedwe, mtundu wa malire, mudzaze ndi mtundu wina, ndi zina. Monga lamulo, palibe mafunso ndi mapangidwe.
Nkhaniyi yatha. Zabwino zonse ...
