Marka aad ku abuurto jaantusyada xariiqda Excel^{(create line charts in Excel)} , waxa aad ku sawiranaysaa dhibcaha xogta ee dhidibka X iyo Y. Tani waxay faa'iido u leedahay isbeddelka xogta waqti ka dib, laakiin maxaa dhacaya haddii aad sidoo kale rabto inaad isbeddel ku sameyso inta dhibcaha xogtaas ay ka fog yihiin "ku-habboonaanta" ama inta ay ku kala duwan yihiin waqtiga?

Margin qaladka iyo leexashada caadiga ah ayaa ah sababta ugu badan ee dadku u adeegsadaan astaanta bar khaladka ee jaantusyada Excel . Markaad ku darto baararka qaladka ee Excel , waxaad arki kartaa qaladka caadiga ah ama leexashada calaamad kasta oo shaxda ah.

Si kastaba ha ahaatee, waxaad isticmaali kartaa baararka qaladka ujeedooyin kala duwan. Asal ahaan^(Basically) , wakhti kasta oo aad rabto inaad ku darto dhibco sare iyo hoose oo ay weheliyaan dhibcaha xogta shakhsi ahaaneed, baararka qaladku waxay ku caawin karaan.

Baararka khaladku waxay diyaar ku yihiin Excel meelaha, bar, tiirka, laynka, kala firdhiso, iyo jaantusyada xumbo.

Margin of Error & Standard Deviation

Kahor intaadan baran sida loogu daro baararka qaladka ee Excel , waxaa muhiim ah in la fahmo waxa labada margin ee qaladka iyo weecashada caadiga ah ay yihiin.

• Margin qaladku^{(Margin of error)} waa "hubaal la'aanta" barta xogta. Tan waxaa caadi ahaan loo adeegsadaa tirakoobka marka xogtu ay tahay muunad ka kooban dad badan. Xadka khaladku wuxuu kuu sheegayaa inta xogta laga helayo muunaddaas ay kaga duwanaan karto natiijada "dhabta ah" ee dadka oo dhan. 

• weecasho caadi ah^{(Standard deviation)} waa qayb loo isticmaalo xisaabinta margin qaladka. weecasho halbeeggu waa cabirka sida xogtada loo faafiyay. Waxay kuu sheegaysaa inta ay le'eg tahay dhibcaha xogta ay ku faafsan yihiin celceliska guud ama celceliska dhammaan dhibcaha xogta.

Waxaad xisaabin kartaa qaladka khaladka ah iyo leexashada caadiga ah naftaada ( Excel xitaa wuxuu bixiyaa shaqooyinka leexinta caadiga ah^{(Excel even provides standard deviation functions)} ). Ama, waxaad ku dari kartaa baararka qaladka ee Excel oo u ogolow Excel inuu kuu sameeyo xisaabinta.

Sida Looga Daro Baararka Cilada ee Excel

Si aad ugu darto baararka qaladka ee Excel , waxaad u baahan tahay inaad ku bilowdo garaaf jira oo aad hore u abuurtay. 

1. Si aad u bilowdo, guji jaantuska ka dibna dooro badhanka Chart Elements (calaamadaha +) ee ku yaal geeska kore ee midig ee jaantuska.

2. Hubi sanduuqa khaladaadka^{(Error Bars)} si aad awood ugu yeelato baararka garaafkaaga. Kadibna, dooro falaarta dhanka midig ee xulashada Baararka Cilada^{(Error Bars)}

3. Sanduuqa pop-up-ka ee aad aragto ayaa ku siinaya dhowr fursadood oo aad ku habeyn karto qadarka qaladka ah ee baararka qaladku ku muujin doonaan jaantuska.

Kahor intaadan dooran mid ka mid ah xulashooyinka horay loo habeeyey, waxaa muhiim ah inaad fahamto ikhtiyaar kastaa wuxuu ka dhigan yahay iyo sida uu u shaqeeyo.

Khaladaadka Xulashada Bar ee Excel

Waxaad ka dooran kartaa saddexda ikhtiyaar ee bar qaladka ee hore loo habeeyey ee Excel . 

• Khaladka caadiga^{(Standard Error)} ah : Wuxuu muujiyaa qaladka caadiga ah barta xog kasta
• Boqolkiiba^(Percentage) : Excel wuxuu xisaabiyaa oo soo bandhigaa boqolleyda khaladka gaarka ah barta xog kasta
• Isbeddelka caadiga ah^{(Standard Deviation)} : Excel wuxuu xisaabiyaa oo muujiyaa weecashada caadiga ah (hal qiime) dhammaan qiyamka

Xisaabinta dhabta ah ee weecinta caadiga ah waa xoogaa adag oo ka baxsan baaxadda qodobkan. 

Haddii aad rabto inaad xisaabiso weecaada caadiga ah naftaada oo aad muujiso qiimahaas beddelkeeda waxaad samayn kartaa taas.

Sanduuqa qaladka ee bar-hoosaadka, dooro Ikhtiyaar badan^{(More Options)} oo ku yaal xagga hoose ee liiska. Tani waxay furi doontaa daaqada Qaladka Bar Options . ^{(Error Bar Options)}Dooro summada garaafka ee sare si aad ugu wareegtid^{(Vertical Error Bar)} Xulashooyinka Bar Qaladka Toosan.

Marka loo eego Qaddarka Khaladaadka^{(Error Amount)} , waxaad dooran kartaa Qiimaha go'an , ^(Fixed)Boqolleyda^(Percentage) , ama weecashada caadiga^(Standard) ah oo ku qor qiimaha goobta lambarka si aad u qeexdo qaddarkaas. Dooro^{(Choose Standard)} qaladka caadiga ah si aad u muujiso qaladka caadiga ah ee dhammaan dhibcaha xogta.

Ama, waxaad dooran kartaa Custom , oo ka dooro weecasho heerkaaga xisaabsan xaashidaada.

U dooro unugga leh xisaabinta weecasho ee caadiga ah labadaba Qiimaha Qaladka Wanaagsan^{(Positive Error Value)} iyo Qiimaha Qaladka Xun^{(Negative Error Value)} . 

Tani waxay muujinaysaa qiimaha joogtada ah ee ka dhigan weecinta guud ee dhibcaha xogta. Tani waxay suurtogal noqon kartaa inay noqoto mid balaadhan (sida tusaalaha kore), markaa waxaa laga yaabaa inaad ku hagaajiso miisaanka dhidibka y ilaa dhamaadka hoose ee kala duwan si uusan u muujin hoos dhidibka x.

Habaynta Cilada Baararka gudaha Excel

Isticmaalka sifada Baararka Khaladaadka Gaarka^{(Custom Error Bars)} ah ayaa xitaa ka sii faa'iido badan haddii aad xisaabisay xadka khaladka ee xaashidaada. Tani waa sababta oo ah baararka qaladku waxay soo bandhigi doonaan kala duwanaanta qiyamka kor ku xusan iyo ka hooseeya dhibic kasta oo xog ah oo ku jirta jaantuska taas oo ka dhigan inta uu le'eg yahay halka khaladku ku jiro meel kasta oo garaafka xariiqda ah.

Ikhtiyaarada kale ee cilada caadada ah ee kuu ogolaanaya inaad hagaajiso sida baararkani u muujiyaan:

• Jiho^(Direction) : Muuji xariiqda qaladka mid ka sarreeya oo keliya (Plus), kaliya ka hooseeya ( Minus ), ama kor iyo hoos (Labadaba).
• Qaabka Dhamaadka^{(End Style)} : Dooro Cap haddii aad rabto xariiq toosan oo yar oo ku taal cidhif kasta oo ka mid ah bar qaladka, ama dooro Cap No Cap^{(No Cap)} haddii aad rabto kaliya xariiqda toosan.

Haddii aad dooratid summada rinjiga ama calaamadda shan geesoodka, waxaad arki doontaa siyaabo kale oo badan oo aad u habeyn karto sida baararka qaladku ay ugu muuqdaan Excel .

Kuwaas waxaa ka mid ah bedelida xariiqda bar qaladka nooca iyo midabka, daahfurnaanta iyo ballaca, iyo wax ka badan. Dadka badankiis waxay uga tagaan goobahan sidii hore, laakiin ogow inay diyaar yihiin haddii aad rabto inaad hagaajiso sida baararka khaladkaagu u muujinayaan jaantuskaaga.

Ma tahay inaad ku darto Baararka Cilad ee Excel?

Caadiyan, baararka cilada lagama maarmaanka ah garaafyada ilaa aad samaynayso xisaabin xisaabeed oo aad u baahan tahay inaad muujiso cabbirka khaladka ee u jira jaantuska xogta muunad ee aad falanqaynayso.

Baararka khaladku dhab ahaantii aad bay muhiim u yihiin markaad isku dayayso inaad gudbiso isku xidhka ama gunaanadka adoo isticmaalaya xogta, si ay dhagaystayaashaadu u fahmaan sida ay xisaabtu u saxsan tahay.

How To Add Error Bars In Excel

When you create line charts in Excel, you’re plotting data points along an X and a Y axis. This is useful for trending data over time, but what if you also want to trend how far those data points are from their “ideal” or how much they vary over time?

Trending margin of error and standard deviation is the most common reason people use the error bar feature in Excel charts. When you add error bars in Excel, you can view a standard error or deviation for every marker in the chart.

However, you can use error bars for a variety of purposes. Basically, anytime you want to include high and low points alongside individual data points, error bars can help.

Error bars are available in Excel for area, bar, column, line, scatter, and bubble charts.

Margin of Error & Standard Deviation

Before you can learn how to add error bars in Excel, it’s important to understand what both margin of error and standard deviation are.

