Yuav ua li cas mus kos ib lub teeb nyob rau hauv Excel 2007

Kab kos - ib tug zoo txoj kev uas cais ntaub ntawv. Raws li ib tug txoj cai, lawv yuav tsum tau, thaum nws yuav tsum tau qha tej lag luam cov ntaub ntawv uas qhia tus nqi ntawm lub tuam txhab profit rau lub xyoo, los yog pov thawj scientific uas qhia, piv txwv li, qhov kub thiab txias hloov nyob rau hauv txhua lub hli nyob rau hauv ib tug tej yam chaw. Siv Microsoft Excel rau charting yog ib txoj kev zoo yuav ua rau ib daim ntawv uas yuav saib kev ntawm kev ua hauj lwm los yog hauv tsev kawm ntawv. Txawm li cas los, tsis yog txhua tus paub li cas lub graphing nyob rau hauv Excel. Hauv qab no yog ib tug nyuag lus piav qhia txog cov kauj ruam uas yuav tsum tau coj mus rau tsim ib daim ntawv nyob rau hauv lub editor. Ntau lwm graphics uas yuav tsim - kab, histograms - yog ua nyob rau hauv ib tug zoo li yam. Qhov no piv txwv yog nyob rau hauv Microsoft Excel 2007 rau lub qhov rais.

Yog li ntawd, ua ntej qhib Excel 2007 editor rau koj lub computer. Sau qhov yuav tsum tau cov ntaub ntawv rau hauv qeb ntawm cov ntaub ntawv uas koj xav tau los sib piv, muab nws nyob rau hauv sib txawv txhua. Txhua qeb yuav tsum tau nkag mus rau hauv ib tug nyias muaj nyias ib tes, pib los ntawm A2. Nyob rau hauv qhov piv txwv nyob qhov tsab xov xwm los tsim ib tug teeb rau Excel, displaying tus nqi ntawm cov roj, khaub ncaws thiab kev lom zem.

Ces koj yuav tsum ua lub X-axis ntawv nyob rau hauv kab 1. Txhua daim ntawv lo yuav tsum nyob rau hauv ib tug nyias muaj nyias ib tes, pib los ntawm B1. Piv txwv li, koj muaj peev xwm xaiv tau plaub lub hlis nyob rau hauv cov ntaub ntawv ntawm ordering ntawm cov nqi.

Sau qhov yuav tsum tau qhov tseem ceeb rau lub Y-axis nyob rau hauv cov yam hlwb. Cov ntaub ntawv yuav tsum ua raws li cov ntaub ntawv nyob rau hauv lub x-axis thiab los ntawm qeb. Nyob rau hauv qhov kev piv txwv, peb yuav hais tus nqi ntawm cov nyiaj siv rau txhua yam khoom rau txhua lub hlis, pub muab kwv yees tus nqi mus rau ib tug yooj yim muaj nuj nqis.

Thas xim rau kev nkag teb chaws ntawm cov ntaub ntawv mus rau hauv ib lub rooj los txhaj nyob rau hauv lub Upper rau sab laug ces kaum ntawm lub qhov rooj, thiab ces dragging tus nas nyob hauv lub cim ntau yam ntawm cov ntaub ntawv.

Nyem rau ntawm qhov tab "Insert" ntawv qhia zaub mov rau saum qhov screen. Qhov no yuav tsum tau nyob rau hauv lub thib ob tab ntawm sab laug sab.

Xaiv hom daim ntawv uas koj xav siv los sawv cev rau cov ntaub ntawv, tsim lub sij hawm nyob rau hauv Excel. histogram, vim hais tias nws kom meej meej qhia qhov sib txawv ntau yam ntawm lub X-axis, uas sawv cev rau ntau cov ntaub ntawv zoo tshaj plaws suited rau saum toj no cov ntaub ntawv. Nws yuav tsum tau nco ntsoov tias cov ntaub ntawv no tso tawm kom txawv nyob ntawm seb lub hom lub sij hawm. Cov hom no muaj nyob rau hauv qhov chaw ntawm lub zaub mov. Muaj ib tug xaiv ntawm ib kem, kab, ncuav qab zib kab kos thiab thiaj li nyob. Nyob rau hauv lub nco-down ntawv qhia zaub mov designs histogram yog tso tawm tom qab txhaj rau cov tsim nyog.

Xaiv hom daim ntawv uas zoo tshaj plaws haum rau cov ntaub ntawv muaj nyob rau hauv koj lub sij hawm nyob rau hauv Excel. Thaum koj tso tus cursor rau qhov kev tsim nyog xaiv, koj yuav pom nws cov hauj lwm. Piv txwv li, xaiv «2D daim ntawv" yog tso tawm nyob rau hauv ib tug tsim nyog daim ntawv nyob rau hauv koj lub rooj.

Nyem rau tsim ib tug teeb nyob rau hauv Excel, thiab ces nyob rau hauv tab "Layout". Yuav kom ntxiv ib lub npe rau hauv daim ntawv los yog axis, cia li nias rau ntawm lub tab "Kos npe". Qhov no yuav qhib ib tug nco cia cov zaub mov qhov twg koj yuav xaiv tau qhov yuav tsum tau nqis. Ua hloov raws li tsim nyog nyob rau hauv lub npe, lub fonts los ntawm txhaj rau cov ntawv nyeem thiab kev ua tau zoo tom ntej editing.

Tom qab kawm tiav ntawm formatting thiab editing kab kos Koj yuav tau luam thiab paste rau hauv lwm yam ntaub ntawv. Yog hais tias koj daim ntawv thiab muab tshuaj txhuam zog tsis ua hauj lwm, koj yeej ib txwm sim mus coj ib tug screenshot thiab muab tshuaj txhuam cov generated graphics nyob rau hauv Excel 2007 rau tej xaiv daim ntawv raws li ib tug duab.