Customizing kab kos hauv Excel: ntxiv lub npe, axes, lus dab neeg

Dab tsi yog thawj qhov koj ua tom qab tsim daim ntawv qhia hauv Excel? Lawm, npaj nws kom nws phim cov duab uas koj lub tswv yim tau kos.

Nyob rau hauv tsis ntev los no versions ntawm spreadsheets, customizing kab kos yog ib tug zoo nkauj zoo thiab yooj yim txheej txheem.

Microsoft tau mus rau qhov ntev ntev los ua kom yooj yim cov txheej txheem customization. Piv txwv li, nws muab cov nyees khawm tsim nyog rau hauv qhov chaw uas nws yooj yim tshaj kom ncav cuag lawv. Thiab tom qab hauv qhov kev qhia no, koj yuav kawm ntau txoj hauv kev yooj yim rau kev ntxiv thiab hloov kho tag nrho cov ntsiab lus ntawm cov kab kos thiab cov duab hauv Excel.

Peb Txoj Kev Customization Yooj Yim

Yog tias koj paub yuav ua li cas los tsim cov duab hauv Excel, koj paub tias koj tuaj yeem nkag mus rau nws qhov chaw hauv peb txoj kev:

1. Xaiv daim duab thiab dhia mus rau ntu "Ua haujlwm nrog cov kab kos", uas tuaj yeem pom ntawm lub tab “Constructor”.
2. Right-click rau lub caij uas yuav tsum tau hloov thiab xaiv yam khoom xav tau los ntawm cov ntawv qhia zaub mov pop-up.
3. Siv daim duab customization khawm pom nyob rau sab xis sab xis ntawm daim ntawv tom qab txhaj rau nws nrog rau sab laug khawm.

Yog tias koj xav tau teeb tsa ntau cov kev xaiv uas tso cai rau koj los hloov kho cov duab ntawm daim duab, koj tuaj yeem pom lawv hauv thaj chaw uas tau hais los ntawm kab lus. “Chat Area Format”, uas tuaj yeem nkag tau los ntawm txhaj rau ntawm qhov khoom “Kev xaiv ntxiv” hauv cov ntawv qhia zaub mov popup. Koj tuaj yeem pom qhov kev xaiv no hauv pab pawg "Ua haujlwm nrog cov kab kos".

Txhawm rau tso tawm tam sim ntawd "Format Chart Area" vaj huam sib luag, koj tuaj yeem nyem ob npaug rau ntawm qhov xav tau.

Tam sim no peb tau hais txog cov ntaub ntawv tseem ceeb uas yuav tsum tau ua, cia peb txheeb xyuas seb yuav hloov cov ntsiab lus sib txawv li cas los ua kom daim duab zoo li peb xav tau.

Yuav ua li cas ntxiv ib lub npe

Txij li thaum tib neeg feem ntau siv cov ntawv tshaj tawm tshiab, nws yuav yog ib lub tswv yim zoo los saib yuav ua li cas ntxiv ib qho header hauv Excel 2013 thiab 2016. 

Yuav ua li cas ntxiv ib lub npe rau daim ntawv qhia hauv Excel 2013 thiab 2016

Nyob rau hauv cov versions ntawm spreadsheets, lub npe twb tau muab tso rau hauv daim ntawv. Txhawm rau hloov nws, tsuas yog nyem rau ntawm nws thiab sau cov ntawv xav tau hauv qhov chaw nkag.

Koj tseem tuaj yeem nrhiav cov ntsiab lus hauv ib lub xov tooj tshwj xeeb hauv daim ntawv. Thiab, yog tias qhov txuas ntawm tes hloov kho, lub npe hloov tom qab nws. Koj yuav kawm ntxiv txog yuav ua li cas thiaj ua tiav qhov txiaj ntsig tom qab.

