Yuav ua li cas los tsim ib ncua sij hawm hauv Excel kauj ruam yog kauj ruam

Tsim ib ncua sij hawm hauv Excel Excel yog ib txoj hauv kev zoo tshaj plaws rau kev pom cov phiaj xwm theem lossis qhov tseem ceeb, npaj cov dej num, lossis qhia cov xwm txheej ua ntu zus. Txawm hais tias Excel yuav zoo li ib daim ntawv nthuav qhia- thiab cov cuab yeej siv tus lej, nws muaj ntau txoj haujlwm thiab cov kev xaiv los hloov cov npe yooj yim rau hauv cov sijhawm txaus nyiam.

Peb feem ntau koom nrog ncua sij hawm nrog cov kev tswj xyuas qhov project tshwj xeeb, tab sis qhov tseeb yog qhov ntawd Excel muaj kev hloov pauv txaus kom tau raws li tus kheej thiab kev xav tau kev lag luam. Qhov tseem ceeb yog kom nkag siab txog cov peev txheej uas nws muaj, sib xyaw cov qauv, thiab ua kom zoo dua ntawm kev hloov kho kom cov txiaj ntsig kawg yog qhov tseeb, pom, thiab muaj txiaj ntsig zoo. Hauv qab no yog cov lus qhia ua tiav thiab hloov tshiab tshaj plaws kom kawm paub yuav ua li cas los tsim lub sijhawm hauv Excel ib kauj ruam, siv ob qho tib si phau ntawv qhia thiab cov qauv thiab ntxiv-ins. Peb tseem yuav saib yuav ua li cas txhim kho tus tsim thiab tshawb nrhiav lwm txoj hauv kev. Cia peb pib nrog Yuav ua li cas los tsim ib lub sijhawm hauv Excel. 

Dab tsi yog ncua sij hawm thiab vim li cas thiaj tsim ib qho hauv Excel?

Ib ncua sij hawm, uas tseem hu ua sijhawm, yog ib qho cuab yeej pom kev uas qhia txog cov xwm txheej, kev ua ub no, lossis cov ntsiab lus tseem ceeb uas tau teem caij raws sijhawm. Nws lub luag haujlwm tseem ceeb yog tso cai rau kev nkag siab sai ntawm qhov kev nce qib ntawm qhov project los yog cov txheej txheem ntawm kev nqis tes ua tseem ceeb, ua kom yooj yim rau kev tswj hwm cov dej num, hnub kawg thiab cov neeg ua haujlwm.

Saib cov ntsiab lus tseem ceeb Ib qhov project pab pawg nkag siab txog tag nrho cov xwm txheej ntawm ib sab, cia siab tias yuav muaj teeb meem, thiab sib txuas lus kev nce qib thiab hnub kawg rau cov neeg muaj feem. Txawm hais tias cov cuab yeej zoo li Microsoft Project lossis cov khoos kas online zoo li GanttPRO tshwj xeeb hauv qhov no, Excel yog ib qho kev siv tau thiab hloov tau yooj yim uas feem ntau cov neeg siv thiab cov tuam txhab muaj nyob ntawm tes.

Cov kev xaiv los tsim ib ncua sij hawm hauv Excel

Koj tuaj yeem tsim lub sijhawm los ntawm kos siv Excel ua haujlwm, feem ntau yog siv cov kab kos lossis kab kos; lossis koj tuaj yeem xaiv predefined templates nrog kev tsim qauv uas ua rau kev ua haujlwm yooj yim dua. Ntxiv rau, muaj lwm txoj hauv kev sab nraud ntawm Excel yog tias koj tab tom nrhiav kom nrawm dua.

• Phau ntawv scatter chart: Tso cai rau koj los tsim lub sijhawm ncua sij hawm los ntawm koj tus kheej cov ntxhuav thiab cov ntaub ntawv.
• Official Excel lossis Office.com templates: Lawv yog cov kev daws teeb meem sai, pom kev zoo thiab zoo tagnrho rau cov neeg uas nyiam tsim thiab ua kom pom tseeb.
• Plugins thiab lwm apps: Cov kev pab cuam zoo li GanttPRO muab ncua sij hawm tsim nyob rau hauv ob peb clicks thiab ntau ntau graphical xaiv.

Cov lus qhia ib kauj ruam dhau-kauj ruam los tsim cov ntawv teev sijhawm hauv Excel

1. Sau koj cov ntsiab lus tseem ceeb thiab hnub nyob rau hauv ib lub rooj

