Goobta kala firdhisan (sidoo kale loo yaqaano garaaf goobeedka kala firdhisan) waa qalab faa'iido leh oo loogu talagalay falanqeeyayaasha xogta, ka caawinta in muuqaal ahaan loo baadho oo la falanqeeyo laba xog oo kala duwan. Tusaale ahaan, haddii aad is barbar dhigayso natiijooyinka iibka ee kooxo kala duwan oo iib ah, goob kala firdhisan ayaa kuu oggolaan doonta inaad aragto cidda ugu fiican (ama ugu xun) wax qabadka, sida shaxda xariiqda.

In kasta oo aad u isticmaali karto Excel si aad u samayso goob kala firdhiso^{(Excel to make a scatter plot)} , si kale oo aad u samayn karto waa inaad isticmaasho Google Sheets -ka xorta ah ee la heli karo si aad u samayso goob kala firdhiso. Maqaalkan, waxaan ku sharixi doonaa sida loo sameeyo xaashida qashinka ee Google Sheets , oo ay ku jiraan sida loo habeeyo marka la abuuro.

Sida Looga Sameeyo Shirqoolkii^{(Scatter Plot)} Kala firdhiyey ee Google -ka^(Google)

Meel firdhisan, sida magacaba ka muuqata, waxay isticmaashaa dhibco kala firdhisan ee shaxda si loo sawiro laba ama ka badan oo xogta ku xidhan. Tusaale ahaan, haddii aad rabto inaad is barbar dhigto iibka iyo faa'iidada kooxda iibka, garaaf kala firidhsan (muujinaya faa'iidada iyo dakhliga iibka) ayaa noqon doona mid qumman, oo muujinaya faa'iidada iyo dakhliga qof kasta oo iibiya.

Ilaa iyo inta aad haysato laba qaybood oo xog is barbardhig ah, waa suurtogal in la abuuro goob kala firdhisan, Google Sheets -ka ayaa tan ku fududaynaysa qalabkeeda shaxanka. 

1. Si aad u abuurto goob kala firdhisan xaashida Google^{(Google Sheets)} , fur xaashida^{(open a spreadsheet)} oo dooro unugyada xogtada ku jira. Iyadoo xogta la doortay, ka dooro Insert > Chart ka menu-ka.

1. Tani waxay furi doontaa qalabka tafatiraha Chart^{(Chart editor )} ee dhinaca midigta. Xaashiyaha Google^{(Google Sheets)} ayaa si toos ah isku dayi doona inay go'aamiyaan nooca jaantuska ama garaafyada ay tahay inay ku isticmaalaan xogta la doortay. Haddii Google Sheets aysan si toos ah u dooran goob kala firdhiso, ka dooro shaxda^{(Chart type)} jaantuska liiska hoos-u-hoosaadka ah, ee ku hoos qoran Setup tab. Haddii aadan hubin waxa jaantus kastaa yahay, dul bood si aad magaca u taxdo.

1. Tafatiraha jaantusku wuxuu isticmaali doonaa unugyada la xushay si uu u sameeyo tirada xogta ee jaantuska sawirka. Haddii aad rabto inaad tan beddesho, taabo badhanka Xulashada xogta^{(Select data range )} (oo ku xigta sanduuqa kala duwanaanta xogta^{(Data range)} ). Haddii kale, ku qor kala duwanaanta unugga gacanta sanduuqa xadka xogta^{(Data range)} .

