Yuav Paub
- Highlight lub hlwb koj xav teeb tsa, suav nrog cov ntawv sau, qhov tseem ceeb thiab lub taub hau.
- Qhib Insert zaub mov. Hauv pawg kab kos, xaiv cov ntawv qhia zaub mov ntawm ib sab ntawm Bar Charts icon. Xaiv Ntau kab kab kos.
- Xaiv Bar thiab xaiv ib qho ntawm rau hom ntawv. Xaiv OK txhawm rau tso daim duab qhia hauv daim ntawv nthuav qhia. Hloov cov duab kos siv cov cuab yeej muab.
Kab lus no piav qhia yuav ua li cas ua ib daim duab qhia hauv Excel. Nws kuj tseem suav nrog cov ntaub ntawv ntawm kev ua ib pawg kab kos duab thiab ntxiv cov kab tshiab rau ib daim duab bar uas twb muaj lawm. Cov ntaub ntawv no siv tau rau Excel 2019, 2016, 2013, thiab 2010, Excel rau Microsoft 365, Excel rau Mac, thiab Excel Online.
Yuav ua li cas ua Bar Graph hauv Excel
Thaum koj ua daim ntawv qhia bar hauv Microsoft Excel, nws tso cai rau koj ua tej yam xws li piv cov ntaub ntawv raws sijhawm, pom kev nce qib, thiab ntau lwm yam tseem ceeb. Muaj ntau hom kab kos duab uas koj tuaj yeem hloov kho hauv Excel, tab sis qhov yooj yim tshaj plaws yog daim ntawv qhia bar sib piv cov nqi rau ib tus kab hauv Excel.
Ntawm no yog yuav ua li cas thiaj ua tau ib daim duab hauv Excel.
-
Yuav ua ib daim duab qhia, taw qhia cov hlwb uas koj xav tau teeb tsa. Nco ntsoov suav nrog ob qho tib si Labels thiab Nqes , nrog rau header.
Image -
Tom ntej, xaiv qhov Insert ntawv qhia. Hauv qab kab kos pawg hauv cov ntawv qhia zaub mov, xaiv qhov poob ntawm ib sab ntawm Bar Charts icon.
Image Nyob hauv Excel 2010 thiab Excel 2010, cov cim hauv kab ntawv ntawm kab ntawv, thiab cov npe ntawm daim duab yuav zoo li txawv. Txawm li cas los xij koj tuaj yeem pom 2-D Bar thiab 3-D Bar hauv txhua Excel versions hauv qab no.
-
Ntawm hauv qab ntawm daim ntawv teev npe no, nyem rau Ntau Kab Kab . Hauv qhov rai pop-up, xaiv Bar los ntawm sab laug pane. Ntawm no koj yuav pom 6 kab kos duab xaiv los ntawm.
- Clustered Bar: Txhua daim ntawv xaiv muaj ib tus neeg bar uas pom qhov muag pom tus nqi.
- Stacked Bar: Tus kheej daim ntawv lo qhov tseem ceeb tau muab tso rau saum ib leeg hauv ib qho bar.
- 100% Stacked Bar: Tus nqi ntawm tus kheej yog muab tso rau ntawm ib leeg los sawv cev rau feem pua ntawm tag nrho cov lej rau txhua daim ntawv.
- 3-D Clustered Bar: Zoo ib yam li pawg tab sis tuav yog 3-dimensional.
- 3-D Stacked Bar: Zoo ib yam li stacked bar tab sis tuav yog 3-dimensional.
- 3-D 100% Stacked Bar: Ib yam li 100% stacked bar tab sis tuav yog 3-dimensional.
Image -
Thaum koj nyem OK, daim ntawv yuav tshwm sim hauv daim ntawv nthuav qhia. Thaum pib, txhua qhov bar yuav muaj xim tib yam. Txhawm rau hloov kho qhov pom ntawm daim duab kos thiab sib txawv ntawm cov xim xim los ntawm cov ntaub ntawv series, right-click ib qho ntawm cov tuav thiab xaiv Format Data Series Hauv Format Data Series pane, xaiv lub Fill & Line icon (xim tuaj yeem) thiab hauv qab Fill xaiv Vary xim los ntawm taw tes
Image -
Koj tuaj yeem hloov kho lub npe yooj yim los ntawm kev xaiv lub npe Graph thiab rov ntaus tus tshiab.
Image -
Koj tuaj yeem hloov kho qhov formatting ntawm ib cheeb tsam ntawm daim duab, zoo li thaj chaw thaj chaw lossis thaj chaw teeb duab, los ntawm txoj cai nyem thiab xaiv qhov Format kev xaiv.
Thaum koj ua tiav tsim cov duab kos hauv Excel, koj tuaj yeem hloov kho cov ntawv lossis cov ntaub ntawv txhua lub sijhawm. Koj yuav pom cov kev hloov pauv tau tshwm sim hauv daim duab qhia chaw.
Sib piv Cov Ntaub Ntawv Nrog Bar Graph hauv Excel
Koj tuaj yeem sib piv cov ntaub ntawv hauv kab los ntawm kev siv cov kab ntawv sib txuas hauv Excel. Nov yog txoj hauv kev zoo los txheeb xyuas cov xwm txheej dhau sijhawm rau ntau yam khoom.
Piv txwv li, yog tus kws qhia ntawv xav ua raws li cov tub ntxhais kawm qib nruab nrab txhua lub hlis, tus kws qhia siv tau daim ntawv nthuav qhia nrog ntau kab rau txhua hli.
Cov txheej txheem hauv qab no yuav tsim ib daim ntawv sib piv nrog ntau pawg tuav rau txhua daim ntawv lo rau lub sijhawm.
-
txhawm rau tsim ib Daim Ntawv Clustered, xaiv tag nrho cov ntaub ntawv hauv koj daim ntawv nthuav qhia. Nco ntsoov suav nrog tag nrho Labels, tag nrho kab ntawm cov ntaub ntawv, thiab tag nrho headers.
Image -
Xaiv Title los ntawm cov ntawv qhia zaub mov thiab hauv kab kos ntu ntawm ribbon, xaiv qhov kab kos icon. Hauv cov ntawv qhia zaub mov nco, xaiv qhov 2D Bar lossis 3D Bar pawg kab kos.
Image -
Qhov no yuav tso cov duab qhia hauv koj daim ntawv Excel. Koj yuav pom tias rau txhua tus tub ntxhais kawm lub npe, ib lub bar ntawm cov xim sib txawv sawv cev rau txhua kab. Cov kab ntawv kab ntawv qhia nyob rau hauv qab ntawm daim ntawv qhia seb cov xim twg yog dab tsi.
Image - Zoo ib yam li lwm hom kab ntawv, koj tuaj yeem hloov kho lossis hloov kho cov ntsiab lus ntawm daim duab los ntawm txoj nyem nyem thiab xaiv Format. Koj tuaj yeem hloov Colors, Ciam teb, thiab ntau dua.
Ntxiv cov kab tshiab rau cov kab kos uas twb muaj lawm
Koj tsis nyam nrog cov ntaub ntawv koj tau siv los ua koj daim duab bar hauv Excel. Koj tuaj yeem ntxiv cov kab ntawv ntxiv tom qab daim duab nyob hauv daim ntawv nthuav qhia.
-
Yuav ua li cas, xaiv lub teeb duab thiab cov hlwb uas muaj cov duab yuav qhia txog. Tuav tus nas hla lub kaum sab xis ntawm cov pab pawg ntawm cov hlwb (uas yog qhov tseem ceeb) thiab luag nws mus rau sab xis hla kab ntawv ntxiv.
Image -
Thaum koj ua tiav, koj yuav pom qhov thib peb ntxiv rau txhua pawg hauv daim duab.
Image - Qhov no txhais tau tias koj tsis daig nrog cov ntaub ntawv ruaj khov thaum koj ua daim duab qhia hauv Excel. Ntxiv cov ntaub ntawv tab sis feem ntau koj xav tau thiab daim duab yuav hloov kho tau.
