Haddii aadan rabin inaad dhaqaajiso jaantus adigoo bedelaya ballaca unugga, waxaad ku xiri kartaa booska jaantuska^{(lock the chart position)} xaashida Excel ee hagahan. In kasta oo jaantusku u socdo sida ballaca unugyada iyo booska, waad joojin kartaa tan.

Gudaha Excel, way fududahay in la geliyo jaantuska Gantt ama jaantus firfircoon^{(a Dynamic chart)} . Si kastaba ha ahaatee, dhibaatadu waxay bilaabataa markaad ku darto unugyo badan ama tiirar ka dib markaad geliso jaantus xaashida. Sida caadiga ah, Excel wuxuu dhaqaajiyaa jaantuska si wax walba u noqdaan kuwo muuqda iyada oo aan la isku dhejin. Si kastaba ha ahaatee, mararka qaarkood, waxaa laga yaabaa inaad u baahato inaad hagaajiso booska shaxdaada sabab kasta ha ahaatee. Haddii ay sidaas tahay, waxaad raaci kartaa casharkan.

Sida loo xidho booska jaantuska xaashida^(Chart) xaashida ee Excel

Si aad u quful booska jaantuska oo aad uga^(Chart) hortagto inuu ku dhaqaaqo xaashida xaashida ee Excel , raac tillaabooyinkan-

1. Midig ku dhufo shaxanka jira
2. Ka dooro Aagga Qaabka Shaxda^{(Format Chart Area)} ikhtiyaarka ah liiska macnaha guud.
3. U beddel cabbirka & agabka^{(Size & Properties)} tab.
4. Balaadhi Guryaha^(Properties) .
5. Dooro Ha guurin ama ha ku cabbirin unugyada^{(Don’t move or size with cells)} .

Aynu si faahfaahsan u dul istaagno tillaabooyinkan.

Marka hore, waxaad u baahan tahay inaad geliso jaantus xaashidaada. Waxaad geli kartaa nooc kasta oo jaantus ah - iyadoon loo eegayn inay tahay 2D fudud, 3D, ama wax kale. Ka dib markaad ku darto jaantuska xaashidaada, waxaad u baahan tahay inaad midig-guji jaantuska.

Halkan waa inaad maskaxda ku haysaa shay muhiim ah. Waa inaad midig-gujisaa goobta dhulka. Haddii kale, ma heli kartid ikhtiyaarka hoos lagu sheegay.

Haddii aad si sax ah u riixi karto jaantuska, waa inaad aragto ikhtiyaarka loo yaqaan ' Format Chart Area ' .

Kadib markaad riixdo doorashadaas, waxaad ka heli kartaa guddi dhinacaaga midig ah. Sida caadiga ah, waa in ay furto Buuxinta & Line^{(Fill & Line)} . Y

waxaad u baahan tahay inaad u wareegto tab saddexaad, oo loo yaqaan Size & Properties . Taas ka dib, balaadhi Properties menu.

Sida caadiga ah, waa in loo dejiyaa Dhaqdhaqaaq iyo cabbir unugyo leh,^{(Move and size with cells,)} taasina waa sababta jaantuskaagu u dhaqaaqo marka aad gasho tiir cusub ama aad beddesho ballaca unugga jira.

Si aad u xirto booska, waxaad u baahan tahay inaad dooratid Ha dhaqaaqin ama ku cabbir^{(Don’t move or size with cells)} ikhtiyaarka unugyada.

Waa intaas! Hadda wixii ka dambeeya, jaantuskaagu ma dhaqaaqi doono xitaa haddii aad beddesho ballaca unugga.

Waxaan rajeyneynaa in casharradan fudud ay ku caawin doonto.

Hadda akhri: ^{(Now read: )}Sida loo sameeyo garaaf qalloocan oo siman gudaha Excel iyo Google Sheets.^{(How to make a smooth curved graph in Excel and Google Sheets.)}

How to lock Chart position in Excel spreadsheet

Іf you do not want to mоve a chart while changing the width of the cell, you can lock the chart position in an Excel spreadsheet with this guide. Although the chart moves as per the cells’ width and position, you can disable this.

In Excel, it is straightforward to insert a Gantt chart or a Dynamic chart. However, the problem starts when you include more cells or columns after inserting a chart in a spreadsheet. By default, Excel moves the chart so that everything becomes visible without overlapping. However, at times, you might need to fix the position of your existing chart for any reason. If so, you can follow this tutorial.

How to lock Chart position in Excel spreadsheet

To lock the position of a Chart and prevent it from moving in an Excel spreadsheet, follow these steps-

1. Right-click on the existing chart.
2. Select the Format Chart Area option from the context menu.
3. Switch to Size & Properties tab.
4. Expand Properties.
5. Select Don’t move or size with cells.

Let’s delve into these steps in detail.

At first, you need to insert a chart in your spreadsheet. You can enter any kind of chart – no matter whether it is a simple 2D, 3D, or anything else. After adding a chart in your spreadsheet, you need to right-click on the chart.

Here you should keep an essential thing in mind. You should right-click on the plot area. Otherwise, you cannot find the option that is mentioned below.

If you can correctly right-click on the chart, you should see an option called Format Chart Area.

After clicking that option, you can find a panel on your right side. By default, it should open Fill & Line. Y

ou need to switch to the third tab, which is called Size & Properties. After that, expand the Properties menu.

By default, it should be set to Move and size with cells, and that is why your chart moves when you enter a new column or change the width of an existing cell.

To lock the position, you need to select Don’t move or size with cells option.

That’s all! From now onward, your chart won’t move even if you change the cell width.

Hope this simple tutorial will help you.

Now read: How to make a smooth curved graph in Excel and Google Sheets.

Related posts

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo abuuro Graph Bar ama Shaxda Saxiixa ee Excel

• Sida loo sameeyo shaxda Pie ee Excel

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sida loo beddelo midabka jaantuska caadiga ah ee Word, Excel, PowerPoint

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo sameeyo shaxda Pie ee Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo abuuro jaantus isku-dhafan gudaha Excel

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog