Maitiro ekutenderedza machati muExcel

Ichi chinyorwa chinotaura nezve maitiro ekutenderera chati muExcel 2010-2013. Iwe unozodzidza nzira dzakasiyana dzekutenderera bar, bar, pie uye mitsara machati, kusanganisira yavo 3D shanduro. Iwe unozoona zvakare maitiro ekushandura iyo kuvaka kurongeka kwehunhu, zvikamu, nhevedzano, uye ngano. Kune avo vanogaro dhinda magirafu nemachati, dzidza kuseta pepa rekutarisa kudhinda.

Excel inoita kuti zvive nyore kwazvo kuratidza tafura sechati kana girafu. Kuti uite izvi, ingosarudza iyo data uye tinya pane icon yemhando yakakodzera yechati. Nekudaro, zvigadziriso zvekutanga zvingave zvisina kukodzera. Kana iwe uchida kutenderedza chati muExcel kuronga mapai zvimedu, makoramu, kana mitsetse zvakasiyana, saka chinyorwa ichi ndechako.

• Tenderedza chati yepai muExcel kune kona yaunoda
• Tenderedza Magirafu e3D muExcel: Tenderedza Pie, Bhawa uye Machati eBhara
• Tenderedza Chati 180°: Rongedzazve Zvikamu, Zvinokosha, uye Data Series
  
  • Kuchinja Kurongeka kweKuvaka Zvikamu muExcel Chart
  • Kuchinja Kurongeka Kwemitemo Yekuvaka
  • Kudzoreredza kurongeka kwekuronga data data pane 3D chati
  • Shandura nzvimbo yengano pachati
• Kuchinja kutaridzika kwepepa kuti rienderane nechati
• Kushandisa Kamera Tool Kutenderedza Excel Chart kune Arbitrary Angle

Tenderedza chati yepai muExcel kune kona yaunoda

Kana iwe kazhinji uchida kuratidza hukuru hukuru muzvikamu, saka zviri nani kushandisa pie charts. Mumufananidzo uri pazasi, iwo data label anopindirana nemazita, saka chati inotaridzika shabby. Ini ndinoda kukopa iyi chati mune PowerPoint mharidzo nezve tsika dzechikafu dzevanhu, uye ndinoda kuti chati yacho ive yakachena. Kuita kuti basa riitwe uye kuratidza iyo inonyanya kukosha chikamu, iwe unofanirwa kuziva nzira yekutenderedza pie chati muExcel wachi.

1. Tinya-kurudyi pane chero chikamu chepie chati yako uye kubva kumenyu inoonekwa, sarudza Data series format (Format Data Series).
2. Panera rezita rimwe chetero richaonekwa. Mumunda Rotation angle yechikamu chekutanga (Angle yechikamu chekutanga), panzvimbo ye zero, isa kukosha kwekona yekutenderera mumadhigirii uye dzvanya pinda. Ndinofunga kutenderera kwe190 degree kuchaita kune yangu pie chati.

Mushure mekutenderera, iyo pie chati muExcel inotaridzika zvakanaka:

Nekudaro, hazvina kunetsa kutenderedza Excel chart kune chero kona kuti ipe iyo yaunoda kutarisa. Nzira yacho inobatsira zvose pakugadzirisa zvakanaka nzvimbo yezvinyorwa zve data uye nekuratidza zvikamu zvakakosha zvikuru.

Tenderedza Magirafu e3D muExcel: Tenderedza Pie, Bhawa uye Machati eBhara

Ini ndinofunga 3D machati anotaridzika akanaka kwazvo. Kana vamwe vanhu vachiona XNUMXD girafu, vane chokwadi chekuti mugadziri wayo anoziva zvese nezve nzira dzekuona muExcel. Kana girafu rakagadzirwa neyakagadzika marongero risingataridzi nenzira yaungade, unogona kuigadzirisa nekutenderedza uye nekuchinja maitiro ekuona.

