txheem
Sparklines thawj zaug tshwm sim hauv Excel 2010 thiab tau loj hlob hauv kev muaj koob npe txij li thaum. Txawm hais tias sparklines zoo ib yam li cov duab kos duab, lawv tsis yog tib yam thiab muaj lub hom phiaj sib txawv me ntsis. Hauv phau ntawv qhia no, peb yuav qhia koj txog sparklines thiab qhia koj siv lawv li cas hauv Excel phau ntawv.
Muaj qee lub sij hawm thaum koj yuav tsum txheeb xyuas thiab tshawb nrhiav qhov kev vam khom hauv Excel cov ntaub ntawv yam tsis tau tsim ib daim ntawv ua tiav. Sparklines yog cov kab kos me me uas haum rau hauv ib lub xov tooj. Vim lawv cov compactness, koj tuaj yeem suav nrog ntau lub sparklines ib zaug hauv ib phau ntawv ua haujlwm.
Hauv qee qhov chaw, sparklines hu ua kab xov xwm.
Hom sparklines
Muaj peb hom sparklines hauv Excel: Sparkline Graph, Sparkline Histogram, thiab Sparkline Yeej / Poob. Sparkline Plot thiab Sparkline Histogram ua haujlwm tib yam li cov phiaj xwm ib txwm muaj thiab histograms. Ib qho yeej / poob sparkline zoo ib yam li tus qauv histogram, tab sis nws tsis qhia qhov loj ntawm tus nqi, tab sis seb nws zoo lossis tsis zoo. Tag nrho peb hom sparklines tuaj yeem pom cov cim ntawm qhov chaw tseem ceeb, xws li qhov siab thiab qis, ua rau lawv yooj yim heev rau kev nyeem ntawv.
Dab tsi yog sparklines siv rau?
Sparklines hauv Excel muaj ntau qhov zoo dua li cov kab kos tsis tu ncua. Xav txog tias koj muaj ib lub rooj nrog 1000 kab. Daim ntawv qhia tus qauv yuav npaj 1000 cov ntaub ntawv series, piv txwv li ib kab rau txhua kab. Kuv xav tias nws tsis yog qhov nyuaj rau twv tias nws yuav nyuaj nrhiav ib yam dab tsi ntawm daim duab zoo li no. Nws yog qhov ua tau zoo dua los tsim kom muaj qhov sib cais sib cais rau txhua kab hauv Excel lub rooj, uas yuav nyob ntawm ib sab ntawm cov ntaub ntawv, tso cai rau koj pom kev sib raug zoo thiab sib txawv rau txhua kab.
Nyob rau hauv daim duab hauv qab no, koj tuaj yeem pom ib daim duab cumbersome uas nws nyuaj rau ua txhua yam. Sparklines, ntawm qhov tod tes, tso cai rau koj kom pom meej qhov muag ntawm txhua tus neeg muag khoom muag.
Tsis tas li ntawd, sparklines muaj txiaj ntsig zoo thaum koj xav tau cov ntsiab lus yooj yim ntawm cov ntaub ntawv thiab tsis tas yuav siv cov kab kos loj loj nrog ntau yam khoom thiab cov cuab yeej. Yog tias koj xav tau, koj tuaj yeem siv ob qho tib si graphs thiab sparklines rau tib cov ntaub ntawv.
Tsim Sparklines hauv Excel
Raws li txoj cai, ib qho sparkline yog tsim rau txhua cov ntaub ntawv series, tab sis yog tias koj xav tau, koj tuaj yeem tsim ib tus naj npawb ntawm sparklines thiab tso rau qhov tsim nyog. Txoj hauv kev yooj yim tshaj plaws los tsim thawj sparkline yog nyob rau saum toj kawg nkaus kab ntawm cov ntaub ntawv, thiab tom qab ntawd siv tus cim autofill los luam nws mus rau tag nrho cov kab txuas ntxiv. Hauv qhov piv txwv hauv qab no, peb yuav tsim ib daim ntawv sparkline kom pom qhov muag muag rau txhua tus neeg muag khoom nyob rau lub sijhawm tshwj xeeb.
- Xaiv cov hlwb uas yuav ua hauj lwm raws li cov tswv yim rau thawj sparkline. Peb yuav xaiv qhov ntau B2: G2.
- Nyem lub tab Insert thiab xaiv yam xav tau ntawm sparkline. Piv txwv li, ib daim duab sparkline.
- Ib lub dialog box yuav tshwm sim Tsim Sparklines. Siv tus nas, xaiv lub xovtooj los tso lub sparkline, thiab tom qab ntawd nyem OK. Nyob rau hauv peb rooj plaub, peb yuav xaiv cell H2, qhov txuas mus rau lub cell yuav tshwm nyob rau hauv daim teb Qhov chaw nyob ntau yam.
- Lub sparkline yuav tshwm nyob rau hauv lub cell xaiv.
- Nyem thiab tuav lub khawm laug nas thiab luag tus autofill kov kom luam cov sparkline rau cov hlwb uas nyob ib sab.
- Sparklines yuav tshwm sim hauv txhua kab ntawm lub rooj. Cov duab hauv qab no qhia tau hais tias cov sparklines pom kev muag khoom rau txhua tus neeg muag khoom nyob rau lub hlis twg.
Hloov cov tsos ntawm sparklines
Kho cov tsos ntawm sparkline yog heev yooj yim. Excel muaj ntau yam cuab yeej rau lub hom phiaj no. Koj tuaj yeem kho cov duab kos, teeb xim, hloov hom thiab style ntawm sparkline, thiab ntau ntxiv.
Marker zaub
Koj tuaj yeem tsom mus rau qee qhov chaw ntawm cov duab ci ntsa iab siv cov cim lossis cov ntsiab lus, yog li ua kom nws cov ntaub ntawv. Piv txwv li, ntawm lub sparkline nrog ntau qhov loj thiab me, nws yog qhov nyuaj heev kom nkag siab qhov twg yog qhov siab tshaj plaws thiab qhov twg yog qhov tsawg kawg nkaus. Nrog kev xaiv enabled Qhov siab tshaj plaws и Yam tsawg kawg nkaus ua kom yooj yim dua.
- Xaiv cov sparklines koj xav hloov. Yog tias lawv tau muab tso rau hauv cov hlwb nyob sib ze, ces nws txaus los xaiv ib qho ntawm lawv los xaiv tag nrho cov pab pawg ib zaug.
- Hauv Advanced tab constructor nyob rau hauv pawg lus txib Qhia pab kev xaiv Qhov siab tshaj plaws и Yam tsawg kawg nkaus.
- Cov tsos ntawm sparklines yuav hloov kho.
Hloov style
- Xaiv cov sparklines koj xav hloov.
- Hauv Advanced tab constructor nyem rau ntawm lub xub dropdown kom pom ntau yam.
- Xaiv cov style uas xav tau.
- Cov tsos ntawm sparklines yuav hloov kho.
Hom hloov
- Xaiv cov sparklines koj xav hloov.
- Hauv Advanced tab constructor xaiv hom sparkline koj xav tau. Piv txwv li, bar daim qauv qhia.
- Cov tsos ntawm sparklines yuav hloov kho.
Txhua hom sparkline yog tsim los rau cov hom phiaj tshwj xeeb. Piv txwv li, qhov yeej / poob sparkline yog qhov tsim nyog rau cov ntaub ntawv uas muaj qhov zoo lossis qhov tsis zoo (piv txwv li, cov nyiaj tau los ntawm cov nyiaj tau los).
Hloov cov zaub ntau yam
Los ntawm lub neej ntawd, txhua qhov sparkline hauv Excel yog ntsuas kom haum rau qhov siab tshaj plaws thiab qhov tsawg kawg nkaus ntawm nws cov ntaub ntawv. Tus nqi siab tshaj plaws yog nyob rau sab saum toj ntawm tes, thiab qhov tsawg kawg nkaus yog nyob rau hauv qab. Hmoov tsis zoo, qhov no tsis qhia qhov loj ntawm tus nqi thaum piv rau lwm cov sparklines. Excel tso cai rau koj hloov cov tsos ntawm sparklines kom lawv tuaj yeem muab piv rau ib leeg.
Yuav ua li cas hloov cov zaub ntau yam
- Xaiv cov sparklines koj xav hloov.
- Hauv Advanced tab constructor xaiv pab neeg Axis. Ib tug dropdown zaub mov yuav tshwm.
- Nyob rau hauv cov kev txwv rau qhov siab tshaj plaws thiab yam tsawg kawg nkaus qhov tseem ceeb raws li txoj kab ntsug, pab txoj kev xaiv Kho rau tag nrho cov sparklines.
- Sparklines yuav hloov kho. Tam sim no lawv tuaj yeem siv los sib piv kev muag khoom ntawm cov neeg sawv cev muag.