Machati muExcel ane data rakasiyana: chinangwa, mhando, maitiro ekuvaka

Mazano, matipi, uye matekiniki ekuvandudza kutaridzika kwemachati muMicrosoft Excel.

Zvishandiso zvekuchata muMicrosoft Excel 2010 uye 2007 zviri nani pakutaridzika uye mashandiro pane izvo zvinowanikwa mushanduro dzekutanga dzeExcel. Kunyangwe iwo magirafu achitaridzika zviri nani, haasi ese ma parameter anoshandiswa kuwedzera mashandiro anobva angooneka. Ichi chinyorwa chipfupi chinovhara matipi anobatsira, matipi uye nzira dzekugadzira machati muExcel ayo achaita kuti basa rako rishande.

muenzaniso kuzadza

Iyo yekuvandudza muMicrosoft Office 2010 ndiko kugona kushandisa chati chati inozadza greyscale. Kuti uone izvi zviri kuitika, simbisa dhizaini, sarudza "Zvishandiso zveChati” → "Layout tab" uye sarudza sarudzo kubva pane yekudonhedza pasi kumusoro kuruboshwe rweribhoni. Sarudza "Sarudza Format" (pazasi peiyo paribhoni) uye sarudza "Zadza" → "Pattern fill". Pachati nhema nechena, isa ruvara rwemberi kuti rwuite dema uye rwekumashure ruve ruchena, uye sarudza yekuzadza pateni yenhevedzano. Dzokorora matanho kune imwe template. Haufanire kushandisa dema nechena, edza matemplate akasiyana kuti uve nechokwadi chekuti machati anonyoreka kana akadhindwa mune nhema uye chena kana akakopwa nhema nechena.

Matemplate anogona kushandiswa kuzadza chati muExcel 2010 kuitira kuti ikwanise kudhindwa mune nhema uye chena kana kukopwa mutema nemuchena.

Sevha machati eExcel semufananidzo

Unogona kuchengetedza chati semufananidzo kubva kuExcel kuti ushandise mune mamwe magwaro akadai semishumo kana webhu. Kuchengeta chati semufananidzo, nzira iri nyore ndeyekukura chati iri papepa rebasa kuti ive hombe. Kuti uite oparesheni iyi, unofanirwa kuenda nenzira: faira → Save as, sarudza nzira yekuchengetedza faira rekupedzisira uye mune yekudonha-pasi runyorwa "Sevha mhando" sarudza peji rewebhu (*.htm;*.html), isa zita refaira idzva wobaya bhatani rakanzi Save.

Somugumisiro, pepa rekushanda rinoshandurwa kuva html file, uye sezvo html mafaira asingakwanisi kuva nemifananidzo, chati inochengetwa zvakasiyana uye yakabatanidzwa kune html file. Chati ichachengetwa muforodha yakachengetwa html file. Saka kana faira racho rakanzi Sales.htm, ipapo mifananidzo inenge iri mufolder inonzi sales_files. Iyo mifananidzo inochengetwa seyakasiyana PNG faira. Kana iyo dhayagiramu uye iyi Excel faira ichiri kudikanwa pabasa, inofanirawo kuchengetedzwa zvakasiyana.

Iyo chati inogona kuchengetwa seyakajeka faira kana iwe uchizoida kune imwe chirongwa.

Row inopindirana uye gadziriso yekubvisa parutivi

Kuonekwa kwechati kunogona kuvandudzwa nekushandura hupamhi hwemitsara uye mapeji emativi pakati pavo. Kugadzirisa kupindirana pakati pemachati maviri akatevedzana kana kushandura chinhambwe chiri pakati pawo, tinya-kurudyi pane chero mutsara uri pachati wodzvanya. "Data Series Format". Shandisa iyo Inopindirana Mitsetse kupatsanura mitsara kana kubatanidza mitsetse nekukweva inotsvedza kuGap kana Kupindirana.

