Jaantusyadu^(Charts) waxay fududeeyaan la shaqaynta xaashida Excel^{(Excel sheets)} . Si kastaba ha ahaatee, waxaa muhiim ah in la ogaado nooca jaantusku si fiican ugu shaqeeyo nooca xogta. Haddii aad la macaamilayso xogta ku lug leh falanqaynta isbarbardhigga ee qiyamka ku faafay 2 tiir oo kala duwan, isku day inaad isticmaashid  jaantuska xariiqda^{(Line Chart)} ama Sawirka firdhinta^{(Scatter Plot Graph)} . Habka lagu abuurayo jaantus xariiq ah iyo goob kala firdhisan gudaha Excel ayaa lagaga hadlay halkan.

Farqiga u dhexeeya Shaxda Khadka ah^{(Line Chart)} iyo Shirqoolkii firdhiyey^{(Scatter Plot)}

Haddii aad fahanto qeexida shaqada xisaabta, habka ugu wanaagsan ee lagu xukumi karo waa in xariiq kasta oo barbar socda dhidibka y-da oo isgoysyada qiyamka ku jira qalooca shaqada hal mar oo kaliya. Isla sidaas oo kale ayaa ah jaantusyada xariiqda. Qiimayaasha waxaa lagu sawiray dhidibka y oo dhidibka x-na waxaa loo isticmaalaa in lagu calaamadiyo horumarka.

Xaaladda goob kala firdhisan, dhib ma leh haddii aad si fudud u isticmaasho dhibcaha calaamadaynta ama xariiqyada, garaafku wuxuu ku faafaa dhidibka XY-ga.

Tusaale ahaan. Aynu tixgelinno tusaalahan mushaharka qofka sannadaha 2011 ilaa 2020. Sannadaha waxa lagu sheegay tiirka A ee ka bilaabmaya A3 ilaa A12 . Mushaharka qofka ee sannadaha kala duwan waxaa lagu sheegay unugyo u dhigma ee tiirka B laga bilaabo B3 ilaa B12 .

Sida loo sameeyo shaxda laynka ee Excel

Si loo abuuro jaantus xariiq ah gudaha Excel , nidaamku waa sida soo socota:

Dooro xogta labada tiir (laga bilaabo A3 ilaa B12 ).

Tag Insert > Line Chart .

Dooro jaantuska khadka ku habboon.

Beddel goobta iyo cabbirka jaantuska hadba baahidaada.

Sida loo abuuro Scatter Plot gudaha Excel

Habka loo abuuro goob kala firdhisan gudaha Excel waa sida soo socota:

Dooro xogta labada tiir (laga bilaabo A3 ilaa B12 ).

Tag Insert > Scatter Plot .

Dooro jaantuska ku habboon ee Scatter Plot .

Hagaajin cabbirka iyo goobta shaxda sida ku cad shuruudahaaga.

Waxaad ogaan doontaa in qalloocyada garaafyada xariiqa iyo jaantuska goob firdhinta ay kala duwan yihiin. Si kastaba ha ahaatee, jaantusyadani dabeecad ahaan waa kuwo taagan.

Waxa kale oo aad tixgelin kartaa abuurista jaantusyo firfircoon gudaha Excel^{(creating dynamic charts in Excel)} . Markaad tan sameyso, qalloocyada garaafka ayaa isbedeli doona sida iyo markaad beddesho qiimaha xogta.

How to create a Line Chart and Scatter Plot Graph in Excel

Charts make working with Excel sheets easier. However, it is important to know what kind of chart works better with what kind of data. If you are dealing with data involving comparative analysis of values spread across 2 different columns, try using the Line Chart or the Scatter Plot Graph. The procedure to create a line chart and scatter plot in Excel is discussed here.

Difference between Line Chart and Scatter Plot

If you understand the definition of a mathematical function, a good way to judge it is that any line drawn parallel to the y-axis intersects with the values in the function’s curve only once. The same is the case with line charts. The values are plotted across the y-axis and the x-axis is used to mark the progression.

In the case of a scatter plot, no matter whether you simply use it with the marking points or lines, the graph is spread across the XY-axis.

Eg. Let us consider this example of a person’s salary across the years 2011 to 2020. The years are mentioned in column A starting from A3 till A12. The person’s salaries for the respective years are mentioned in the corresponding cells across column B from B3 till B12.

How to create a Line Chart in Excel

To create a line chart in Excel, the procedure is as follows:

Select the data across both the columns (from A3 to B12).

Go to Insert > Line Chart.

Select the appropriate line chart.

Change the location and size of the chart as per your needs.

How to create a Scatter Plot in Excel

The procedure to create a scatter plot in Excel is as follows:

Select the data across both the columns (from A3 to B12).

Go to Insert > Scatter Plot.

Select the appropriate Scatter Plot chart.

Adjust the size and location of the chart as per your requirements.

You would notice that the curves of the line graph and scatter plot chart are different. However, these charts are static in nature.

You could also consider creating dynamic charts in Excel. By doing this, the curves in the graph would change as and when you change the value of the data.

Related posts

• Sida loo abuuro Graph Bar ama Shaxda Saxiixa ee Excel

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

• Sida loo sameeyo garaafka fudud ama jaantuska gudaha Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

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

• Sida loo xidho booska jaantuska xaashida xaashida ee Excel

• Casharka Microsoft Excel, ee Bilowga ah

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

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo isticmaalo Find and FindB functional in Excel

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

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo isticmaalo shaqada Mode ee Excel