Kauj ruam yog kauj ruam cov lus qhia yuav ua li cas yuav ua rau ib daim ntawv nyob rau hauv Excel

Nyob rau hauv peb lub neej, tsuas ua tsis tau yam uas tsis muaj ntau yam los sib piv. Cov zauv - nws tsis yog ib qho yooj yim nyeem ntawv, uas yog vim li cas cov neeg tuaj mus nrog cov daim ntawv.

Qhov tseem neeg siv-phooj ywg kev pab cuam rau plotting ntau hom - Microsoft Office Excel. Yuav kom kawm tau li cas los tsim ib daim ntawv rau Excel, thiab yuav tsum tau tham nyob rau hauv no tsab xov xwm.

Qhov no tus txheej txheem yog tsis nyuab heev, peb yuav tsum tsuas ua raws li ib tug tej yam algorithm.

Kauj ruam yog kauj ruam cov lus qhia, yuav ua li cas ua ib daim ntawv nyob rau hauv Excel

1. Qhib cov ntaub ntawv: lub khawm "Start" - "Tag nrho cov kev pab cuam" - nplaub tshev «Microsoft Office» - ib daim ntawv "Excel".

2. Tsim ib lub rooj ntawm cov ntaub ntawv kev kawm rau nrig txog kev pom tu tub tu kiv rau lub daim ntawv. Xaiv lub ntau yam ntawm hlwb muaj numeric cov ntaub ntawv.

3. Hu rau "charting wizard." Hais kom ua: "Ntxig" - "daim duab".

Qhov kev tshuaj ntsuam yuav tso saib lub dialog box Wizard los tsim kom tau ib daim ntawv. Nws yuav pab los mus txiav txim qhov kev txiav txim, yuav ua li cas ua ib daim ntawv nyob rau hauv Excel. Tab sis rau no mus ua hauj lwm koj yuav tsum tau ua plaub kauj ruam yooj yim.

1. Thawj kauj ruam yuav mus xaiv lub hom daim ntawv. Raws li yuav pom los ntawm cov tso tawm kom pom daim ntawv teev, muaj ntau yam ntawm hom: teeb nrog cheeb tsam npuas daim ntawv, histogram, thiab thiaj li rau ntawm qhov chaw. Yuav kom xaiv kuj muaj kev cai daim ntawv hom. Ib qho piv txwv ntawm lub graphical zaub ntawm lub neej yav tom ntej lub sij hawm, koj yuav saib tau nyob rau hauv txoj cai ib nrab ntawm lub qhov rais.

2. Cov kauj ruam thib ob yog los teb cov lus nug ntawm yuav ua li cas ua ib daim ntawv rau Excel, yuav nkag mus rau cov ntaub ntawv qhov twg los. Peb yuav tau tham txog lub qub heev phaj, uas yog hais nyob rau hauv lub thib ob pawg lus ntawm thawj feem ntawm qhov tsab xov xwm. Nyob rau hauv lub "xov tooj" yog lub sij hawm mus nug lub npe ntawm txhua leej (los yog sab ntawm lub rooj) lub neej yav tom ntej lub sij hawm.

3. Qhov tseem voluminous yam khoom №3: «Daim ntawv Options." Taug kev mus rau tabs:

• Headers. Ntawm no koj yuav tau teem lub npe duab ntawm txhua axis ntawm lub daim ntawv thiab muab ib lub npe rau nws.

• Axis. Xaiv hom axis: lub sij hawm axis, lub axis ntawm cov pawg, xws li tsis siv neeg nrhiav kom tau.

• Lub daim phiaj kab. Ntawm no koj yuav tau xaiv, los yog conversely, kom tshem tawm cov yooj yim los yog intermediate kab lub sij hawm daim phiaj.

• Lus dab neeg. Nws yuav cia koj mus qhia los yog zais ib tug dab neeg, thiab xaiv nws qhov chaw nyob.

• Cov ntaub ntawv rooj. Ntxiv cov ntaub ntawv rooj nyob rau hauv lub cheeb tsam ntawm lub tsev rau yav tom ntej ntawm daim duab.

• Cov ntaub ntawv ntawv. Nws muaj xws li kos npe cov ntaub ntawv thiab muab ib tug ntau yam ntawm separator ntawm tsis.

koj creation tshwm nyob rau hauv lub screen. Txawm hais tias daim ntawv Wizard tso cai rau koj mus saib rau yav tom ntej timetable nyob rau txhua txhua theem ntawm lawv lub chaw ua hauj lwm, nyob rau hauv lub kawg koj tseem yuav tau ib yam dab tsi los kho.

Piv txwv li, txhaj nas ib tug ob peb lub sij hawm nyob rau hauv daim duab sab xis nas khawm (tab sis tsis yog rau nws tus kheej!), Koj yuav tau ua tom qab uas lub sij hawm yog xim los yog hloov cov font (style, loj, me, xim, khij hauv qab).

Thaum koj ob npaug nias rau tag nrho cov tib yam, right-click nyob rau hauv daim ntawv kab, koj yuav format txoj kab nws tus kheej daim duab daim phiaj, muab lawv ntaus, thickness thiab xim, thiab hloov ntau lwm yam tsis. Zajlus cheeb tsam no kuj muaj nyob rau formatting es, kom muaj xim schemes.

Peb cia siab hais tias koj tau txais cov feem ntau intuitive thiab lus teb yooj yim rau lo lus nug: "Yuav ua li cas yuav ua rau ib daim ntawv nyob rau hauv Excel?». Nws yog heev yooj yim, Yog hais tias koj ua raws li cov saum toj no cov lus qhia. Peb xav koj zoo!