Mid ayaa si fudud u go'aamin kara isbeddelka ka soo baxa xogta jira isagoo ku daraya Trendline. Microsoft Excel waxa uu leeyahay qalabkan. Sidan oo kale, waxay tusi kartaa saadaalinta qaabka guud iyo jihada guud ee xogtaada. Aan ku dhex marno tillaabooyinka si aad ugu darto Trendline gudaha Office Excel^{(add a Trendline in Office Excel)} .

Kudar Trendline xaashida shaqada ee Excel

Trendline in Excel waa xariiq muujinaysa isbeddel guud (kor u kaca/hoos u dhaca ama korodhka/hoos u dhaca). Sidaa darteed, waxay kaa caawin kartaa fasiraadda degdega ah ee xogta. Jadwalka isbeddelka ee Excel waxaa lagu dari karaa jaantusyo kala duwan, oo ay ku jiraan jaantusyada bar, jaantusyada xariiqda, meelaha kala firdhisan iyo in ka badan.

Aan si dhakhso leh kuugu soo gudbino habka -

1. Samaynta jaantus
2. Ku darista khadadka isbeddelka
3. Samaynta khadka isbeddelka
4. Ku darista khadka celceliska dhaqaaqa.

Fadlan^(Please) la soco in tillaabooyinka ku jira boostadan ay khuseeyaan noocyada Office 2019/2016/2013 .

1] Samaynta jaantus

Geli^(Enter) xogta aad rabto inaad u abuurto jaantus.

Marka xigta, dooro xogta oo dooro 'I nsert ' tab.

U gudub qaybta ' Charts lagu taliyay^{(Recommended Charts)} ' oo guji jaantus kasta si aad u hesho dulmar xogta (Haddii aadan arkin jaantuska aad jeceshahay, dhagsii dhammaan jaantusyada si aad u aragto dhammaan noocyada jaantusyada la heli karo).

2] Ku darista khadadka isbeddelka

Kadib markaad abuurto jaantus, dooro, oo ku dhufo '+' icon ka muuqda ee ku xiga shaxda.

Hoos^(Scroll) u dhaadhac liiska xulashooyinka oo dooro ' Trendline '.

Guji fallaadha-dhinaca si aad u aragto doorashooyin badan oo dooro ikhtiyaarka la rabo.

Fadlan^(Please) ogow in Excel uu soo bandhigo ikhtiyaarka Trendline kaliya marka aad doorato jaantus leh wax ka badan hal xog oo taxane ah adiga oo aan dooran taxane xog.

3] Samaynta khadadka isbeddelka

Mar labaad, taabo calaamadda '+', dooro ' Trendline ', hoos u dhaadhac oo dooro ' Doorasho badan^{(More options)} '

Marka shayga^(Format) Qaabku uu noqdo mid muuqda, dooro ikhtiyaarka isbeddelka ee liiska hoos u dhaca.

Sida caadiga ah, Excel wuxuu geliyaa khad toosan. Si kastaba ha ahaatee, waxaad ku dari kartaa kala duwanaansho kale oo aad doorato sida,

• Jaban
• toosan
• Logarithmic
• Polynomial
• Awood
• Celceliska Dhaqdhaqaaqa

U deji qiime dhinaca hore^(Forward) iyo gadaalba^(Backward) si aad xogtaada mustaqbalka u socodsiiso. Dejinta khadadka isbeddelku waa hab xisaabeed oo lagu cabbiro xogta.

4] Ku dar celceliska xarriiqda dhaqaaqa

Haddii aad dareento inaad u habaynayso khadadkaaga isbeddelka si ay u noqoto khad dhexdhexaad ah, waad samayn kartaa. Tan awgeed,

Guji meel kasta oo shaxda ah.

U beddel tab ' Qaabka^(Format) ', oo hoosteeda ' Xulashada Hadda^{(Current Selection)} ', dooro ikhtiyaarka isbeddelka ee liiska hoos-u-dhaca.

