Koj tsis paub yuav ua li cas los tsim kom tau ib daim ntawv nyob rau hauv Excel

Yog hais tias koj muaj kev nyuaj siab rau lo lus nug "Yuav ua li cas los tsim kom tau ib daim ntawv nyob rau hauv Excel?», Ces qhov no tsab xov xwm yog raws nraim li koj xav tau.

Rau hauv lub tsev ntawm kab kos rau Excel, raws li zoo raws li rau qhov kev siv ntawm tag nrho cov hom ntawm kab kos (eg, histograms), raws li cov daim ntawv Wizard.

Wb tau pib.

1. Qhib cov ntaub ntawv MS Office Excel. Pib - Tag nrho cov kev pab cuam - Microsoft Office - Microsoft Office Excel.

2. Khiav Master qhov kev siv ntawm tag nrho cov graphs. Nyob rau sab saum toj toolbar, xaiv cov "Insert", ces - daim duab.

3. Daim ntawv Wizard yog khiav. Mus ua kom tiav nws cov hauj lwm plaub kauj ruam yuav tsum tau ua:

1) Xaiv hom yav tom ntej daim duab. Yuav kom tsim cov muaj kaum plaub hom nrov plig plawg, histogram, cylindrical, kav, npuas, graph, yeej, dotted, nrog qhov chaw ntawm, annular, nto sib pauv, conical, pyramidal. Nyob rau hauv lem, cov kev xaiv ntawm cov hom ntawm cov kev hloov mus rau lub tab "Kev cai" koj muaj peev xwm xaiv ib tug uas tsis yog-tus qauv hom ntawm cov kab kos. Ntau ...

2) Xaiv ntawm cov ntaub ntawv ntau. Yog hais tias koj ua ntej, piv txwv li ua ntej yuav khiav cov wizard xaiv cov kev kawm ntau yam rau yav tom ntej kos duab, ces lub teb yuav tsum tau sau nyob rau hauv yeej, txwv tsis pub - tsuas xaiv tau cov ntaub ntawv ntau rau lub thib ob theem ntawm txoj kev charting wizard. Nyob rau hauv lub tab "xov tooj" muab lub sij hawm mus nug cov npe ntawm cov axes los yog rau hauv daim ntawv sau tias qhov tseem ceeb.

3) xaiv cov daim ntawv tsis. Nws tsis yog ib tug yuav tsum, tab sis nws yog ntshaw kom tag sau. Yog tsis muaj nws, cov daim ntawv yuav tsum tau ua, tab sis yog tias koj nyob nraum tseem xav yuav ua li cas los tsim kom tau ib daim ntawv nyob rau hauv Excel kom raug, nws yog tsim nyog los sau nws rau lub siab tshaj plaws. Tab "Muaj nuj nqis" muab ib lub sij hawm rau muab lub npe ntawm lub neej yav tom ntej daim ntawv thiab nws cov axes. Tab ntawm lub "axis" yog yuav tsum tau mus xaiv lub hom axis ntawv. Saib "daim phiaj kab" tso cai rau koj los tso saib los yog tsis tso saib lub teeb yooj yim thiab intermediate kab siv. Cov "lus dab neeg. Cov kev xaiv ntawm qhov chaw lus dab neeg (qhov tseem ceeb kom meej). Cov ntaub ntawv Ntxhuav" tso cai rau koj los tso saib cov ntaub ntawv, uas yog npaj ncaj qha rau hauv nws siv. Lub tab "Cov ntaub ntawv ntawv" tso cai rau koj kos npe rau txhua nraaj marker nrog ib tug xaiv ntawm yooj yim separator ntawm cov qhov tseem ceeb.

4) Xaiv ntawm qhov chaw daim duab. Piv txwv li, yog hais tias koj xav nyob rau hauv yuav ua li cas los tsim kom tau ib tug histogram nyob rau hauv Excel rau ib daim page, mam li xaiv "Tshwj xeeb" thiab qhia kom meej lub npe ntawm tus tshiab page. Ua li cas!

Cov plaub kauj ruam yog cov uas yooj yim kom teb yog tsis yog li ntawd nyuaj lo lus nug ntawm yuav ua li cas los tsim kom tau ib daim ntawv nyob rau hauv Excel.

Tam sim no cia tus nrog rau lo lus nug ntawm editing los yog formatting ntawm lub resulting.

Ntawm no yog ib daim duab. Xav tias koj xav tau heev me ntsis hloov nws tsos. Yuav ua li cas los tsim kom tau ib daim ntawv nyob rau hauv Excel nrog qaij legends?

Teb: cia li ib ob peb lub sij hawm, nias rau sab laug nas khawm nyob rau tom qab ntawm qhov kev siv ntawm kos duab. Los ntawm qhov kev txiav txim koj hu tau rau lub qhov rais "Format Daim ntawv phab ntsa", qhov uas koj yuav tsis tau tsuas yog hloov cov font siv nyob rau hauv lub tshav pob ntawm kev tsim kho, tab sis kuj yuav xaiv rau nws ncej nrog adjustable kab hom, xim thiab thickness, thiab ntxiv ib tug nco tus duab ntxoov ntxoo nyhuv rau tus ncej.

Muab ob npaug rau txhaj nas nyob rau daim ntawv nws tus kheej, koj qhib lub qhov rais "Format lus Area", qhov twg raws nraim yuav tau hloov cov tsos ntawm tus ncej.

Ob npaug nias rau daim phiaj kab yuav ua rau ib tug "daim phiaj kab hom". Muaj tej zaum yuav raug hloov ntawm cov kab (hom, xim, thickness), thiab lub scale. Nyob rau hauv "Nplai" yuav tsum tau muab teem nyob rau hauv kev sib cais, tus nqi ntawm lub intermediate division, yam tsawg kawg nkaus thiab nyiaj pab ntau tshaj qhov tseem ceeb, raws li zoo raws li lwm yam tsis.

Yog hais tias koj lo lus nug yog hais, piv txwv li, "Yuav ua li cas nqa tawm charting nyob rau hauv Excel 2010", cov lus teb yuav txawv los ntawm qhov tsab xov xwm, tsuas yog lub fact tias cov MS Office Excel Daim ntawv Wizard yog hu ua ib tug nyias muaj nyias ib lub pob rau ntawm qhov Standard toolbar. Tag nrho lwm cov kev nqis tes ua yuav tsum nqa tawm raws li cov saum toj no algorithm.

Daim ntawv - nws tsis yog ib txwm nyuab siv. Xa mus rau Excel thiab saib koj tus kheej. Hmoov zoo!