Thawj kauj ruam yog txhais cov xwm txheej tseem ceeb ntawm koj qhov project. Tsim ib lub rooj me me hauv Excel nrog tsawg kawg ob kab ntawv tseem ceeb: cov lus piav qhia tseem ceeb thiab hnub uas cuam tshuam. Koj tuaj yeem ntxiv ib kab ntawv ntxiv kom muab tus lej muaj txiaj ntsig rau txhua qhov tseem ceeb, tso cai rau koj tso lawv ntawm qhov siab sib txawv hauv daim ntawv qhia thiab tiv thaiv cov ntawv los ntawm kev sib tshooj:

• Kem A: Cov ntsiab lus tseem ceeb (Piv txwv: "Pib", "Theem 1 Kev xa khoom", "Lub Rooj Sib Tham Kawg").
• Kem B: Hnub tseem ceeb.
• Kem C (yeem): Ib ntu ntawm cov lej xws li 1, 2, 3, 4, rov ua dua yog tias koj muaj ntau qhov chaw. Ua li no, cov ntsiab lus yuav tshwm sim ntawm qhov siab sib txawv.

Tswv yim: Yog tias koj muaj ntau yam xwm txheej, hloov cov lej ntawm qhov tseem ceeb (piv txwv li, 1, 2, 1, 2) yog li cov ntawv sau tau staggered thiab tsis sib tshooj.

2. Ntxig ib daim ntawv qhia

Thaum koj muaj lub rooj npaj, xaiv ib lub xov tooj khoob hauv daim ntawv thiab nyem rau ntawm lub tab Ntxig rau. Hauv pawg graphics, xaiv Kev faib tawm ("Scatter") los yog "Bubble Chart". Ib daim ntawv dawb paug yuav tshwm sim, tos kom teeb tsa.

Hom kab ntawv no zoo meej rau ncua sij hawm, vim Koj tuaj yeem txhais ob qho X (hnub tim) thiab Y (tus nqi / mais) axes nyob rau hauv ib tug heev tus kheej txoj kev.

3. Ntxiv koj cov ntaub ntawv rau hauv daim ntawv

Txoj cai-nias rau ntawm thaj chaw dawb ntawm daim duab thiab xaiv Xaiv cov ntaub ntawvCov ntaub ntawv qhov rai yuav qhib. Nyem rau Ntxiv los tsim ib tug tshiab series.

• X Tus nqi: Xaiv tag nrho hnub kab ntawm koj lub rooj.
• Y Tus nqi: Xaiv cov kab ntawm tus lej muaj nuj nqis. Yog tias koj tsis tau tsim kab ntawv no, koj tuaj yeem tso tag nrho cov ntsiab lus ntawm tib theem, txawm hais tias nws tau pom zoo kom hloov cov txiaj ntsig los cais cov xwm txheej hauv daim duab axis.

Pulsa txais thiab koj cov phiaj xwm tawg yuav hloov kho qhia cov ntsiab lus tso rau raws li hnub thiab tus nqi tus lej.

4. Hloov daim duab mus rau hauv lub sijhawm

Koj twb muaj cov ntsiab lus, tab sis ua kom cov duab ua haujlwm raws sijhawm koj yuav tsum tau kho nws cov hom:

• Tshem tawm cov khoom tsis tsim nyog: Nyem rau kab ntawv xaiv khawm (kos npe +) thiab tshem tawm cov kab sib chaws, daim ntawv teev npe, thiab ntsug (Y) axis, tawm hauv hnub axis nkaus xwb.
• Ntxiv cov ntawv lo thiab cov kab yuam kev: Xyuas cov kev xaiv ntawm Cov ntawv sau los tso saib cov npe ntawm cov tseem ceeb thiab yuam kev bars txuas cov dots rau lub sijhawm.
• Customize qhov yuam kev bars: Txoj nyem rau ntawm qhov yuam kev bar, xaiv Hom Ntawv thiab teeb tsa lawv ua kab ntsug ("Minus" xaiv) thiab teeb tsa lawv mus rau 100% tus nqi kom lawv hla los ntawm qhov tseem ceeb taw tes rau lub sij hawm band.

Koj puas pom tias cov kab kab rov tav tsis tsim nyog lossis koj puas xav tau qhov ntsug? Configure hom kom tshem tawm kab rov tav bar thiab tawm tsuas yog ntsug bar, kho cov xim, thickness, thiab pob tshab los txhim kho visibility.

5. Kho cov qauv tsim thiab kho kom haum

