Plot Area hauv Excel thiab Google Spreadsheets

Cov txheej txheem:

Plot Area hauv Excel thiab Google Spreadsheets
Plot Area hauv Excel thiab Google Spreadsheets
Anonim

Cov phiaj xwm hauv ib daim duab lossis daim duab hauv cov ntawv nthuav qhia xws li Excel thiab Google Sheets yog hais txog thaj tsam ntawm daim duab uas qhia cov ntaub ntawv uas tau teev tseg. Nyob rau hauv cov ntaub ntawv ntawm ib kem los yog bar graph, nws muaj xws li cov axes. Nws tsis suav nrog lub npe, daim phiaj uas khiav tom qab daim duab thiab ib qho tseem ceeb uas luam tawm hauv qab.

Nyob rau hauv kab ntawv kab lus lossis kab kos duab, thaj chaw thaj tsam qhia cov kab ntsug lossis kab nrog txhua kab sawv cev rau ib kab ntawv.

Nyob rau hauv daim ntawv qhia ncuav qab zib, thaj tsam thaj tsam yog lub voj voog xim nyob hauv nruab nrab ntawm daim ntawv uas tau muab faib ua cov kab los yog cov hlais. Cov phiaj xwm thaj tsam ntawm daim ntawv qhia ncuav qab zib sawv cev rau ib cov ntaub ntawv series.

Ntxiv rau cov ntaub ntawv, thaj chaw thaj chaw kuj suav nrog daim ntawv qhia kab rov tav X-axis thiab ntsug Y axis qhov twg siv tau.

Yuav luag txhua qhov kev pabcuam spreadsheet siv tib lub logic-tsis yog Excel xwb. Thiab cov ntsiab lus peb tshawb nrhiav hauv kab lus no muaj feem xyuam rau txhua qhov kev txhawb nqa tam sim no ntawm Excel ntawm kev ua lag luam.

Thaj Chaw thiab Daim Ntawv Ua Haujlwm

Qhov thaj chaw ntawm daim duab yog dynamically txuas rau cov ntaub ntawv nws sawv cev rau hauv daim ntawv ua haujlwm nrog.

Nyem rau ntawm daim ntawv qhia feem ntau qhia txog cov ntaub ntawv txuas hauv daim ntawv ua haujlwm nrog cov xim ciam teb. Ib qho txiaj ntsig ntawm qhov kev sib txuas no yog qhov kev hloov pauv rau cov ntaub ntawv kuj tau tshwm sim hauv daim ntawv qhia, uas ua rau nws yooj yim los khaws cov kab kos mus txog hnub tim.

Hauv daim ntawv qhia ncuav qab zib, piv txwv li, yog tias tus lej hauv daim ntawv ua haujlwm nce ntxiv, ntu ntawm daim ntawv ncuav qab zib sawv cev tus lej ntawd kuj nce ntxiv.

Nyob rau hauv rooj plaub ntawm kab kab thiab kab kab kos, ntxiv cov ntaub ntawv ntxiv rau daim ntawv qhia los ntawm kev nthuav cov xim ciam teb ntawm cov ntaub ntawv txuas kom suav nrog ib lossis ntau cov ntaub ntawv ntxiv.

Yuav ua li cas tsim ib daim ntawv hauv Excel

Image
Image

Tsim ib daim ntawv qhia, thiab kom nkag mus rau nws thaj chaw, xaiv ntau cov ntaub ntawv hauv koj daim ntawv nthuav qhia. Los ntawm Insert tab, xaiv hom kab ntawv uas koj xav tau los ntawm ribbon. Sim cov Daim Ntawv Pom Zoo cuab yeej rau kev sib tham sib xaiv. Thaum daim duab tsim, los ntawm lub neej ntawd nws tau muab tso rau hauv koj daim ntawv ua haujlwm.

Tsim ib daim ntawv qhia hauv Google Sheets tib yam. Qhov txawv tsuas yog qhov Insert yog nyob rau saum lub qhov rais spreadsheet es tsis yog ntawm cov ntawv qhia zaub mov.

Pom zoo: