Maitiro Ekuvaka Girafu muExcel

Imwechete chaiyo masvomhu basa rekuvaka rurongwa hwekuvimba. Inoratidza kutsamira kwebasa rekushandura kupokana. Papepa, maitiro aya haagare ari nyore. Asi Excel Zvishandiso, kana tikazvichengetedza kuti vakutye, vanokutendera kuti uite iri basa uye nekukurumidza. Ngatitsvagei kuti izvi zvingaitwa sei uchishandisa dzakasiyana siyana sosi data.

Graphic kusika maitiro

Iko kutsamira kwebasa rekupokana ndiko kwakajairika algebrac kuvimba. Kazhinji kazhinji, kupokana uye kukosha kwebasa kunoitwa kuratidza zviratidzo: zvakateerana, "x" uye "Y". Kazhinji, zvinodikanwa kuti uite kuratidzwa kukuru kwekuvimbika kwekupokana uye mabasa ayo akanyorwa patafura, kana kuiswa sechikamu chefomula. Ngationgororei mienzaniso chaiyo yekugadzira iyo yakadaro girafu (digrams) pasi pemamiriro akasiyana siyana ekutarisa.

Nzira 1: Kugadzira nzvimbo yekuvimbika screen yakavakirwa tafura

Chekutanga pane zvese, isu tichazoongorora kuti tichagadzira graph zvichibva pane data zvichibva patafura yakarongeka. Isu tinoshandisa tafura yekuvhara kwenzira yakafamba (y) pane nguva (x).

1. Isu tinosimbisa tafura uye tinoenda kune "isa" tab. Dzvanya pane iyo "Chirongwa" bhatani, iyo ine nharaunda muboka re chart paRibbon. Sarudzo yemhando dzakasiyana-siyana dzeGraphs dzinovhura. Nezvinangwa zvedu, sarudza zviri nyore. Iyo iri kutanga mune rondedzero. Ivhu pariri.



2. Chirongwa ichi chinopinda dhizaini. Asi, sezvatinoona, mitsara miviri inoratidzwa panzvimbo yekuvaka, isu tichingoda chete imwe chete: inoratidza kuvimba kwekureba nguva nenguva. Naizvozvo, isu tinogovera iyo yekuruboshwe mbeva bhatani ine mutsara webhuruu ("nguva"), sezvazvisingaenderane nebasa racho, uye tinya kiyi yekudzima.



3. Mutsara wakasarudzwa uchadzimwa.

Chaizvoizvo, pane izvi, kuvakwa kwechirongwa chakareruka chinogona kutariswa zvakapera. Kana iwe uchida, iwe unogona zvakare kurongedza mazita e chati, its dexes, bvisa ngano uye ubudise zvimwe zvachinja. Izvi zvinotsanangurwa zvakadzama mune chimwe chidzidzo chakaparadzana.

Chidzidzo: Maitiro ekuita chirongwa muExcel

Nzira 2: Kugadzira zviito nemitsara yakawanda

Iyo yakaomarara embodiment yeiyo nzvimbo yekuvimba ndiyo nyaya kana imwe nharo inoenderana nemabasa maviri kamwechete. Mune ino kesi, iwe uchafanirwa kuvaka mitsara miviri. Semuenzaniso, tora tafura iyo iyo huwandu hwehuwandu hwebhizinesi uye purofiti yayo yemambure yakapendwa.

1. Isu tinosimbisa tafura yese ne cap.



2. Sezvazviri zvakapfuura, isu tinodzvanya pane "bhatani" bhatani muChirati chikamu. Zvekare, sarudza iyo yekutanga sarudzo yakaunzwa mune iyo rondedzero inovhura.



3. Chirongwa ichi chinoburitsa chakajeka kuvaka maererano nedata yakawanikwa. Asi, sezvatinoona, mune ino nyaya, isu hatina tambo yechitatu chete, asiwo nhandare yeiyo denderedzwa remaitiro evaironga harienderane neavo vanodiwa, kureva kuraira kwegore.

   Pakarepo bvisa tambo yakawandisa. Ndiye chete akananga pane iyi dhizaini - "gore." Sezvazviri munzira yapfuura, isu tinoratidza kudzvanya pairi neiyo mbeva uye tinya pane iyo Delet bhatani.