Yog tias lub npe tsis tsim los ntawm qhov program, ces koj yuav tsum nyem rau ntawm txhua qhov chaw hauv daim ntawv qhia kom pom lub tab "Ua haujlwm nrog cov kab kos". Tom ntej no, xaiv "Design" tab thiab nyem rau “Add Chart Element”. Tom ntej no, koj yuav tsum xaiv lub npe thiab qhia nws qhov chaw raws li qhia hauv lub screenshot.

Koj tuaj yeem pom ib qho ntxiv kos npe nyob rau sab xis sab xis ntawm daim duab. Yog tias koj nyem rau ntawm nws, ib daim ntawv teev cov ntsiab lus muaj nyob hauv daim duab qhia. Txhawm rau tso saib lub npe, koj yuav tsum khij lub npov nyob ib sab ntawm cov khoom sib xws.

Xwb, koj tuaj yeem nyem rau ntawm xub nyob ib sab ntawm “Chat Title” thiab xaiv ib qho ntawm cov kev xaiv hauv qab no:

1. Saum daim duab. Qhov no yog tus nqi qub. Cov khoom no qhia lub npe nyob rau sab saum toj ntawm daim duab thiab hloov nws.
2. Center. Hauv qhov no, daim ntawv qhia tsis hloov nws qhov loj, tab sis lub npe yog superimposed ntawm daim ntawv nws tus kheej.

Txhawm rau teeb tsa ntau qhov ntsuas, koj yuav tsum mus rau lub tab “Constructor” thiab ua raws li cov kev xaiv no:

1. Ntxiv ib daim ntawv qhia.
2. Lub npe ntawm daim duab.
3. Cov kev xaiv header ntxiv.

Koj tuaj yeem nyem rau ntawm lub cim “Chart Elements”, thiab tom qab ntawd - “Chat Title” и “Kev xaiv ntxiv”. Txawm li cas los xij, lub qhov rais qhib “Chat Title Format”piav saum toj no.

Header customization hauv Excel 2007 thiab 2010 versions

Txhawm rau ntxiv cov npe hauv Excel 2010 thiab hauv qab no, ua raws li cov kauj ruam no:

1. Nyem qhov twg ntawm daim duab.
2. Ib pawg tabs yuav tshwm rau saum. "Ua haujlwm nrog cov kab kos", qhov twg koj yuav tsum xaiv ib yam khoom "Pw". Nyob ntawd koj yuav tsum nias rau “Chat Title”.
3. Tom ntej no, koj yuav tsum xaiv qhov chaw uas xav tau: nyob rau sab sauv ntawm thaj chaw plotting lossis overlaying lub npe ntawm daim ntawv.

Txuas lub header rau ib lub xov tooj tshwj xeeb hauv ib daim ntawv

Rau feem coob ntawm cov kab ntawv hauv Excel, daim ntawv tsim tshiab tau muab tso nrog rau lub npe ua ntej sau los ntawm cov programmers. Nws yuav tsum tau hloov nrog koj tus kheej. Koj yuav tsum tau nyem rau ntawm nws thiab sau cov ntawv tsim nyog. Nws tseem tuaj yeem txuas nws mus rau ib lub xov tooj tshwj xeeb hauv cov ntaub ntawv (lub npe ntawm lub rooj nws tus kheej, piv txwv li). Hauv qhov no, daim ntawv teev npe yuav raug hloov kho thaum koj hloov kho lub cell uas nws cuam tshuam nrog.

Txhawm rau txuas lub header rau ib lub xov tooj, ua raws li cov kauj ruam no:

1. Xaiv ib lub npe. 
2. Nyob rau hauv daim foos input teb, koj yuav tsum sau =, nyem rau ntawm lub xov tooj ntawm tes uas muaj cov ntawv xav tau, thiab nias lub pob "Enter".

Hauv qhov piv txwv no, peb tau txuas lub npe ntawm daim ntawv qhia kev muag txiv hmab txiv ntoo rau ntawm tes A1. Nws kuj tseem tuaj yeem xaiv ob lossis ntau lub hlwb, piv txwv li, ib khub kab lus. Koj tuaj yeem ua rau lawv tshwm hauv lub npe ntawm daim duab lossis daim duab.