1. Tinya-kurudyi pane chati uye sarudza kubva pane menyu inooneka. XNUMXD Kutenderera (3-D Kutenderera).
2. Pane pachaonekwa Chart Area Format (Format Chart Area). Muminda Kutenderera kutenderedza X axis (X Kutenderera) uye Kutenderera kutenderedza Y axis (Y Kutenderera) Isa nhamba yaunoda yemadhigirii kuti utenderere.Ini ndinoisa kukosha ku40 ° uye 35 ° zvakateerana kuti ndipe zano rangu humwe hudzamu.

Iwe unogona zvakare kuseta sarudzo mune ino panel. udzamu (Kudzika), urefu (Urefu) uye Pfungwa (Maonero). Edza kuti uwane akanakisa marongero echati yako. Nenzira imwecheteyo, iwe unogona kuseta pie chati.

Tenderedza Chati 180°: Rongedzazve Zvikamu, Zvinokosha, kana Data Series

Kana iyo chati yaunoda kutenderedza muExcel ichiratidza ese akachinjika uye akatwasuka mbezo, unogona kushandura zviri nyore kurongeka kwezvikamu kana kukosha kwakarongwa pamwe chete nematemo iwayo. Pamusoro pezvo, muzvikamu zve3D zvine axis yakadzama, unogona kushandura marongero ayo akateedzera data kuitira kuti mabhawa makuru e3D asapindirane madiki. MuExcel, unogona zvakare kushandura chinzvimbo chengano pane pai chati kana bhaa chati.

Shandura kurongeka kwezvikamu zvekuvaka mudhayagiramu

Chati inogona kutenderedzwa pamusoro peiyo horizontal axis (category axis).

1. Tinya-kurudyi pane yakachinjika axis uye kubva pane inooneka sarudza Axis Format (Format Axis).
2. Panera rezita rimwe chetero richaonekwa. Kuti utenderedze chati 180 °, ingo tarisa bhokisi Reverse order yezvikamu (Categories in reverse order).

Shandura kurongeka kwekuronga kukosha mune chati

Nekutevera aya matanho akareruka, unogona kupenengura chati ichitenderedza vertical axis.

1. Kurudyi tinya pane vertical axis (value axis) uye sarudza Axis Format (Format Axis).
2. Tarisa bhokisi Reverse order of values (Values ​​in reverse order).

Cherechedza: Ramba uchifunga kuti hazvigone kushandura marongero ayo maitiro akarongwa mune radar chati.

Kudzoreredza kurongeka kwekuronga data dhata mune 3D chati

Kana bhaa yako kana bhaa chati ine axis yechitatu, iine mamwe mabhawa pamberi uye mamwe kumashure, unogona kushandura marongero ayo akatevedzana data akarongwa kuitira kuti makuru e3D zvinhu zvisapindirane zvidiki. Uchishandisa nhanho dzinotevera, mapoka maviri kana anopfuura anogona kurongwa kuratidza ese akatevedzana kubva mungano.

1. Tinya-kurudyi pane kukosha kwakateedzana axis (Z-axis) muchati uye mune menyu inoonekwa, tinya. Axis Format (Format Axis).
2. Tarisa bhokisi Reverse order of values (Series in reverse order) kuratidza makoramu mune reverse order.

Shandura nzvimbo yengano pachati

MuExcel pie chati pazasi, ngano iri pazasi. Ndinoda kufambisa ngano kudivi rerudyi rechati kuti ikweve pfungwa zviri nani.

1. Tinya-kurudyi pane ngano uye mune menyu inooneka, tinya Legend Format (Format Legend).
2. Muchikamu Legend options (Legend sarudzo) sarudza imwe yemabhokisi ekutarisa: Kubva kumusoro (Pamusoro), pasi (Pazasi), Ruboshwe (Ruboshwe), Kurudyi (Kurudyi) kana Top kodzero (Kurudyi kumusoro).