4. Mutsetse wacho wabviswa uye pamwe chete naro, sezvaunogona kuona, izvo zvinokonzeresa kune vertical kuronga paneli vanoshandurwa. Vakanyatsojeka. Asi dambudziko rekuratidzwa zvisiri izvo kweiyo yakatwasuka axis yeiyo yeronga inoramba. Kugadzirisa dambudziko iri, tinya pane iyo munda yekuvaka iyo kurudyi mbeva bhatani. Mune menyu, iwe unofanirwa kurega kusarudza "Sarudza data ...".



5. Iyo sosi yekusarudza hwindo rinovhura. Mu "yakatwasuka axis siginecha" block, tinya pane "shanduko" bhatani.



6. Iyo hwindo rinovhura kunyange rakaderera pane iyo yapfuura. Mukati maro, iwe unofanirwa kutsanangura marongero ari mubhefura idzodzo dzinofanira kuratidzwa pane axis. Kuti uite izvi, isa iyo isaienda kumunda wega wehwindo iri. Ipapo ini ndinobata bhatani rekuruboshwe bhatani uye sarudza zvese zvirimo zvegore rimwe renji, kunze kwezita rayo. Kero yacho ichangodaro ichikwanisika munda, tinya "OK".



7. Kudzoka kuData Sosi yekusarudza hwindo, zvakare tinya "OK".



8. Mushure meizvozvo, mifananidzo miviri yakaiswa pane pepa rinoratidzwa nenzira kwayo.

Nzira 3: Kuvakwa kwemifananidzo kana uchishandisa zvikamu zvakasiyana-siyana zveyero

Nenzira yekare, taiona kuvaka kwedhirowa nemitsetse yakati wandei pane imwe ndege, asi mabasa ese aive aine zviyero zvakafanana (zviuru zvezviuru). Chii chandinofanira kuita kana iwe uchida kugadzira purogiramu yekuvimbika zvichienderana nepafura imwe, umo zvikamu zvechiyero chekuita? Excel ine kubuda uye kubva pachinzvimbo ichi.

Tine tafura, iyo inopa data pane huwandu hwekutengesa kwechimwe chigadzirwa mumatani mune matani uye mumari kubva mukuita kwayo muzviuru zvezviuru zvezviuru.

1. Sezvazviri mumatare ekutanga, isu tinogovera ese data ye tafura yakarongedza pamwe ne cap.



2. Ivhu pane "bhatani" bhatani. Isu tinosarudza sarudzo yekutanga yekuvaka kubva pane rondedzero.



3. Seti yezvinhu zvemifananidzo inoumbwa panzvimbo yekuvaka. Nenzira imwecheteyo, iyo yakatsanangurwa mumhando dzakapfuura, tinobvisa gore rakawandisa "gore".



4. Sezvazviri munzira yapfuura, isu tinofanirwa kuratidza gore racho pane rakakomberedza kuronga. Dzvanya pane yekuvakwa nzvimbo uye mune rondedzero yekuita, sarudza sarudzo "Sarudza data ...".



5. Muwindo idzva, iwe unoita kudzvanya pane "shanduko" bhatani "Signature" block yeiyo yakatwasuka axis.



6. Muwindo rinotevera, achigadzira zviito zvakafanana zvakataurwa zvakadzama munzira yekare, isu tinosuma marongi egore rechikamu kunzvimbo yeiyo axis signature range. Dzvanya pane "Zvakanaka".



7. Paunodzokera kuhwindo rapfuura, unoitawo tinya pane "ok" bhatani.



8. Zvino isu tinofanirwa kugadzirisa dambudziko ravasati vasangana nezvakamboitika zvekuvaka, kureva, dambudziko rekusanzwisisika rezvikamu. Mushure mezvose, iwe unobvuma, ivo havagone kuwanikwa pane imwecheteyo chikamu chekurangana kuronga, iyo panguva imwe chete inosarudza huwandu hwemari (zviuru zvembabvu) uye misa (matani). Kugadzirisa dambudziko iri, isu tichazoda kuvaka imwe nzvimbo yekuwedzera axis yeirongi.

   Mukati medu, kuti tisarudze mari, isu tichasiya axis yakatwasuka iyo yatovepo, uye ye "kutengesa vhoriyamu" ichagadzira yebetsero. Ivhu pane iyi mutsara kurudyi mbeva bhatani uye sarudza kubva pane iyo rondedzero "chimiro chehuwandu hwe data ...".