Yuav ua li cas txav lub npe

Yog tias koj xav tau txav lub npe mus rau lwm qhov ntawm daim duab, koj yuav tsum xaiv nws thiab txav nws nrog tus nas.

Tshem tawm lub npe

Yog tias koj tsis tas yuav ntxiv ib lub npe rau hauv daim ntawv, ces koj tuaj yeem tshem lub npe ntawm ob txoj hauv kev:

1. Hauv Advanced tab “Constructor” successively nyem rau ntawm cov khoom hauv qab no: “Add Chart Elements” - “Chat Title” - “Tsis yog”.
2. Txoj nyem rau ntawm lub npe thiab hu rau cov ntawv qhia zaub mov uas koj xav pom cov khoom “Rho tawm”.

Header Formatting

Txhawm rau kho hom font thiab xim ntawm lub npe, koj yuav tsum nrhiav cov khoom hauv cov ntawv qhia zaub mov “Font”. Lub qhov rais sib thooj yuav tshwm sim qhov twg koj tuaj yeem teeb tsa txhua qhov tsim nyog.

Yog tias koj xav tau kev hloov pauv hloov maj mam, koj yuav tsum nyem rau ntawm lub npe ntawm daim duab, mus rau tab “Hom ntawv” thiab hloov cov chaw raws li koj pom haum. Ntawm no yog ib qho screenshot qhia cov kauj ruam los hloov lub npe font xim ntawm ribbon.

Los ntawm txoj kev zoo sib xws, nws tuaj yeem hloov kho qhov tsim ntawm lwm cov ntsiab lus, xws li cov lus dab neeg, axes, lub npe.

Daim duab axis customization

Feem ntau cov ntsug (Y) thiab kab rov tav (X) axes tau ntxiv ib zaug thaum koj tsim ib daim duab lossis daim duab hauv Excel.

Koj tuaj yeem pom lossis zais lawv siv lub pob "+" nyob rau sab xis sab xis thiab nyem rau ntawm xub xub ntawm "Axes". Hauv qhov rai uas tshwm, koj tuaj yeem xaiv cov uas yuav tsum tau nthuav tawm thiab cov uas zoo dua zais.

Hauv qee hom kab kos thiab kab kos, ib qho axis ntxiv tuaj yeem tshwm sim.

Yog tias koj xav tau tsim daim duab XNUMXD, koj tuaj yeem ntxiv qhov tob axis.

Tus neeg siv tuaj yeem txheeb xyuas qhov sib txawv axes yuav tshwm rau ntawm daim ntawv Excel. Cov kauj ruam ntxaws ntxaws tau piav qhia hauv qab no.

Ntxiv Axis Titles

Txhawm rau pab tus nyeem ntawv nkag siab cov ntaub ntawv, koj tuaj yeem ntxiv cov ntawv sau rau cov axes. Txhawm rau ua qhov no, ua cov hauv qab no:

1. Nyem rau ntawm daim duab, ces xaiv cov khoom “Chart Elements” thiab kos lub thawv "Axis npe". Yog tias koj xav qhia ib lub npe rau ib qho axis, koj yuav tsum nyem rau ntawm xub thiab tshem ib qho ntawm cov checkboxes.
2. Nyem rau ntawm axis lub npe nkag teb thiab sau cov ntawv nyeem.

Txhawm rau txheeb xyuas qhov tshwm sim ntawm lub npe, nyem rau sab xis thiab nrhiav cov khoom "Axis Title Format". Tom ntej no, ib lub vaj huam sib luag yuav pom nyob rau hauv uas tag nrho cov kev xaiv formatting configured. Nws muaj peev xwm sim ntau txoj kev xaiv los tso saib lub npe ntawm lub tab “Hom ntawv”, raws li qhia saum toj no thaum nws los hloov lub npe hom.

Koom nrog lub npe axis nrog cov ntaub ntawv tshwj xeeb ntawm tes

