How kurangana? In Excel!

Chero nzira hwedu, mumwe nzira kana mumwe, chokuita nhamba. Mukurapa, tinoona mari uye disclosures zvokudya isu ngaaverenge nhamba macalorie ari mabasa vaiona nyore uye zvichingodaro.

Most kazhinji nokuda zvaanorumbidza ose quantitative kuchinja vachishandisa Graphics. Vanobvumira kuti nemaziso kuona nhamba muitiro.

Nokuti charting kupfuura nyore hofisi Excel. Kuvaka imwe girafu muna Excel zviri nyore. Zvinoda kana mutsetse kana kubata chero macalculator kana munhuwo mapenzura. Nokuti imi muri nyore zvose kuti PC.

Saka, kana uri kushamisika kuda kuvaka sei machati kuna Excel, zvino vanotsvaka mhinduro munyaya ino.

Asati sei kuvaka girafu muna Excel 2010 kana Excel 2003, unofanira kuzarura zvibereko gwaro. Kazhinji, asi default zita isina faira mupurogiramu - "Book1".

Kuita zvinotevera seti mirayiro:

'Start' bhatani (pasi nechokuruboshwe pakona tarisisa), izere mazita akagadzawo zvirongwa, Microsoft Office, Excel.

Wokutanga basa rapera.

Chinotevera ndechokuti kuumba tabular chimiro Data nokuda graphical kuratidzwa. Ita spreadsheet, kuti zvakafanira zviratidzo, zita shongwe uye pemitsara.

Danho rechipiri kwangopera.

Zvino, kuti mubvunzo wako kuda kuvaka machati sei Excel, achava nemhosva "Chart Wizard" unoda kudana kubva Toolbar. Kuti aite izvi, achizviendesa zvinotevera mabhatani: Insert, Chart ...

Muuki nyore kuvaka chero chati kana histogram, vachirayira chokupika muzvikamu zvina chete.

Pfuurira.

Danho rokutanga.

Muchiitiko chino, ukakumbirwa kusarudza mhando yemberi papurogiramu. A-siyana zvaungasarudza zvinoorora pfungwa, Pyramid, sefuro, nharaunda, Radar, etc. Kuumba remangwana kuvakwa kunogona kuonekwa chete mubhokisi nhaurirano, zvakarurama hafu.

Danho rechipiri.

Digital danho basa. Pano munofanira kusarudza zviratidzi chati ramangwana. Kuti aite izvi, sarudza tafura Data kuti makasika ambotaurwa. Panguva Danho yakatarwa mitsara mazita.

Danho rechitatu.

The widest pamusoro Implementation. Iye achatungamirira iwe kuti mhinduro yomubvunzo wokuti kuvaka sei machati ari Excel unonyanya anodzidzisa. For zvakakodzera zvekupfakira vafambe Tabs.

1. Legend. Kunoitawo kuti wedzera siginicha dziri kumiganhu rokuvaka machati kana nekusiyana, kubvisa aripo.
2. The afoot mitsetse. Kunoitawo kuti kuwedzera kana zvinomuomera kuikanganwa zvenguva uye dzinokosha hwakajeka afoot mitsetse.
3. Akabatana. Anosarudza akabatana mhando.
4. Headers. Kutaura mazita nomumwe akabatana ari chati.
5. Data Table. Rinowedzera kana inobvisa tafura ine nhamba zviratidzi hwakavakirwa iyo pakuvaka yakaumbwa muna runoenzanirana munharaunda.
6. Data Labels. Chasainwa neimwe pfungwa chati (nhamba, chikamu, ukoshi).

Danho wechina.

Final. It "chizvarwa muuki" ichapa pakusarudza nzvimbo chati ramangwana. Kusarudza ichapa zviviri zvokusarudza papeji imwe yaivapo (pamwe rugwaro uye kusanganiswa matafura) kana papeji itsva yakanaka.

Mushure matanho mana ose basa "Charting Wizard" vapedza noushingi kumanikidza "Finish" bhatani uye kupindura mubvunzo kuvaka sei machati kuna Excel, munoziva! Ndinobvumirana kuti zviri nyore zvikuru kupfuura zvinoita pakutanga kuaona. The dzidziso inofanira kugara kutsigirwa tsika. Saka edza! Uchabudirira.

Rombo rakanaka!