9. Nhamba ye data ye data ye data yakatangwa. Tinoda kutamira ku "parameter" chikamu, kana chakavhurwa mune chimwe chikamu. Rutivi rworudyi rwehwindo mune block "kuvaka mutsara". Iwe unofanirwa kuisa switch kune chinzvimbo "neAuxiliary Axis". Ivhu rezita "pedyo".



10. Mushure meizvozvo, iyo Auxileary Axis ichavakwa, uye mutsara wekutengesa uchavambwa kumarongerwo avo. Saka, shanda pabasa rakanyatso kupedzwa.

Nzira 4: Kugadzira iyo French Graph Kubva pane ALGEBRACIC Basa

Zvino ngatimbokurukurai sarudzo yekuvaka iyo yekuvimbika chirongwa icho chinozoiswa neAlgebraic basa.

Isu tine inotevera basa: y = 3x ^ 2 + 2x-15. Pahwaro hwayo, zvinodikanwa kuvaka girafu yezvinhu zvetsika dze y kubva x.

1. Tisati richienderera mberi nekuvaka dhizaini, isu tinoda kuita tafura kubva pane yakatarwa basa. Izvo zvinokoshesa kupokana (X) mune yedu tafura ichanyorwa mune iyo huwandu kubva -15 kusvika ku -10 mu nhanho 3. Kuti uimhanye nedare rekusuma maitiro, kushandisa kushandiswa kwe "kufambira mberi" mudziyo.

   Isu tinoratidza muchitokisi chekutanga cheColumn "x" kukosha "-15" uye kugovera. Mu "Imba" tab, ivhu pane "zadza" bhatani riri mune yekugadzirisa unit. Mune rondedzero, sarudza "kufambira mberi ..." sarudzo.



2. Iyo activation ye "kufambira mberi" hwindo rinoitwa. Mu "nzvimbo" block, maka zita rekuti "pamakoramu", sezvo isu tichida kuzadza chaizvo chikamu. Mu "mhando" boka, siya iyo "arithmetic" kukosha, iyo yakagadzirirwa nekutadza. Mu "nhanho" nzvimbo, isa kukosha "3". Mukukosha kweganho, isu takasiya iyo nhamba "30". Ita tinya pane "ok".



3. Mushure mekuita iyi algorithm yechiito, iyo column yese "X" ichazadzwa nemhando dzinoenderana neiyo yakatarwa chirongwa.



4. Iye zvino tinofanirwa kuseta tsika dze y izvo zvaizoenderana nehumwe hunhu hwa X. Saka, tinoyeuka kuti tine formula y = 3x ^ 2 + 2x-15. Izvo zvinodikanwa kuti ushandure kune iyo Excel formula, umo iyo x kukosha kweX ichatsiviwa nezvirevo kune masero etafura ane nharo dzinoenderana.

   Sarudza iyo yekutanga sero mu "Y" ikholamu. Kufunga izvozvo kwatiri, kero yeiyo yekutanga nharo X inomiririrwa neA2 inoronga, saka panzvimbo yefomula iri pamusoro, tinowana chirevo chakadai:

   = 3 * (A2 ^ 2) + 2 * A2-15

   Isu tinonyora kutaura uku muchitokisi chekutanga che "Y" ikholamu. Kuti uwane mhedzisiro yekuverenga, tinya iyo Enter kiyi.



5. Mhedzisiro yebasa rekutanga kupokana kwefomati rakagadzirwa. Asi isu tinofanirwa kuverengera izvo zvinokonzerwa nedzimwe tafura nharo. Isa iyo formula ye kukosha kwega yega y a refu kwazvo uye inonetesa basa. Zvinokurumidza kukurumidza uye nyore nyore kutevedzera. Iri basa rinogona kugadziriswa uchishandisa mucherechedzo unozadza uye nekutenda kune ino pfuma yekutaurisa kuti akurire, seboka ravo. Kana kutevedzera fomula kune mamwe r ranges y, iyo x maitiro mune formula ichangoerekana zvachinja hama yayo yepakutanga inorongeka.

   Isu tinotakura iyo isaior kune iyo yepazasi kurudyi kwemupendero weiyo iyo formula yakambonyorwa. Panguva imwecheteyo, shanduko inofanira kuitika kune iyo yekukara. Ichava muchinjiko mutema unotakura zita rekuzadza mucherechedzo. Dzvanya bhatani rekuruboshwe mbeva uye kutora ichi chiratidzo kumiganhu yepazasi iya tafura mune iyo "Y" ikholamu.



6. Chiitiko chiri pamusoro chakatungamira kuchokwadi chekuti "y" ikholamu yakazadzwa zvizere nemhedzisiro yekuverenga formula y = 3x ^ 2 + 2x-15.



7. Izvozvi yave nguva yekuvaka zvakananga dhiraivhi pachako. Sarudza ese tabular data. Zvakare mu "Insert" tab, tinya "chati" boka "chati". Mune ino kesi, ngatisarudzei kubva pane rondedzero yesarudzo "purogiramu ine mamaki".



8. Chati ine mamaki icharatidzwa pane yekuvaka nzvimbo. Asi, sezvazvakaitika kare, isu tichazoda kuchinja shanduko kuitira kuti vawane kutarisa kwakakodzera.



9. Chekutanga pane zvese, isu tinodzima mutsara "x", iyo inowanikwa yakatwasuka paMucherechedzo we 0 inoronga. Isu tinogovera chinhu ichi uye tinya pane iyo Delete bhatani.



10. Isu tinodawo ngano, sezvo tine mutsetse mumwe chete ("Y"). Naizvozvo, isu tinosimbisa ngano uye tinya kiyi yekudzima zvakare.



11. Zvino isu tinofanirwa kutsiviwa mune yakakomberedzwa kuronga pane iyo inoenderana neiyo "X" ikhoramu patafura.

    Bhatani rekurudyi re mbeva rinonongedza mutsara wekudhirowa. Fambisa iyo "Sarudza data ..." mune menyu.



12. Muwindo rakaverengerwa rewindo rekusarudza Sarudzo



13. "Axis Signature" hwindo rakatangwa. Munzvimbo ine huwandu hwemasaini eAxis, isu tinoratidza iyo rondedzero inoronga nedatha ye "X" ikhoramu. Isu tinoisa iyo inotuka kumunda wemunda, uyezve, ichigadzira iyo clamp yeiyo kuruboshwe bhatani bhatani, sarudza zvese kukosha kwekoramu inoenderana petafura, kunze chete zita rayo chete. Kamwe chete marongero akaratidzwa mumunda, ivhu pazita "OK".



14. Kudzokera kuDare Rewased Sarudzo Window, ivhu pane "OK" bhatani mukati maro, sezvavaiita ivo vasati vava muhwindo rapfuura.



15. Mushure meizvozvo, chirongwa ichi chinogadzirisa chati yakambovakwa sezvakachinja zvakagadzirwa mumamiriro ezvinhu. Girafu yekuvimbika pahwaro hwebasa realgebraic rinogona kutariswa pakupedzisira rakagadzirira.

Chidzidzo: Maitiro Ekuita AutoCuclete muMicrosoft Excel

Sezvauri kuona, uchishandisa chirongwa cheExcel, maitiro ekugadzira kutenderera kwakareruka kwazvo mukuenzanisa neakasikwa nepepa. Mhedzisiro yekuvaka inogona kushandiswa zvese zvekudzidzisa basa uye zvakananga mune zvinoshanda zvinangwa. Iyo chaiyo embodiment inotsamira pane izvo zvinoenderana nedhivhiri: Tafura tsika kana basa. Mune yechipiri nyaya, usati wagadzira dhizaini, iwe uchafanirwa kugadzira tafura ine nharo uye tsika dzemabasa. Uye zvakare, hurongwa hunogona kuvakwa seyakaenderana nebasa rimwe chete uye dzinoverengeka.