Marka xigta, guji ' Format Selection ' doorasho.

Kadibna, laga bilaabo qaabka ' Trendline ' shayga, hoosta ' Trendline Options ', dooro celceliska^(Average) dhaqdhaqaaqa . Sheeg qodobada haddii loo baahdo. ( Si naxariis^(Kindly) leh u fiirso in tirada dhibcaha ee celceliska isbeddelka dhaqaaqa ay la mid tahay tirada guud ee dhibcaha taxanaha oo ka yar tirada aad sheegtay muddada).

Sidan, waxaad ku dari kartaa jaantuska jaantuska Excel oo aad ku dari kartaa qoto dheer macluumaadkeeda.

How to add a Trendline in Microsoft Excel worksheet

One can easily determіne the trend that emerges from the existing data by adding a Trendline to it. Miсrоsoft Excel featureѕ this tоol. As such, it can show predict the general pattern and the overall dіrection of your data. Let us walk you through the steps to add a Trendline in Office Excel.

Add a Trendline in Excel worksheet

Trendline in Excel is a line that shows a general trend (upwards/downwards or increase/decline). Thus, it can help in a quick interpretation of the data. The trendline in Excel can be added to a variety of charts, including bar charts, line charts, scatter plots and more.

Let’s quickly get you through the process of-

1. Creating a chart
2. Adding a trendline
3. Formatting a trendline
4. Adding a moving average line.

Please note that the steps in this post apply to Office 2019/2016/2013 versions.

1] Creating a chart

Enter the data for which you want to create a chart.

Next, select the data and choose ‘Insert’ tab.

Scroll through the category of ‘Recommended Charts’ and click any chart to get a preview of the data (If you don’t see a chart you like, click All Charts to see all the available chart types).

2] Adding a trendline

After having created a chart, select it, and hit the ‘+’ icon visible adjacent to the chart.

Scroll down the list of options and select ‘Trendline’.

Click the side-arrow to view more options and choose the desired option.

Please note that Excel displays the Trendline option only when you select a chart that has more than one data series without selecting a data series.

3] Formatting a trendline

Again, press the ‘+’ sign, choose ‘Trendline’, scroll down and select ‘More options’

When the Format pane becomes visible, select the trendline option in the dropdown list.

By default, Excel inserts a linear trendline. However, you can add other variations of your choice like,

• Exponential
• Linear
• Logarithmic
• Polynomial
• Power
• Moving Average

Set a value in the Forward and Backward fields to project your data into the future. Formatting a trendline is a statistical way to measure data.

4] Add a moving average line

If you feel like formatting your trendline to a moving average line, you can do so. For this,

Click anywhere in the chart.

Switch to the ‘Format’ tab, and under its ‘Current Selection’ group, select the trendline option in the drop-down list.

Next, click ‘Format Selection’ option.

Then, from the Format ‘Trendline‘ pane, under ‘Trendline Options‘, select Moving Average. Specify the points if necessary. (Kindly note that the number of points in a moving average trendline equals the total number of points in the series less the number that you specify for the period).

This way, you can add a trendline to an Excel chart and add more depth in its information.

Related posts

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

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

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo abuuro Gantt Charts gudaha Microsoft Excel

• Sida loo kiciyo oo loogu shubo wax-ku-darka Solver ee Microsoft Excel haddii aanu shaqaynayn

• Sida loo qaboojiyo safafka iyo tiirarka gudaha Excel

• Sida loo Quful Unugyada Microsoft Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Talooyin iyo tabaha Microsoft Excel ee bilowga ah

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Si degdeg ah ugu beddelo Xaashiyaha shaqada ee Excel

• Microsoft Excel waxay fureysaa xaashi maran halkii faylka

• Sida Looga Badalo Saafka ama Saafka Excel [Tallaabo Talaabo]

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Dib u eegis buug - Microsoft Excel 2010 Talaabo Talaabo ah

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10