Ntawm no koj tuaj yeem ua tau customize koj ncua sij hawm kom ntau li ntau tau:

• Dot xim: Txoj cai-nias txhua tus cim thiab xaiv "Format Data Series." Los ntawm cov ntawv qhia zaub mov, xaiv cov xim cim koj xav kom pom txhua qhov tseem ceeb.
• Transparency ntawm connectors: Yog tias cov kab txuas ntsug zoo li khaus dhau, kho lawv cov pob tshab siv cov kab ntawv ntsug qhov yuam kev.
• Txoj hauj lwm ntawm qhov tseem ceeb: Nco ntsoov tias koj tuaj yeem hloov tus lej ntawm qhov tseem ceeb hauv kab "Qhov siab" hauv cov lus hauv qab kom txav cov kauj ruam nce lossis nqis thiab tiv thaiv cov ntawv los ntawm kev sib tshooj.
• Kho cov hnub txwv: Txoj cai-nias rau ntawm hnub axis thiab xaiv "Format Axis" los hloov qhov tsawg kawg nkaus thiab siab tshaj qhov tseem ceeb kom haum rau daim duab rau lub sijhawm txaus siab rau koj.

Tseem ceeb: Koj tuaj yeem siv cov ntsiab lus thiab cov qauv ntawm Excel Txhawm rau hloov daim ntawv qhia cov xim, fonts, thiab cov qauv ntawm nplooj ntawv tsim lossis daim duab tsim tab, tsuas yog xaiv lub ntsiab lus lossis xim palette los hloov kho tag nrho saib ntawm koj lub sijhawm.

Yuav ua li cas los tsim ib ncua sij hawm hauv Excel?

6. Ntxiv cov npe thiab cov ntawv piav qhia

Tsis txhob hnov ​​qab tias cov ntsiab lus tseem ceeb yuav tsum yooj yim txheeb xyuas. Txhawm rau nthuav tawm cov npe tseem ceeb:

• Txoj nyem rau ntawm txhua daim ntawv lo hauv daim ntawv qhia thiab xaiv Daim ntawv lo hom ntawv.
• Xaiv Cell tus nqi thiab qhia txog qhov chaw uas koj muaj koj cov lus piav qhia tseem ceeb hauv lub rooj.
• Koj tuaj yeem tshem tawm qhov "Y Tus Nqi" xaiv kom tsuas yog lub npe tseem ceeb tau tshwm sim.

Qhov tshwm sim yog lub sijhawm ncua sij hawm uas suav nrog cov ntsiab lus ntawm qhov xwm txheej, cov kab sib txuas, thiab cov ntawv piav qhia, txhua yam ua raws li lub sijhawm teev koj xav tau.

7. Style thiab txhim khu koj ncua sij hawm hauv Excel

Thaum koj tau teeb tsa cov qauv yooj yim, koj tuaj yeem siv sijhawm li ob peb feeb ua kom koj lub sijhawm ua haujlwm zoo:

• Customize xim thiab fonts: Mus rau "Page Design" > "Themes" kom hloov pauv tag nrho cov duab kos sai sai. Koj tuaj yeem hloov xim thiab fonts tus kheej.
• Siv daim duab xim palette: Los ntawm Daim Duab Tsim tab, nyem rau ntawm cov xim palette uas sau tias "Hloov Xim" los siv cov qauv xim thoob ntiaj teb.
• Kho qhov kev faib tawm: Yog tias koj pom qhov chaw khoob ntawm sab laug lossis sab xis, kho cov axis txwv kom ua kom zoo dua ntawm qhov dav ntawm daim ntawv.
• Sau los yog export: Thaum ua tiav, koj lub sijhawm tuaj yeem luam tawm tau yooj yim, khaws cia ua PDF, lossis muab tso rau hauv kev nthuav qhia.

Lub ntsiab lus tseem ceeb yog qhia lub sij hawm template nrog cov neeg koom tes lossis cov thawj coj los muab cov ntsiab lus ntawm koj qhov project qhov tseem ceeb thiab kev vam meej. Qhov no yuav pab kom txhua tus paub thiab ua raws li cov hom phiaj. Yog tias koj xav kawm ntxiv txog Excel, mus saib lwm tsab xov xwm ntawm no Qhov tseem ceeb tshaj plaws Excel cov qauv pib los ntawm kos zoo li tus proPeb muaj countless ntawm lawv nyob rau hauv Tecnobits, tsuas yog siv lub tshuab tshawb nrhiav.