Ib yam li nrog daim ntawv teev npe, koj tuaj yeem khi lub npe axis rau ib lub xov tooj tshwj xeeb hauv daim ntawv kom nws hloov kho sai li sai tau thaum cov xov tooj sib txuas hauv lub rooj raug kho.

Txhawm rau khi ib lub npe, koj yuav tsum xaiv nws, sau = nyob rau hauv qhov tsim nyog teb thiab xaiv lub cell uas koj xav khi rau lub axis. Tom qab cov kev hloov pauv no, koj yuav tsum nyem rau ntawm lub pob "Enter".

Hloov cov nplai ntawm cov axes

Excel nws tus kheej pom tus nqi loj tshaj plaws thiab tsawg tshaj plaws, nyob ntawm cov ntaub ntawv nkag los ntawm tus neeg siv. Yog tias koj xav tau teeb tsa lwm qhov tsis muaj, koj tuaj yeem ua nws manually. Koj yuav tsum ua cov hauv qab no:

1. Xaiv lub x-axis ntawm daim ntawv thiab nyem rau ntawm lub cim “Chart Elements”.
2. Nyem rau ntawm xub icon nyob rau hauv kab “Axis” thiab hauv cov ntawv qhia pop-up nyem rau “Kev xaiv ntxiv”.
3. Tom ntej no los txog ntu “Axis Options”qhov twg ib qho ntawm cov kev ua no tau ua:
   1. Txhawm rau teeb tsa qhov pib thiab xaus qhov tseem ceeb ntawm Y axis, koj yuav tsum qhia nws hauv cov teb "Minimum" thiab "Maximum".
   2. Txhawm rau hloov qhov ntsuas ntawm lub axis, koj tuaj yeem qhia qhov tseem ceeb hauv daim teb “Basic division” и “Intermediate divisions”.
   3. Txhawm rau teeb tsa cov zaub hauv qhov kev txiav txim rov qab, koj yuav tsum tau kos lub thawv ntawm qhov kev xaiv “Rov qab Order of Values”.

Txij li cov kab rov tav axis feem ntau qhia cov ntawv sau, nws muaj kev xaiv tsawg dua. Tab sis koj tuaj yeem hloov kho tus naj npawb ntawm pawg pom ntawm cov ntawv sau, lawv cov kab ke thiab qhov twg cov axes cuam tshuam.

Hloov Cov Qauv ntawm Axis Tus Nqi

Yog tias koj xav tau tso saib cov nqi ntawm cov axes raws li feem pua, sijhawm, lossis lwm hom ntawv, koj yuav tsum xaiv cov khoom los ntawm cov ntawv qhia zaub mov pop-up. “Format Axis”, thiab nyob rau sab xis ntawm lub qhov rais, xaiv ib qho ntawm cov kev xaiv tau uas nws hais “Tus lej”.

Pom zoo: txhawm rau txhim kho cov ntaub ntawv thawj zaug (uas yog, qhov tseem ceeb qhia hauv cov hlwb), koj yuav tsum khij lub npov ntawm cov khoom. “Txuas mus rau qhov chaw”. Yog koj nrhiav tsis tau seem “Tus lej” hauv vaj huam sib luag “Format Axis”, koj yuav tsum xyuas kom meej tias koj tau xaiv yav dhau los cov axis uas qhia txog qhov tseem ceeb. Feem ntau nws yog X axis.

Ntxiv Cov Ntawv Sau Npe

Txhawm rau ua kom daim ntawv nyeem yooj yim dua, koj tuaj yeem ntxiv cov ntawv sau rau cov ntaub ntawv koj muab. Koj tuaj yeem ntxiv lawv rau ib kab lossis rau tag nrho. Excel kuj tseem muaj peev xwm ntxiv cov ntawv sau rau qee cov ntsiab lus.

Txhawm rau ua qhov no, koj yuav tsum ua raws li cov kauj ruam no:

