Cov txheej txheem:

Yuav ua li cas koj hloov qhov loj ntawm daim ntawv ncuav qab zib hauv Excel?
Yuav ua li cas koj hloov qhov loj ntawm daim ntawv ncuav qab zib hauv Excel?

Video: Yuav ua li cas koj hloov qhov loj ntawm daim ntawv ncuav qab zib hauv Excel?

Video: Yuav ua li cas koj hloov qhov loj ntawm daim ntawv ncuav qab zib hauv Excel?
Video: Saib Mis paub Poj niam (hluas nkauj) tus yam ntxwv lub siab 2024, Plaub Hlis Ntuj
Anonim

Txhawm rau hloov pauv daim duab, ua ib qho ntawm cov hauv qab no:

  1. Rau hloov qhov loj manually, nyem qhov daim duab , thiab ces luag cov sizing handles rau lub qhov loj uas koj xav tau.
  2. Txhawm rau siv qhov ntsuas qhov siab thiab qhov dav, ntawm Formattab, hauv Loj pab pawg, nkag mus rau qhov loj hauv lub thawv Heightand Width.

Tsuas yog li ntawd, koj ua li cas nce qhov loj ntawm daim ntawv ncuav qab zib?

Nyem Qhia Kuv ntawm lub toolbar, tom qab ntawd xaiv qhov paj ntaub hom. Qhov tshwm sim yog qhov me me paj : Ua kom daim duab loj dua, tuav Ctrl + Ua haujlwm (tuav ñ + z ntawm Mac) thiab nias B ob peb zaug. Txhawm rau ntxiv cov ntawv sau, rub cov Sub-Category dimension los ntawm Cov Ntaub Ntawv pane rau Cov Ntawv Sau rau ntawm Markscard.

Qhov thib ob, Kuv yuav ua li cas txav daim ntawv ncuav qab zib mus rau lwm daim ntawv ua haujlwm hauv Excel? Rau txav ib daim duab rau hauv nws tus kheej daim ntawv , ua ntej, xaiv lub daim duab . Tom qab ntawd, mus rau Qhov Tsim tab hauv qab Daim duab Cov cuab yeej, thiab nyem qhov Tsiv daim ntawv khawm. Cov Txav mus dialog yuav qhib thiab koj yuav pom ob txoj kev xaiv, "Tshiab Daim ntawv ", thiab "Object in". Xaiv Tshiab Daim ntawv.

Ib yam li ntawd, kuv yuav hloov qhov chaw hauv daim ntawv Excel li cas?

Hloov loj daim duab cheeb tsam hauv Excel Nyem qhov daim duab , thiab nyem Layout tab (lossis Formattab). Saib cov screenshot: 2. Tom qab ntawd mus rau pawg xaiv tam sim no, thiab xaiv Daim duab Area los ntawm nias qhov poob downarrow.

Yuav ua li cas hloov qhov dav ntawm daim duab bar hauv Excel?

Nyem rau qhov twg bar hauv Daim Ntawv Qhia Bar andright nyem rau ntawm nws, ces xaiv Format Data Series los ntawm txoj cai-nias ntawv qhia zaub mov. Saib screenshot: 2. Nyob rau hauv lub popping li FormatData Series pane, txav lub Zoom bar ntawm Gap Dav mus rau sab laug mus txog rau lub bar dav ua tau raws li koj xav tau nyob rau hauv ntu Series Options.

Pom zoo: