Mukati
Kana iwe uchiwanzovaka mishumo ine zviratidzo zvemari (KPI) muExcel, saka iwe unofanirwa kufarira iyi yemhando yechati - chiyero chechati kana thermometer chati (Bullet Chart):
- Mutsetse mutsvuku wakachinjika unoratidza kukosha kwatinovavarira.
- Iyo yetatu-mavara kumashure inozadza chiyero inoratidza zvakajeka "yakaipa-yepakati-yakanaka" nzvimbo kwatinowana.
- Iyo dema repakati rectangle inoratidza kukosha kwazvino kweparameter.
Ehezve, hapana zvekare kukosha kweiyo parameter mudhayagiramu rakadaro, kureva kuti Hatisi kuzoona chero masimba kana mafambiro, asi kune inonongedza ratidziro yezvakawanikwa mhedzisiro vs zvibodzwa panguva ino, yakakodzera.
Video
Danho 1. Yakaturikidzana histogram
Isu tichafanirwa kutanga nekuvaka yakajairwa histogram zvichibva pane yedu data, yatichazounza kune fomu yatinoda mumatanho mashoma. Sarudza iyo source data, vhura iyo tab Insert uye sarudza akaturikidzana histogram:
Zvino tinowedzera:
- Kuita kuti makoramu amutsetse kwete mumutsara, asi pamusoro peumwe neumwe, chinjanisa mitsetse nemakoramu uchishandisa bhatani. Mutsara/Koramu (Row/Colum) Tab Mugadziri (Design).
- Isu tinobvisa ngano uye zita (kana pane) - isu tine minimalism pano.
- Gadzirisa kuzara kwemavara emakoramu zvichienderana nezvaanoreva (sarudza imwe neimwe, tinya kurudyi pane yakasarudzwa uye sarudza. Data point format).
- Kupfupisa chati muhupamhi
Izvo zvabuda zvinofanira kutarisa chimwe chinhu chakadai:
Danho 2. Axis yechipiri
Sarudza mutsara ukoshi (rectangle dema), vhura zvimiro zvayo nemusanganiswa Ctrl + 1 kana kuti tinya pairi kurudyi - Row Format (Format Data Point) uye muparameter hwindo chinja mutsara kuenda Axiliary axis (Secondary Axis).
Koramu dema inoenda pamwe neyechipiri axis uye inotanga kuvhara mamwe ese ane mavara rectangles - usatya, zvese zvinoenderana nechirongwa 😉 Kuona chiyero, wedzera icho. Side clearance (Gap) kusvika pakakwirira kuti uwane mufananidzo wakafanana:
Kwatodziya, handiti?
Danho 3. Isa chinangwa
Sarudza mutsara chinangwa (rectangle tsvuku), tinya-kurudyi pairi, sarudza murairo Shandura mhando yemachati kune dzakatevedzana uye shandura mhando kuti Dotted (Scatter). Rectangle dzvuku inofanira kushanduka kuita chiratidzo chimwe chete (kutenderera kana L-shaped), kureva chaizvo:
Pasina kubvisa sarudzo kubva panguva ino, vhura iyo Error Bars Tab Maitiro. kana kuti pane tab Constructor (muExcel 2013). Idzo dzazvino vhezheni dzeExcel dzinopa akati wandei sarudzo kune aya mabara - edzai nawo kana uchida:
Kubva kwatiri, "ndebvu" dzinofanira kupatsanurwa kumativi mana - dzinowanzoshandiswa kuratidza kutendeseka kwechokwadi kana kuparadzira (kupararira) kwehutano, semuenzaniso, muhuwandu, asi ikozvino tinozvishandisa kune chinangwa cheprosaic. Dzima mbariro dzakamira (sarudza uye tinya kiyi Kudzima), uye gadzirisa dzakachinjika nekudzvanya-kurudyi pazviri uye nekusarudza rairo Format Error Bars:
Muwindo rezvivakwa zvemabhawa akatwasuka ezvikanganiso muchikamu Kukanganisa kukosha Sarudza yakatarwa kukosha or Tsika (Tsika) uye isa kukosha kwakanaka uye kwakashata kwechikanganiso kubva pane keyboard yakaenzana ne0,2 - 0,5 (yakasarudzwa neziso). Pano iwe unogonawo kuwedzera kukora kwebhari uye kuchinja ruvara rwayo kuti rutsvuku. Chikarakadzo chinogona kudzimwa. Nekuda kweizvozvo, zvinofanirwa kuitika seizvi:
Danho 4. Kupedzisa kubata
Zvino pachava nemashiripiti. Tarisa maoko ako: sarudza iyo yakarurama yekuwedzera axis uye tinya Kudzima pa keyboard. Ese makororamu edu akavakirwa chiyero, bhaa yekukanganisa uye iyo huru dema rectangle yeikozvino parameter kukosha inoderedzwa kune imwe coordination system uye inotanga kurongwa pamwe chete neaxis imwe:
Ndizvozvo, dhayagiramu yakagadzirira. Makanaka, handizvo here? 🙂
Zvingangodaro iwe unenge uine akati wandei ma paramita aunoda kuratidza uchishandisa machati akadaro. Kuti usadzokorore saga yese nekuvaka, unogona kungokopa chati, uyezve (kuisarudza) dhonza rectangle yebhuruu yenzvimbo yedata data kune hunyowani hutsva:
- Maitiro ekugadzira Pareto chati muExcel
- Maitiro ekugadzira mapopoma echati yekutsauka ("waterfall" kana "bhiriji") muExcel
- Chii Chitsva mumaChati muExcel 2013