1. Nyem rau ntawm cov ntaub ntawv series yuav tsum tau kos npe. Yog tias koj xav kos ib lub ntsiab lus nrog cov ntawv nyeem, koj yuav tsum nyem rau nws dua.
2. Nyem rau lub cim “Chart Elements” thiab khij lub npov nyob ib sab “Cov ntaub ntawv kos npe”.

Piv txwv li, ntawm no yog ib qho ntawm cov kab kos zoo li tom qab cov ntawv sau tau ntxiv rau ib qho ntawm cov ntaub ntawv hauv peb lub rooj.

Rau cov kab kos tshwj xeeb (xws li kab kos duab ncuav qab zib), koj tuaj yeem qhia qhov chaw ntawm daim ntawv lo. Ua li no, nyem rau ntawm xub xub ntawm kab “Cov ntaub ntawv kos npe” thiab qhia txog qhov chaw tsim nyog. Txhawm rau tso cov ntawv sau rau hauv qhov chaw nkag nkag, koj yuav tsum xaiv cov khoom “Data Callout”. Yog tias koj xav tau ntau qhov chaw, koj tuaj yeem nyem rau ntawm cov khoom sib txuas hauv qab ntawm cov ntawv qhia zaub mov.

Yuav hloov cov ntsiab lus ntawm kos npe li cas

Txhawm rau hloov cov ntaub ntawv pom hauv kos npe, koj yuav tsum nyem rau ntawm lub pob “Chart Elements” - “Cov ntaub ntawv kos npe” - “Kev xaiv ntxiv”. Lub vaj huam sib luag yuav tshwm sim. “Data Label Format”. Muaj koj yuav tsum mus rau lub tab “Signature Options” hauv thiab xaiv qhov kev xaiv uas xav tau hauv ntu “Sau hauv Kos Npe”.

Yog tias koj xav ntxiv koj tus kheej cov ntawv rau ib qho kev taw qhia cov ntaub ntawv, koj yuav tsum tau nyem ob npaug rau ntawm daim ntawv lo kom nws tsuas yog xaiv. Tom ntej no, xaiv ib daim ntawv lo nrog cov ntawv uas twb muaj lawm thiab sau cov ntawv koj xav hloov.

Yog tias koj txiav txim siab tias muaj ntau cov ntawv sau rau hauv daim ntawv qhia, koj tuaj yeem tshem tawm ib qho ntawm lawv los ntawm txoj cai-nias ntawm daim ntawv lo thiab nyem rau ntawm lub pob “Rho tawm” hauv cov ntawv qhia zaub mov uas tshwm.

Qee cov lus qhia rau kev txhais cov ntaub ntawv sau npe:

1. Txhawm rau hloov qhov chaw ntawm kos npe, koj yuav tsum nyem rau ntawm nws thiab txav mus rau qhov chaw xav tau nrog tus nas.
2. Txhawm rau hloov cov xim tom qab thiab kos npe font, xaiv lawv, mus rau tab “Hom ntawv” thiab teem caij yuav tsum tau.

Kev teeb tsa lus dab neeg

Tom qab koj tsim ib daim ntawv qhia hauv Excel, cov lus dab neeg yuav cia li tshwm rau hauv qab ntawm daim ntawv yog tias Excel version yog 2013 lossis 2016. Yog tias qhov ua ntej ntawm qhov kev zov me nyuam raug teeb tsa, nws yuav tshwm nyob rau sab xis ntawm thaj chaw.

Txhawm rau nkaum cov lus dab neeg, koj yuav tsum nyem rau ntawm lub pob nrog ib qho ntxiv kos npe nyob rau sab xis sab xis ntawm daim ntawv thiab tshem tawm lub thawv sib txuas.

Txhawm rau txav nws, koj yuav tsum nyem rau ntawm daim duab, txav mus rau tab “Constructor” thiab nias “Add Chart Element” thiab xaiv txoj haujlwm xav tau. Koj tuaj yeem rho tawm cov lus dab neeg los ntawm cov ntawv qhia zaub mov no los ntawm txhaj rau ntawm lub pob “Tsis yog”. 