• Margin of error is the “uncertainty” of the data point. This is commonly used in statistics when the data is from a sample that makes up a larger population. The margin of error tells you how far the data from that sample could vary from the “real” result for the entire population. 

• Standard deviation is a component that’s used to calculate margin of error. The standard deviation is a measure of how spread out your data is. It tells you how much the data points are spread out around the overall average or mean of all data points.

You could calculate margin of error and standard deviation for yourself (Excel even provides standard deviation functions). Or, you can add error bars in Excel and let Excel do the calculations for you.

How To Add Error Bars In Excel

To add error bars in Excel, you need to start with an existing graph you’ve already created. 

1. To get started, click on the chart and then select the Chart Elements button (the + symbol) at the upper right corner of the chart.

2. Check the Error Bars box to enable error bars in your graph. Then, select the arrow to the right of the Error Bars selection.

3. The pop-up box you see provides you with several options to configure the error amount that the error bars will display in the chart.

Before you can select one of the preconfigured options, it’s important to understand what each option means and how it works.

Error Bar Options In Excel

You can choose from three pre configured error bar options in Excel. 

• Standard Error: Displays the standard error for each data point
• Percentage: Excel calculates and displays the specific error percentage for each data point
• Standard Deviation: Excel calculates and displays the standard deviation (one value) for all values

The actual calculation for standard deviation is somewhat complex and beyond the scope of this article. 

If you want to calculate the standard deviation yourself and display that value instead you can do that.

In the error bar dropdown box, select More Options at the bottom of the list. This will open the Error Bar Options window. Select the graph icon at the top to switch to the Vertical Error Bar options.

Under Error Amount, you can select Fixed value, Percentage, or Standard deviation(s) and type a value into the number field to specify those amounts. Choose Standard error to display just the standard error for all data points.

Or, you can select Custom, and choose your calculated standard deviation from your spreadsheet.

Select the cell with the standard deviation calculation for both the Positive Error Value and the Negative Error Value. 

This displays the constant value that represents the overall deviation of data points. This could potentially be a wide range (like in the example above), so you might have to adjust the y-axis scale to the lower end of the range so it doesn’t display below the x-axis.

Customizing Error Bars In Excel

Using the Custom Error Bars feature is even more useful if you’ve calculated the margin of error in your spreadsheet. This is because the error bars will then display the range of values above and below each data point in the chart that represent the range of where the error lies at every point in the line graph.

Other custom error bar options that let you fine-tune how these bars display:

• Direction: Display the error line either only above (Plus), only below (Minus), or above and below (Both).
• End Style: Choose Cap if you want a small horizontal line at each end of the error bar, or choose No Cap if you only want the vertical line.

If you select the paint icon or the pentagon icon, you’ll see many other ways you can customize how error bars look in Excel.

These include changing the error bar line type and color, transparency and width, and much more. Most people leave these settings as default, but know that they’re available if you want to fine tune how your error bars display in your chart.

Should You Add Error Bars In Excel?

Usually, error bars aren’t necessary on graphs unless you’re performing statistical calculations and need to show the error size that exists for the sample data set you’re analyzing.

Error bars are actually very important when you’re trying to convey correlations or conclusions using data, so that your audience understands how accurate those calculations are.

Related posts

• Kudar Khadka Dib-u-Celinta Toosan ee Qorshaha Kala firdhisan ee Excel

• Sida loo sameeyo Histogram gudaha Excel

• Sida loo xafido erayga sirta ah ee Excel File

• Sida Loo Sameeyo Jadwalka socodka gudaha Word iyo Excel

• Sida Loo Sameeyo Calaamadaha Erayga laga bilaabo xaashida faafinta ee Excel

• Sida loo xisaabiyo kala duwanaanshaha Excel

• Sida loo kala saaro Magacyada Hore iyo Dambe ee Excel

• U isticmaal Excel Qalab ahaan si aad xogta uga koobbiso Shabakadda

• Sida loo abuuro Gantt Charts gudaha Microsoft Excel

• U qaabeeya Unugyada iyadoo la isticmaalayo Habaynta Shuruudaha ah ee Excel

• Sida Loo Sameeyo Liiska Hoos-u-dhaca ee Excel

• Sida loogu daro faallooyinka unugga Xaashida shaqada ee Excel

• Sida loo isticmaalo VLOOKUP gudaha Excel

• Sida Loogu Beddelayo Inta u dhaxaysa Waraaqaha Shaqada ee Excel

• Sida Loo Sameeyo Kaarka Salaan ee MS Word

• Sida Loo Isticmaalo Shaqada YEARFRAC gudaha Excel

• Jadwalka xogtaada Excel

• Sida loo saaro, loo jebiyo, ama loo jebiyo erayga sirta ah ee Excel XLS ee la iloobay

• Sida Taariikhaha Looga Jaro Excel

• Hagaha Dhammaan Kordhinta Faylka Excel & Waxa ay ula jeedaan