Nokudaro, kureba pakati pemitsara kunogadziriswa kuitira kuti zvive pedyo kana kure kure. Kana paine mhando mbiri dze data muchati, uye dzinoda kukwidziridzwa pane imwe neimwe, uye mutsara wechipiri unofanirwa kuve wakasarudzika pane wekutanga, ipapo kurongeka kwekuvaka chati kunochinja. Kutanga, kupindirana kunodiwa kunotangwa. Wobva wadzvanya-kurudyi kuti usarudze iyo data series uye sarudza "Sarudza data". Zvadaro, mutsara 1 unosarudzwa uye unoendeswa kumutsara 2. Nokushandura kurongeka kwematafura nenzira iyi, data duku inogona kuratidzwa pamberi pehombe.

Big Data Series

Paunenge uchironga data zvichienderana nemazuva, iyo data nhevedzano inowanzo kutetepa. Mhinduro kumubvunzo uyu ndeyekusimbisa x-axis (yakachinjika axis) yeexcel chart, tinya-kurudyi wosarudza fomati yeakisi. Mushure mekusarudza iyo axis sarudzo, iwe unofanirwa kudzvanya pane yemavara axis kuti usarudze. Nenzira iyi, mutsara unodiwa wakafara unogona kugadziriswa. Mukuwedzera kune mitsetse, unogona kugadzirisa kureba pakati pavo.

Kuronga paAxis Yechipiri

Paunenge uchironga dhata diki, senge maperesenti, ari padyo nedata hombe, semamiriyoni, zvikamu zvicharasika uye zvisingaonekwe. Dambudziko rinogadziriswa nekugadzira chiyero chechati pane imwe axis yakasiyana. Nokuda kweizvi, dhayagiramu inosarudzwa uye mune tab "Kushanda nemachati", iyo tab inosarudzwa Maitiro, iyo iri mukona yekumusoro kuruboshwe. Unoda kusarudza mitsara isingaonekwe. Wobva wadzvanya bhatani "Format Sarudzo", iyo ichaonekwa pakarepo pazasi, ipapo muboka "Row Options" sarudza "Secondary Axis" wovhara hwindo. Pasina kufambisa chinhu chakasarudzwa, sarudza "Kushanda nemachati", ipapo - tab Mugadziri, ipapo sarudza "Chinja Chati Type".

Iwe unogona ikozvino kusarudza akasiyana machati mhando, senge Line. Nekuda kwekuti nhevedzano yakasarudzwa inongoshanda kunhevedzano iyoyo chete kwete kuchati yese, mhedzisiro yacho ndeyechati yakasanganiswa, senge bar chart ine mutsara chati pamusoro. Chati inotaridzika zvirinani uye iri nyore kuverenga kana chinyorwa chiri paaxis chayo chichienderana neruvara rwechikamu chechati chine data. Naizvozvo, kana paine mitsara yakasvibira, zviri nani kutaipa iyo inoenderana rugwaro zvakare mugirini, uye mutsara mutsvuku ucharatidzwa mutsvuku pane axis yayo.

Gadzira combo machati

Vashandisi veMicrosoft Excel havazive nekukurumidza kuti inogona kugadzira combo machati; zvisinei, izvi zviri nyore kuita. Kuti uite izvi, data inosarudzwa uye mhando yekutanga yechati inovakwa, semuenzaniso, mutsara wechati. Ipapo nhevedzano inosarudzwa inoda kuratidzwa neimwe nzira, semuenzaniso, kushandisa mutsara chati, uye “Kushanda nemadhayagiramu” → tab "Constructor" → "Chinja Chati Type" uye yechipiri cheti mhando inosarudzwa. Mamwe marudzi emachati haagoni kubatanidzwa nokuda kwezvikonzero zvine musoro, zvakadai semachati emitsara miviri, asi mitsara nemachati emitsara zvinoshanda pamwe chete zvakanaka.

Gadzira otomatiki machati eExcel

Kana iwe uine data iyo inokura nekufamba kwenguva, iwe unogona kugadzira chati kuitira kuti ikure yakakura sezvo data rakawanda rinowedzerwa kudura re data. Kuti uite izvi, iyo data inofanirwa kuumbwa setafura. Kuti uite izvi, data yatopinda inosarudzwa, uye pane tab "Kumba" basa rinosarudzwa "Format as table". Zvino, nekuti iyo data yakaumbwa setafura, kana iwe ukagadzira chati pane tabular data, kuwedzera imwe data patafura inongowedzera iyo chati.

Smart Chart Mazita

Musoro wechati unogona kudhonzwa kubva kune rimwe masero ari paExcel sheet. Kutanga, zita rechati rinowedzerwa mu“Kushanda nemadhayagiramu” → Mamisirwo tabhu → "Chati Title" uye inoiswa, semuenzaniso, pamusoro pedhayagiramu. Sero remusoro wechati rinosarudzwa, ipapo cursor inoendeswa kune formula bar uye referensi inopinzwa musero rine data rinoshanda semusoro wechati. Kana musoro wechati uchifanirwa kufanana nebepa, sero D5 papepa 1 rinofanira kunge risina chinhu. Zvino, pese panochinja zviri musero iroro, musoro wechati unochinjawo.

Excel Chati Rudzi Shanduko

Kune machati ane rumwe rudzi rwe data, unogona kuona kuti Excel inorasa imwe neimwe nhevedzano ine ruvara rwakafanana. Izvi zvinogona kuchinjwa nekudzvanya pamutsara uye nekudzvanya-kurudyi pairi, mushure mezvo iwe uchafanirwa kusarudza iyo tab. "Format Data Series", ndokuzo - "Kuzadza". Kana iyo chati ichiratidzira imwe chete data yakatevedzana, unogona kusarudza sarudzo “Madotsi Ane Mavara”.

Ehe, iwe unogona kugara uchisarudza yega yega data nhepfenyuro, tinya-kurudyi uye sarudza "Data Point Format"wobva waisa chero ruvara rweiyo data point.

Kugadzirisa nulls uye data isipo

Kana paine zero kukosha kana kushaikwa data muchati, unogona kudzora kuratidzwa kwe zero nekusarudza mutsara wechati, ipapo - "Kushanda nemachati" → tab "Constructor" → "Sarudza data" → "Masero akavanzika uye asina chinhu". Pano iwe unogona kusarudza kana masero asina chinhu anoratidzwa senzvimbo kana zero, kana kana chati iri mutsara wechati, kana mutsara uchifanira kubva pane imwe nzvimbo kuenda kune imwe nzvimbo panzvimbo yechinhu chisina chinhu. Mushure mekusarudza data inodiwa, zvigadziriso zvinochengetwa nekudzvanya bhatani "OK".

Cherechedza. Izvi zvinongoshanda kune asipo kukosha, kwete nulls.

Kuronga Discontiguous Data

Kuti uronge data isina kurongedzerwa sepadivi nedivi nhevedzano, bata pasi kiyi yeCtrl mushure mekutanga kusarudza data reyega yega. Mushure mekusarudza huwandu, chati inogadzirwa zvichienderana nedata rakasarudzwa.

Sevha chati se template

Kuti uchengetedze chati se template kuitira kuti igone kushandiswa zvakare, iwe unotanga kugadzira uye kugadzirisa kutarisa kunodiwa kwechati. Sarudza chati, tinya "Kushanda nemachati", ipapo tab inovhura “Mugadziri” uye bhatani rinodzvanywa "Chengetedza se template". Iwe unozofanirwa kuisa zita rechati uye tinya Save. Iyi fomati inogona kuzoshandiswa kune mamwe madhayagiramu uchishandisa iyo yakachengetwa template paunenge uchigadzira dhayagiramu nyowani kana kugadzirisa iripo. Kuti uise iyo yakachengetwa template, unofanirwa kusarudza chati. Kuisarudza, tevera ketani: “Kushanda nemachati”→ “Mugadziri → Shandura rudzi rwechati → Patterns. Wobva wasarudza iyo yakambogadzirwa template uye tinya bhatani "OK".

Aya matipi ekuchata uye matipi inokubatsira kugadzira machati akanaka nekukurumidza uye zvakanyanya muExcel 2007 uye 2010.