Koj tuaj yeem hloov qhov chaw los ntawm ob-nias ntawm nws thiab hauv cov kev xaiv (ntawm sab xis ntawm lub vijtsam) xaiv qhov chaw xav tau.

Txhawm rau hloov qhov formatting ntawm cov lus dab neeg, muaj ntau qhov chaw nyob hauv tab “Shading thiab ciam teb”, “Cov teebmeem” nyob rau hauv txoj cai vaj huam sib luag.

Yuav ua li cas qhia lossis zais daim phiaj ntawm Excel daim ntawv

Daim phiaj qhia los yog muab zais siv tib cov ntawv qhia pop-up siv los qhia lub npe, lus dab neeg, thiab lwm yam kab ntawv.

Qhov kev zov me nyuam yuav cia li xaiv hom kab sib chaws uas haum tshaj plaws rau ib daim ntawv qhia tshwj xeeb. Yog tias koj xav tau hloov nws, koj yuav tsum nyem rau ntawm xub xub ntawm ib sab ntawm cov khoom sib txuas thiab nyem rau “Kev xaiv ntxiv”.

Khaws thiab kho cov ntaub ntawv series hauv Excel

Txhawm rau nkaum lossis kho tus kheej cov ntaub ntawv hauv Excel, koj yuav tsum nyem lub pob ntawm sab xis ntawm daim duab "Cov ntawv lim" thiab tshem cov checkbox uas tsis tsim nyog. 

Txhawm rau hloov cov ntaub ntawv, nyem rau ntawm “Hloov kab” nyob rau sab xis ntawm lub npe. Txhawm rau pom lub pob no, koj yuav tsum hla lub npe kab.

Hloov daim duab hom thiab style

Txhawm rau hloov hom kab ntawv, koj yuav tsum nyem rau ntawm nws, mus rau tab “Ntxig” thiab hauv seem “Daim duab” xaiv hom tsim nyog.

Koj tseem tuaj yeem qhib cov ntawv qhia zaub mov thiab nyem rau ntawm “Change Chart Type”.

Txhawm rau hloov daim ntawv qhia sai sai, koj yuav tsum nyem rau ntawm lub pob sib txuas (nrog txhuam) rau sab xis ntawm daim ntawv. Koj tuaj yeem xaiv qhov tsim nyog los ntawm cov npe uas tshwm.

Koj tuaj yeem xaiv qhov tsim nyog style hauv ntu “Chat Styles” hauv tab “Constructor”.

Hloov daim duab xim

Txhawm rau hloov cov qauv xim, nyem rau ntawm lub pob “Chat Styles” thiab hauv tab "Xim" xaiv lub ntsiab lus tsim nyog.

Koj tuaj yeem siv lub tab “Hom ntawv”nyem lub pob qhov twg “shape fill”.

Yuav ua li cas to taub qhov chaw ntawm axis

Txhawm rau ua tiav lub hom phiaj no, nws yog qhov tsim nyog rau ntawm lub tab “Constructor” thawb khawm “Raws kab”.

Daim ntawv kis ntawm sab laug mus rau sab xis

Txhawm rau tig daim duab los ntawm sab laug mus rau sab xis, koj yuav tsum tau nyem rau ntawm kab rov tav thiab nyem “Format Axis”.

Koj tseem tuaj yeem nyob hauv tab “Constructor” nrhiav khoom “Kev Xaiv Ntxiv Axis”.

Hauv lub vaj huam sib luag sab xis, xaiv cov khoom “Rov qab kev txiav txim ntawm pawg”.

Kuj tseem muaj ntau qhov ua tau, tab sis nws tsis tuaj yeem xav txog txhua yam. Tab sis yog tias koj kawm paub siv cov yam ntxwv no, nws yuav yooj yim dua los kawm cov tshiab koj tus kheej. Hmoov zoo!