Iye zvino ndinoda dhayagiramu yangu zvakanyanya.

Kuchinja kutaridzika kwepepa kuti rienderane nechati

Kana iwe uchingoda kudhinda chati, saka ingo shandura shizha rekutarisa muExcel pasina kutenderedza chati pachayo. Mufananidzo uri pazasi unoratidza kuti chati haina kukwana zvachose pane peji. Nekumisikidza, mapepa ebasa anodhinda muchimiro chechimiro (chakakwirira kupfuura chakafara). Kuti mufananidzo wangu utaridzike zvakanaka kana wadhindwa, ndichachinja maratidziro epeji kubva pamufananidzo kuenda pachimiro.

1. Sarudza pepa rekushanda rine chati yekudhinda.
2. Baya Kurongeka kwemapeji (Kuronga Peji), tinya pamuseve uri pasi pebhatani Orientation (Oriental) uye sarudza sarudzo Mamiriro (Landscape).

Iye zvino muhwindo rekuona, ndinoona kuti chati inokodzera zvakakwana munzvimbo inodhindwa.

Kushandisa Kamera Tool Kutenderedza Excel Chart kune Arbitrary Angle

MuExcel, unogona kutenderedza chati kune chero kona uchishandisa chishandiso kamera. Chigumisiro chebasa Makamera inogona kuiswa padivi pegirafu rekutanga kana pabepa idzva.

Tip: Kana iwe uchida kutenderera chati ne 90 °, mune dzimwe nguva zvakakwana kungoshandura rudzi rwechati. Semuyenzaniso, kubva pabharichati kuenda kubhawa chati.

Kuwedzera mudziyo kamera pa Quick Access Toolbar, shandisa diki pasi museve kurutivi rworudyi rwepaneti. Mune menyu inobuda, tinya Zvimwe zvikwata (Mimwe Mirairo).

sarudza kamera (Kamera) mune rondedzero Zvikwata zvese (Mirairo yese) wobva wadzvanya wedzera (Wedzerai).

Iye zvino kushandisa chishandiso kamera, tevera matanho ari pazasi.

Cherechedza: Ndapota yeuka kuti hazvibviri kushandisa chishandiso kamera zvakananga kune chati, sezvo mhedzisiro inogona kunge isingatarisike.

1. Gadzira girafu kana chero imwe chati.
2. Zvingave zvakafanira kutenderedza chinzvimbo chemavara echati maaxes ne270 ° uchishandisa menyu. Axis Format (Format Axis), iyo inotsanangurwa pamusoro apa. Izvi zvinodikanwa kuitira kuti zvinyorwa zvigone kuverengwa mushure mekunge chati yatenderedzwa.
3. Sarudza huwandu hwemasero ayo chati iri pamusoro.
4. Dzvanya pane icon kamera (Kamera) pane Quick Access Toolbar.
5. Dzvanya pane chero sero yepepa kuti ugadzire chinhu chekamera.
6. Zvino tinya uye ubate mubato wekutenderera kumusoro kwechinyorwa chabuda.
7. Tenderedza chati kukona yaunoda wosunungura mubato wekutenderera.

Cherechedza: Muchiridzwa kamera pane imwe drawback. Zvinhu zvinozoitika zvinogona kuva nekugadzirisa kwakaderera pane chepakutanga chati, uye zvinogona kuratidzika sezviyo kana marara.

Charting inzira yakanaka yekuratidza data. Magirafu muExcel ari nyore kushandisa, anoratidza, anoona, uye dhizaini inogona kugadziridzwa kuti ikwane chero chinodiwa. Iye zvino iwe unoziva kutenderedza histograms, mutsetse uye pie machati.

Ndanyora zvese izvi, ndinonzwa kunge guru guru mumunda wekutenderera kwechati. Ndinovimba chinyorwa changu chichakubatsira kubata nebasa rako. Fara uye uvandudze ruzivo rwako rweExcel!