Hamuzivi sei kuvaka chati iri Excel

Kana uri nomubvunzo wokuti "sei kuvaka chati iri Excel?», Zvino nyaya ino ndizvo zvaunofanira.

Pakuvaka machati kuna Excel, uyewo nokuda kweDzimba mhando dzose machati (semuenzaniso, histograms), remhosva Chart Wizard.

Rega kutanga.

1. Vhurai gwaro MS Office Excel. Tanga - Zvirongwa All - Microsoft Office - Microsoft Office Excel.

2. Mhanya Tenzi kuvakwa zvose calculators. Pamusoro Toolbar, kusarudza "Insert", ipapo - Dhiyagramu.

3. Chart Wizard iri kumhanya. Kupedza basa rayo matanho mana zvinofanira kuitwa:

1) Sarudza mhando ramangwana chati. Kuti vavake iripo gumi mhando kurova-rova, histogram, cylindrical, vakatonga, sefuro, girafu, dzeraundi, dzaiva dzakapararira, pamwe nzvimbo, annular, pamusoro Exchange, conical, pyramidal. Uyewo, kusarudza rudzi yezwi Tab "Custom" unogona kusarudza asiri mureza marudzi charts. More ...

2) Selection yacho date kwaasingasvikiri. Kana iwe mberi, kureva asati vachimhanya muuki kusarudza zvinodiwa chikuva Madhayagiramu yemberi, ipapo munda achazadzwa mu rwoga, zvimwe - anongoti kusarudza mashoko siyana pachikuva wechipiri charting muuki. Muna Tab "nhamba" kupiwa mukana kubvunza mazita namasanhu kana chati akanzi tsika.

3) Kusarudza chati parameters. Hazvisi kunofanira, asi zviri chinodiwa chose kuzadza. Pasina izvozvo, chati ichavakwa, asi kana uri vachiri kushamisika sei kuvaka chati iri Excel zvakarurama, zvinokosha kuti kuzadza kuti kufadza. Tab "Headlines" chinopa mukana zita ramangwana chati uye ayo namasanhu. Tab of "akabatana" chinodiwa kusarudza mhando akabatana zvisiri. Ona "Grid Lines" kunoita kuti kuratidza kana kwete kuratidza girafu huru uye zvenguva mutsetse kuvakwa. The "Legend. Kusarudza nzvimbo ngano (tsika kunyatsotsanangura). Data Tables" kunoita kuti kuratidza data, iro vakarangana zvakananga pakurigadzira. The Tab "Data Labels" kunoita kuti asaine hwakajeka zvechinguvana mumwe kusarudzwa nyore separator pakati tsika.

4) Chisarudzo nzvimbo chati. Somuenzaniso, kana uri kuziva sei kuvaka histogram muna Excel iri yoga papeji, ipapo sarudza "Special" uye kutaridzwa zita peji itsva. Kuitwa!

Matanho mana Ndivo nyore kupindura haisi mubvunzo sei kuvaka chati iri Excel saka zvakaoma.

Zvino ngationei kukurira kumubvunzo fora kana formatting yacho zvichizoita.

Heino chati. Ngatitii iwe unofanira zvishomanana kuchinja chitarisiko chake. How kuvaka chati iri Excel pamwe Italic ngano?

Mhinduro: chete vaviri nguva, tinya kuruboshwe negonzo bhatani pamusoro pakanyorwa kuvakwa chati. By chiito ichi iwe kudana hwindo "Format Chart Wall", apo haugoni chete kuchinja Fonts kushandiswa mune kuvakwa, asiwo kusarudza kuti muviri wake pamwe chinjika mutsetse mhando, ruvara uye ukobvu, uye kuwedzera donhwe mumvuri maturo kuti pamatanda.

Double-nekudzvanya negonzo pachati pacharo, iwe hwindo "Format Plot Area", apo chaipo anogonawo kuchinja chitarisiko pamatanda.

Double watinya pamusoro afoot mitsetse achaita munhu "afoot mitsetse Format". Pangava pasi kushandura mitsara (mhando, ruvara, ukobvu), uye pakafunuka. On the "Scale" rinogona kuiswa mumapoka, mutengo zvenguva kupesana, shoma uye kunonyanyisa tsika, uyewo mamwe parameters.

Kana mubvunzo wako zvakananga, somuenzaniso, "How vaite charting mu Excel 2010", mhinduro achange akasiyana ino, asi chokwadi chokuti MS Office Excel Chart Wizard anonzi yoga bhatani pamusoro Standard Toolbar. zvimwe zvose zviito chichaitwa maererano pamusoro algorithm.

Chart - hazvina nguva dzose kuoma kuvakwa. Anoreva Excel uzvionere. Rombo rakanaka!