Iwe unofarira sei iyo pfungwa yekuwedzera mitsara yekufungidzira yekuona kubva pamapoinzi egirafu pa X uye Y axes kune mamwe machati ako?
Zvinotaridzika zvakanaka, handiti? Kuita izvi kuri nyore kwazvo.
Ngatitangei kuvaka chati. Sarudza iyo renji ine sosi data (mumuenzaniso wedu, tafura A1: B8) uye pane iyo tab Insert sarudza Dotted (Scatter) nekubatanidza zvikamu pakati pemapoinzi:
Zvino ngatiwedzerei mabhara ekukanganisa kumapoinzi edhiyagiramu yedu. MuExcel 2013, izvi zvinogona kuitwa uchishandisa bhatani rekuwedzera kurudyi rwechati nekugonesa bhokisi rekutarisa. Error Bars:
MuExcel 2007-2010, izvi zvinogona kuitwa nekusarudza pane tab Maitiro bhatani Error Bars.
Kazhinji, idzi "ndebvu" dzakaumbwa-dzakafanana dzinoshandiswa kuratidza zvinooneka pachati kururamisa uye kuyerwa zvikanganiso, kushivirira, oscillation corridors, nezvimwewo. Tinozvishandisa kudzikisa mitsetse yekufungidzira kubva pane imwe neimwe pfungwa paaxis. Kuti uite izvi, tanga wasarudza yakatwasuka "ndebvu" wodzvanya kiibhodhi yekudimbudzira Ctrl + 1 kana kurudyi tinya pavari wosarudza kuraira Fomati Vertical Error Bars. Muhwindo rinovhurwa, unogona kushandura maratidziro avo uye saizi.
Sarudzai nezvechisarudzo Tsika (Tsika) uye tinya bhatani Ronga Zvinokosha. Mufafitera rinovhurwa, tinoisa yakanaka yekukanganisa kukosha (yepamusoro "ndebvu" = 0, uye seyakashata maitiro (yakaderera "ndebvu") tinosarudza iyo yekutanga data pamwe neY axis, kureva renji B2: B8:
Mushure mekunge mavharidza OK "ndebvu" dzepamusoro dzinofanira kunyangarika, uye dzepasi dzinofanirwa kutwasanudza kune X axis, ichiratidza mitsetse yekufungidzira:
Inoramba ichidzokorora maitiro aya kune zvikanganiso zvakachinjika nenzira imwecheteyo, ichitsanangura kukosha kwakanaka kwekanganiso =0, uye kukosha kwakashata senge A2: A8:
Kuonekwa kwemitsara kunogona kugadziriswa nekudzvanya-kurudyi pavari nemurairo Mabhawa ekukanganisa emhando (yakatwasuka) (Format Error Bars) uye kuvasarudzira ruvara, mutsara une doti panzvimbo yemutsara wakasimba, nezvimwe.
Kana iwe uine misi pane X axis, zvino mushure mekugadzirisa saizi yeyakachinjika kukanganisa miganho, chiyero chinogona "kufamba" pamwe neiyo X axis uye iwe uchafanirwa kugadzirisa hudiki hwayo nekudzvanya-kurudyi pane axis uye kusarudza. murayiro Format Axis kana nekudzvanya nzira yekudimbudzira kiibhodhi Ctrl + 1:
- Nzira yekugadzira dhiyagiramu ye "live" inopindirana
- Maitiro ekuita otomatiki kupenda chati muruvara rwemaseru ane source data
- Nzira yekugadzira waterfall chati