1. Shaxda la geliyo ayaa isla markaaba u cusboonaysiin doonta nooca jaantuska cusub. Sida caadiga ah, goob firdhiso waxay lahaan doontaa xogta dhidibka X-^{(X-axis data)} ku xidha labada nooc ee xogta (tusaale magacyada kooxda iibka). Taxanuhu wuxuu^{(series )} tusi doonaa labada nooc (ama ka badan) xogta aad rabto inaad is barbardhigto (tusaale faa'iidada iyo dakhliga). Si aad ugu darto taxane dheeri ah, dooro sanduuqa Taxanaha ku dar^{(Add Series)} oo dooro mid ka mid ah xogta dheeraadka ah.

1. Haddii aad u baahan tahay inaad ka saarto mid ka mid ah taxanaha, dooro hamburger menu icon , ka dibna dooro ikhtiyaarka saar^{(Remove )} .

1. Haddii aad rabto in Google Sheets ay isticmaasho safka sare si aad u abuurto cinwaano, dooro Isticmaal safka 1 sida^{(Use row 1 as headers)} sanduuqa hubinta. Si aad tiirka ugu horreeya u isticmaasho calaamad ahaan (oo lagu garab taagan yahay dhidibka X^(X-axis) ), dooro Isticmaalka tiirka A sida calaamadaynta^{(Use column A as labels)} sanduuqa. Waxa kale oo aad bedeli kartaa safafka iyo tiirarka adiga oo dooranaya sanduuqa Switch rows/columns .

Habaynta Shirqoolkii kala firdhiyey

Sida dhammaan jaantusyada iyo garaafyada ku jira Google Sheets , tifaftiraha jaantusku wuxuu bixiyaa tiro ikhtiyaari ah oo dheeraad ah oo is-beddelid. Tani waxay kuu ogolaanaysaa inaad bedesho sumadaha, ciwaanka dhidibka, midabada, xarfaha, iyo in ka badan.

1. Si aad u habayso goob kala firdhisan, hubi in guddiga tifaftiraha shaxda^{(chart editor)} ee dhinaca midigta ah uu muuqdo. Haddii aysan ahayn, dooro jaantuska, ka dibna dooro astaanta hamburgerka^{(hamburger menu icon)} ee dhanka sare ee midig. Laga soo bilaabo menu, ka dooro Edit shaxda^{(Edit the chart)} ikhtiyaarka ah.

1. In the Customize tab ee liiska tifaftiraha shaxda^{(Chart editor)} , waxaad bilaabi kartaa inaad wax ka badasho shaxdaada. Si aad u bedesho midabada jaantuska iyo xarfaha, dooro qaybta qaabka shaxda^{(Chart style)} oo dooro mid ka mid ah xulashooyinka (tusaale midabka asalka^{(background colour)} ) si aad isbedel u samayso. Isbeddel kasta oo aad sameyso waxay si toos ah u soo muuqan doonaan.

1. Hoosta cinwaannada jaantuska iyo dhidibka^{(Chart and axis titles)} , waxaad bedeli kartaa ciwaannada la soo bandhigay ee jaantuska iyo faashashka jaantuska. Ka dooro liiska cinwaan ee liiska hoos-u-hoosaadka ee Jaantuska , dabadeed geli qoraalka aad rabto inaad isticmaasho sanduuqa ^{(Chart title)}qoraalka Cinwaanka^{(Title text)} . Waxaad markaa u qaabayn kartaa qoraalka (oo ay ku jiraan font, qaabaynta, iyo midabka) ikhtiyaarrada ka hooseeya sanduuqa.

1. Sida caadiga ah, dhibcooyinka xogta ee xaashida Google-ka ee xaashida^{(Google Sheets)} kala firdhisa waxa loo soo bandhigay sidii goobo^(circles) . Si aad u isticmaasho qaab ka duwan (tusaale, saddexagalka ama calaamadaha X), dooro qaybta Taxanaha^(Series) , ka dibna qaab cusub ka dooro liiska hoos-u-dhaca qaabka Point . ^{(Point shape)}Waxa kale oo aad ka dooran kartaa cabbirka dhibicda cusub ee liiska hoos-u-dhaca ee cabbirka^{(Point size)} .

1. Halyeygu wuxuu kuu ogolaanayaa inaad aqoonsato xogta dejisa dhibcaha goob kala firidhsan ay ka tirsan yihiin. Si aad u bedesho farta, qaabaynta, midabka, iyo booska halyeyga, dooro qaybta Halyeyga^(Legend) oo samee isbedel adoo isticmaalaya xulashooyinka la bixiyay.

1. Qaybaha dhidibada toosan iyo dhidibka ^{(Horizontal axis )}toosan^{(Vertical axis)} , waxaad bedeli kartaa sida calaamadaha dhidibadaha kala duwan loo qaabeeyey. Dooro^(Select) mid ka mid ah qaybaha, ka dibna isbeddel ku samee farta, cabbirka farta, qaabaynta, iyo midabka fursadaha la bixiyay. Haddii aad rabto in aad ka noqoto nidaamka dhidibka (bidix ilaa midig ama midig ilaa bidix), dooro sanduuqa dalbashada dhidibka^{(Reverse axis order)} gadaale.

1. Si aad gacan uga geysato in goobtaada kala firdhiso ay noqoto mid muuqata, waxaad ku dari kartaa xariijimaha iyo shilinta. Si tan loo sameeyo, dooro qaybta Gridlines iyo ticks^{(Gridlines and ticks )} , ka dibna ka dooro dhidibka Horizontal^{(Horizontal axis )} ama dhidibka taagan^{(Vertical axis )} liiska hoos-hoosaadka. Iyada oo xulashada dhidibka Horizontal^{(Horizontal axis )} la doortay, dooro sanduuqa hubinta ee ticks-yada waaweyn^{(Major ticks)} si aad awood ugu siiso shilinta dhidibada toosan, ka dibna ku samee isbedelo dheeraad ah goobaha (oo ay ku jiraan booska, dhererka, midabka, iyo dhumucda) hoostiisa.

1. Xulashada dhidibka toosan ee^{(Vertical axis)} lagu doortay Menu- ga Gridlines^{(Gridlines and ticks)} , waxaad awood u siin kartaa xadhkaha (labadaba waaweyn iyo kuwa yarba) iyo tikidhada dhidibka toosan. Dooro khadadka waaweyn, khadadka yar yar, ^{(Major gridlines, Minor gridlines,)} shilinta waaweyn^{(Major ticks)} ama shilinta yaryar sanduuqyada^{(Minor ticks )} hubinta si aad awood ugu yeelatid doorashooyinkan, ka dib isbeddel ku samee dejinta (ay ku jiraan midabka, booska, dhererka, dhumucda, iyo midabka) ee ka hooseeya.

Samee xaashida faafinta muuqaalka

Hadda waxaad taqaanaa sida loo sameeyo xaashida kala firdhisan ee Google^{(Google Sheets)} -ka , waxaad sidoo kale tijaabin kartaa abuurista garaafyada Google Sheets iyo jaantusyada falanqaynta xogta, laga bilaabo jaantuska jaantuska^{(line chart)} ilaa garaafka bar^{(bar graph)} . Haddii aad la halgamayso, waxa jira habab Google-ka Sheets oo^{(Google Sheets templates)} aad isticmaali karto si aad u bilowdo, kuwaas oo diyaar kuu ah inaad buuxiso xogta oo aad ku abuurto jaantusyo adiga kuu gaar ah oo ku wareegsan.

Isticmaalayaasha Excel ee khibradda leh waxay sidoo kale u rogi karaan xaashiyaha xaashida Google^{(convert spreadsheets to Google Sheets)} si fudud, in kasta oo astaamaha qaarkood (sida macros Excel^{(Excel macros)} ) aan la taageeri doonin. Waxaad wax ka sii qaadi kartaa adigoo isticmaalaya qoraalada Google Sheets^{(Google Sheets scripts)} si aad u balaariso shaqada oo aad ula dhex gasho xaashiyaha Google iyo adeegyada kale ee cid saddexaad.

How to Make a Scatter Plot in Google Sheets

A sсatter рlot (also known as a scаtter plot graph) is a useful tool for datа analyѕts, helping to visually explore and analyze two different data sets. For instаnce, if you’re comparing the sales results across different sаles teams, a scatter plot would allow you to see who was the beѕt (or worst) performing, much like a line chart would.

While you could use Excel to make a scatter plot, another way you can do it is to use the freely-available Google Sheets to make a scatter plot instead. In this article, we’ll explain how to make a scatter plot in Google Sheets, including how to customize it once it’s created.

How to Make a Scatter Plot in Google Sheets

A scatter plot, as the name suggests, uses scattered dots across a chart to visualize two or more types of linked data. For instance, if you wanted to compare the sales and profits of a sales team, a scatter graph (showing the profit vs the sales revenue) would be perfect, showing the profit and revenue for each salesperson.

As long as you have two comparable data sets, it’s possible to create a scatter plot, and Google Sheets makes this easy with its chart creation tool. 

1. To create a scatter plot in Google Sheets, open a spreadsheet and select the cells containing your data. With the data selected, select Insert > Chart from the menu.

1. This will open the Chart editor tool in the right-hand panel. Google Sheets will automatically attempt to determine what type of chart or graph it should use with the selected data. If Google Sheets hasn’t selected a scatter plot automatically, select it from the Chart type drop-down menu, listed under the Setup tab. If you’re unsure what each chart is, hover over it to list the name.

1. The chart editor will use the selected cells to form the data range for the plot chart. If you want to change this, press the Select data range button (next to the Data range box). Alternatively, type the cell range into the Data range box manually.

1. The inserted chart will immediately update to the new chart type. By default, a scatter plot will have X-axis data that ties the two forms of data together (eg. the names of a sales team). The series will show the two (or more) forms of data that you want to compare (eg. profit and revenue). To add additional series, select the Add Series box and choose one of the additional data sets.

1. If you need to remove one of the series, select the hamburger menu icon, then select the Remove option.

1. If you want Google Sheets to use the top row to create header titles, select the Use row 1 as headers checkbox. To use the first column as labels (shown alongside the X-axis), select the Use column A as labels checkbox. You can also switch rows and columns by selecting the Switch rows/columns checkbox.

Customizing a Scatter Plot

Like all charts and graphs in Google Sheets, the chart editor offers a number of additional customization options. This allows you to change labels, axis titles, colors, fonts, and more.

1. To customize a scatter plot, make sure that the chart editor panel on the right-hand side is visible. If it isn’t, select the chart, then select the hamburger menu icon in the top-right. From the menu, select the Edit the chart option.

1. In the Customize tab of the Chart editor menu, you can begin to make changes to your chart. To change the chart colors and fonts, select the Chart style category and select one of the options (eg. background colour) to make changes. Any changes you make will appear automatically.

1. Under Chart and axis titles, you can change the displayed titles for the chart and chart axes. Select a title option from the Chart title drop-down menu, then insert the text you wish to use in the Title text box. You can then format the text (including font, formatting, and color) in the options below the box.

1. By default, data points on a Google Sheets scatter plot are displayed as circles. To use a different shape (for instance, triangles or X marks), select the Series category, then choose a new shape from the Point shape drop-down menu. You can also select a new point size from the Point size drop-down menu.

1. The legend allows you to identify what data sets the points on a scatter plot belong to. To change the font, formatting, color, and position of the legend, select the Legend category and make changes using the options provided.

1. In the Horizontal axis and Vertical axis categories, you can change how the different axis labels are formatted. Select either category, then make changes to the font, font size, formatting, and color from the options provided. If you want to reverse the axis order (from left to right or right to left), select the Reverse axis order checkbox.

1. To help make your scatter plot more visible, you can add gridlines and ticks. To do this, select the Gridlines and ticks category, then select either Horizontal axis or Vertical axis from the drop-down menu. With the Horizontal axis option selected, select the Major ticks checkbox to enable ticks on the horizontal axis, then make further changes to the settings (including position, length, color, and thickness) below it.

1. With the Vertical axis option selected in the Gridlines and ticks menu, you can enable gridlines (both major and minor) and ticks for the vertical axis. Select the Major gridlines, Minor gridlines, Major ticks or Minor ticks checkboxes to enable these options, then make changes to the settings (including color, position, length, thickness, and color) below it.

Create Visual Spreadsheets

Now you know how to make a scatter plot in Google Sheets, you can also experiment with creating other Google Sheets graphs and charts for data analysis, from a line chart to a bar graph. If you’re struggling, there are Google Sheets templates you can use to get started, ready for you to fill with data and create your own charts around it.

Experienced Excel users can also convert spreadsheets to Google Sheets with ease, although some features (like Excel macros) won’t be supported. You can take things even further, using Google Sheets scripts to expand functionality and integrate spreadsheets with other Google and third-party services.

Related posts

• Sida Loo Isticmaalo Liisaska Hoos U Dhaca Google Sheets

• 9 Qodob oo Qarsoon oo ku jira Khariidadaha Google waa inaad hubisaa

• Sida loo Shaandheeyo Google Sheets

• Waa maxay Google App-ka & Sida Loo Isticmaalo

• Sida Loo Geliyo Saxiixa Google Docs

• Sida loo Hagaajiyo Khaladaadka Shahaadada Amniga SSL ee Chrome

• Waa maxay cabbirka iyo cabbirka Google Analytics?

• Sida Loo Sameeyo Fariimaha Codka Google Voice

• Sida loo damiyo Raadinta Badbaadada ah ee Google

• Sida loo tirtiro Taariikhda YouTube iyo Hawsha Goobid

• 7-da ugu Fiican ee lagu daro Gmail

• Sida loogu daro qaababka Google Docs

• Google Hawshayda: Waa maxay sababta aad u daryeesho

• Sida loo Isticmaalo Hawlaha Google-ka-Bilowga Hagaha

• Sidee buu u shaqeeyaa Algorithm-ka YouTube?

• 3 siyood oo loo sameeyo xuduudaha Google Docs

• Sida loogu soo diro iimaylo khaas ah Gmail

• Sida loo galo Inbox Zero gudaha Gmail

• Sida uu u shaqeeyo Google Drive Launcher Application

• 8 Talooyin Raadinta Google: Had iyo jeer raadso waxaad raadineyso