Sei kuwana girafu muna Excel 2007

Machati - nzira yakanaka pokuongorora ruzivo. Kazhinji, vari kudiwa, kana kunodiwa kusiyanisa chero basa Data kuratidza kukosha nekambani haibatsiri zvegore, kana uchapupu masayendisiti kuratidza Somuenzaniso, tembiricha nokuchinja pamwedzi pane imwe nzvimbo. Uchishandisa Microsoft Excel kuti charting iguru nzira kuti chati kuti uchaona nyanzvi kubasa kana kuchikoro. Zvisinei, haasi munhu wose anoziva kuti graphing muna Excel. Pasi kurondedzera muchidimbu matanho anofanira kutorwa kuti pave chati iri mupepeti. Various zvimwe Graphics kuti inogona akasika - mitsetse, histograms - anoitwa nenzira yakafanana. muenzaniso uyu ari Microsoft Excel 2007 kuti Windows.

Saka, kutanga Excel 2007, baya mupepeti pakombiyuta yako. Kupinda inodiwa umboo kuti chikamu mashoko uchida kuenzanisa, Akariyanika muzvikamu zvakasiyana. Woga woga anofanira kupinda ari oga muchitokisi, kutangira A2. In muenzaniso munyaya ino kuti pave girafu kuna Excel, kuratidza mutengo peturu, zvipfeko uye varaidzo.

Zvino unofanira kugadzira X-akabatana Labels vari mumutsara 1. zvinofanira Mumwe Chikwata kuva ari oga muchitokisi, kubvira B1. Somuenzaniso, unogona kusarudza mwedzi mina iri nyaya arayira kuti mari.

Kupinda inodiwa tsika kuti Y-akabatana ari unodikanwa mumasero. The Data vanofanira zvinoenderana mashoko pamusoro x-akabatana uye muchikwata. In muenzaniso uyu, tinogona kutaura mari yakawandisa mumwe chinhu nerimwe mwedzi, rounding mari kune imwe ukoshi.

Simbisa panopindwa mashoko kupinda tafura kuburikidza nekudzvanya chokumusoro rworuboshwe kukona tafura, uye ipapo vachikweva negonzo mhiri chiratidzo-siyana mashoko.

Click on Tab "Insert" Muterere pamusoro chidzitiro. pfungwa iyi zvichakurukurwa iri rechipiri Tab kubva kurutivi rworuboshwe.

Sarudza mhando chati muchida kushandisa kumiririra data, kusika purogiramu muna Excel. histogram, nekuti zvinoratidza zvakajeka siyana variables ari X-akabatana, inomiririra mashoko akasiyana yakanakisisa akakodzera kuti apa mashoko. Zvinofanira kurangarirwa kuti mashoko unoratidzwa zvakasiyana zvichienderana norudzi papurogiramu. Miti iyi dziri pakati zviripo. Vakabayira kusarudza wechikamu, mutsetse, pai machati uye zvichingodaro. Mugore donhwe-pasi Muterere mazano histogram unoratidzwa pashure nekudzvanya pamusoro zvakakodzera chinhu.

Sarudza mhando chati kuti zvakanakisisa akakodzera kuti Data zvaisanganisira purogiramu yako mu Excel. Kana iwe woisa cursor pamusoro zvakakodzera chisarudzo, uchaona tsananguro yacho. Somuenzaniso, kusarudza «2D chati" unoratidzwa nenzira yakakodzera muchimiro patafura yenyu.

Click kusika munhu girafu muna Excel, uye ipapo pamusoro Tab "marongerwo". Kuti kuwedzera zita kuti chati kana akabatana, chete tinya Tab "zvikamu". Izvi zvichaita akavhura donhwe pasi Muterere apo unogona kusarudza runodiwa pazviruva. Kuchinja sezvo zvakafanira muna rokuti, ivo fonts kubudikidza nekudzvanya pamusoro rugwaro uye achiita unozotevera fora.

Paizopera formatting uye fora nemachati Unogona kukopa namatidza kuva nezvimwe zvinyorwa. Kana iwe kutevedzera namatidza mashandiro hadzishandi, unogona edzai kutora screenshot namatidza kuti zvakapararira Graphics muna Excel 2007 upi akasarudzwa Gwaro sezvo chifananidzo.