Yuav Paub
- Qhib daim ntawv nthuav qhia lossis tsim ib qho tshiab. Xaiv cov hlwb thiab xaiv Insert > Chart; xaiv Bar rau daim ntawv qhia bar thiab siv daim ntawv khohloov kho.
- Or, xaiv Line, Area, Kum, Pie , Scatter, daim ntawv qhia, lossis lwm hom kab kos. Txhawm rau hloov daim ntawv qhia txhua lub sijhawm, nyem ob npaug rau nkag mus rau Daim Ntawv Qhia.
- In the iOS or Android version of Sheets, xaiv cov hlwb, thiab tom qab ntawd coj mus rhaub Insert (ntxiv rau kos npe) > Chart. Coj mus rhaub Type thiab xaiv ib daim ntawv qhia style.
Kab lus no piav qhia yuav ua li cas ntxiv ntau hom kab kos thiab duab rau koj daim ntawv qhia Google. Muaj ntau ntau qhov kev hloov pauv muaj, suav nrog cov kev xaiv siv ntau yam xws li kab kos thiab cov kab kos duab kos duab nrog rau cov ntaub ntawv tsis tshua paub pom xws li cov phiaj xwm tawg thiab cov duab ntoo.
Ua Bar Graph
Tsim ib daim duab, uas tuaj yeem hloov kho rau lwm hom tom qab yog tias koj xav tau.
Desktop/Laptop (feem ntau lub web browsers; Google Chrome nyiam)
- Qhib ib daim ntawv uas twb muaj lawm lossis tsim ib qho tshiab los ntawm kos.
- Sau tag nrho cov ntaub ntawv uas koj xav siv hauv koj daim duab qhia, yog tias tsim nyog. Cov ntaub ntawv no feem ntau yuav tsum yog nyob rau hauv daim ntawv, raws li qhia nyob rau hauv lub screenshot nrog.
- Xaiv tag nrho cov hlwb uas muaj cov ntaub ntawv uas koj xav kom suav nrog hauv koj daim duab bar, suav nrog cov ntawv headers yog xav tau. Koj tuaj yeem xaiv hla cov kauj ruam no thiab txhais cov ntaub ntawv ntau yam tom qab daim duab tau tsim lawm, txawm hais tias ua li no feem ntau yooj yim dua.
- Xaiv Insert kev xaiv los ntawm Google Sheets ntawv qhia zaub mov, nyob rau sab saum toj ntawm lub vijtsam. Thaum daim ntawv teev npe poob lawm, nyem rau ntawm Daim Ntawv.
- Koj daim ntawv qhia tam sim no yuav tshwm sim, overlaying qee lub hlwb hauv koj daim ntawv nthuav qhia. Xaiv thiab luag nws mus rau qhov chaw xav tau. Koj tuaj yeem kho nws qhov loj me ntawm qhov no los ntawm txhaj thiab rub lub kaum xiav lossis sab qhia raws li.
- Daim Ntawv Qhia editor interface yuav tsum pom, nyob rau sab xis ntawm koj lub qhov rais browser. Nyem rau ntawm DATA header, yog tias nws tsis tau xaiv. Tom ntej no, xaiv cov ntawv qhia zaub mov hauv kab ntawv hom ntu.
- Ib daim duab thumbnail uas sawv cev rau txhua daim ntawv qhia thiab hom duab yuav tsum tau muab tso tawm tam sim no, tawg los ntawm qeb. Scroll cia rau hauv seem sau npe Bar thiab xaiv thawj qhov kev xaiv, Bar chart.
- Yog tias koj hla Kauj Ruam 1 thiab tseem tsis tau txhais lub hauv paus rau koj daim duab kos, nyem rau ntawm lub pob nyob rau hauv cov ntaub ntawv ntau ntu thiab nkag mus rau ib lossis ntau pawg ntawm cov hlwb uas muaj cov ntaub ntawv uas koj xav tau piav qhia.
- Lub sijhawm no, cov hauv paus ntawm koj daim duab qhia yuav tsum nyob hauv qhov chaw. Raws li koj tuaj yeem pom, muaj ntau lwm qhov kev hloov kho tau yooj yim nyob rau hauv Daim Duab Editor interface uas koj tuaj yeem ua si ib puag ncig kom txog thaum koj daim duab layout thiab cov ntsiab lus raws nraim li koj nyiam.
Android/iOS
- Xaiv Google Sheets app.
- Qhib ib daim ntawv uas twb muaj lawm lossis tsim ib qho tshiab los ntawm kos.
- Sau tag nrho cov ntaub ntawv uas koj xav siv hauv koj daim duab qhia, yog tias tsim nyog. Cov ntaub ntawv no feem ntau yuav tsum yog nyob rau hauv daim ntawv, raws li qhia nyob rau hauv lub screenshot nrog.
- Xaiv tag nrho cov hlwb uas muaj cov ntaub ntawv uas koj xav kom suav nrog hauv koj daim duab qhia chaw, suav nrog cov headers yog xav tau.
- Coj mus rhaub lub Insert khawm, sawv cev los ntawm lub cim ntxiv (+) thiab nyob rau saum koj lub vijtsam.
- Thaum lub Insert menu tshwm, xaiv Daim ntawv.
- Ib qho piv txwv ntawm qhov koj daim ntawv zoo li tam sim no yuav tshwm sim, nrog rau ntau txoj kev xaiv. Coj mus rhaub ib daim ntawv lo Type.
- Ib txheej ntawm ntau dua kaum daim kab kos thiab cov duab yuav tsum pom, sib cais los ntawm qeb. Scroll cia rau hauv seem sau npe BAR thiab xaiv thawj qhov kev xaiv. Nws yuav tsum raug sau tseg tias qee hom kab ntawv thiab daim duab tsuas yog muaj nyob hauv lub computer version ntawm Google Sheets thiab tsis muaj rau Android lossis iOS li.
- Coj mus rhaub cov cim kos nyob rau ntawm kaum sab laug sab laug ntawm lub vijtsam.
- Koj daim duab bar yuav tsum tam sim no nyob rau hauv qhov chaw, overlaying cov hlwb uas twb muaj lawm hauv koj daim ntawv nthuav qhia. Luag thiab xa nws mus rau qhov chaw xav tau, nyiam dua hauv qab lossis ib sab ntawm cov ntaub ntawv.
Kho koj daim duab tom qab, tsuas yog ob npaug nyem rau ntawm nws kom daim duab editor tshwm (browser-based version) lossis coj mus rhaub nws thiab xaiv Kho Daim Ntawv khawm (Android/iOS app).
Lwm hom kab ntawv
Hauv qhov piv txwv saum toj no peb tau qhia koj yuav ua li cas los tsim ib daim duab qhia, tsuas yog ib qho ntawm ntau kab ntawv muaj nyob hauv Google Sheets. Los ntawm kev ua raws li cov kauj ruam tib yam thiab xaiv ib hom sib txawv thaum raug ceeb toom koj tuaj yeem suav nrog ib lossis ntau qhov hauv qab no hauv koj daim ntawv nthuav qhia. Raws li koj yuav pom, qee qhov kev xaiv tsuas yog muaj nyob hauv browser-based version ntawm Google Sheets.
kab kab kos
- Standard
- Smooth
- Combo
Area charts
- Standard
- thaj chaw sib tw
- 100% pawg thaj chaw (browser nkaus xwb)
- ntxhais chaw
- Stacked stepped cheeb tsam (browser nkaus xwb)
- 100% stacked cheeb tsam (browser nkaus xwb)
kab kos kab
- Standard
- Tshuaj
- 100% stacked
Bar charts
- Standard
- Tshuaj
- 100% stacked (browser nkaus xwb)
Pie charts
- Standard
- Doughnut
- 3D
Scatter charts
- Standard
- Bubble
daim ntawv qhia
- Geo (browser nkaus xwb)
- Geo nrog cov cim (browser nkaus xwb)
Muaj kab kos
- dej tsaws tsag (browser nkaus xwb)
- Sparkline (browser nkaus xwb)
- Histogram (browser nkaus xwb)
- Radar (browser nkaus xwb)
- Gauge (browser nkaus xwb)
- Kev Koom Tes (browser nkaus xwb)
- Tree map (browser only)
- Timeline (browser nkaus xwb)
- Table (browser nkaus xwb)
