Garaafyada^(Bar) baarku aad ayay u caawin karaan marka ay timaado sawirida xogta. Waxay soo bandhigi karaan hal xog ama isbarbardhig xog uruurin badan. 

Maqaalkan, waxaan ku dul socon doonaa sida loo sameeyo noocyada kala duwan ee garaafyada bar ee Google Sheets .

Sida Loo Sameeyo Garaafka Bar^{(Bar Graph)} gudaha Google - ka

Waxaan ku bilaabi doonaa fudud, xaashi laba tiir ka kooban. Tiirka koowaad ee xaashidaada, ku dar summada saf kasta ee taxanahaaga ah. Haddii aad rabto, waxaad ku dari kartaa qayb unugga sare waxayna qaybtaas u muuqan doontaa sida ciwaanka garaafkaaga dhidibka jiifka ah. Calaamadaha ku hoos jira magaca qaybtaas waxay ka soo muuqan doonaan dhidibka toosan ee shaxdaaga.

Ku dar^(Add) ugu yaraan hal tiir oo xog ah. Geli calaamadda unugga koowaad ee tiirka labaad, oo ku dar xogta unugyada hoostiisa.

Marka xigta, raac tillaabooyinkan si aad u geliso garaafka bar si aad u matasho xogtaada.

1. Dooro^(Select) dhammaan unugyada xogta ku jira.
2. Ka menu-ka, ka dooro Geli^{(Insert )} > Shaxda^(Chart) ama dooro summada Gelida shaxda^{(Insert Chart)} .

Habka kasta oo aad doorato, Google ayaa geli doonta garaaf bar xaashidaada. ( Google waxay ugu yeertaa jaantuska tiirka^{(column chart)} . Tani waa isku mid.)

Samaynta Garaafka Bar leh Xogta Badan ee Google-ka^{(Making a Bar Graph with Multiple Data in Google Sheets)}

Si aad u samayso garaafka bar ay ku jiraan xogo badan, ku dar tiirar badan oo xog ah.

Raac tillaabooyinka kor ku xusan si aad u geliso sawirka garaaf ee xogtaada.

1. Dooro^(Select) dhammaan unugyada xogta ku jira.
2. Ka menu-ka, ka dooro Geli^{(Insert )} > Shaxda^(Chart) ama dooro summada Gelida shaxda^{(Insert Chart)} .

Halkan waxaa ah garaaf bar ah oo adeegsada tiirar badan oo xog ah xaashida sare.

Xaaladdan oo kale, Google waxay isticmaashaa qaybaha safka koowaad ee xogta sida cinwaanka jaantuska. 

Ku samaynta garaaf is dulsaaran oo ku jira Google Sheets^{(Making a Stacked Bar Graph in Google Sheets)}

Markaad isticmaasho qaybo badan oo xog ah, waxaad tusi kartaa xidhiidhada qayb-ilaa-dhan ee xogtaada adiga oo dooranaya waxa loo yaqaan jaantuska bararka^{(stacked bar chart)} . Tusaalahayaga sare, shaxda ayaa muujisay inta buug ee qof kastaa akhriyay bil gaar ah. Haddii aan u beddelno shaxanka bar ee jaantuska is dul-saaran, waxaan arki doonnaa inta buug ee qof kastaa akhriyay bishaas marka la barbar dhigo tirada guud ee buugaagta qof kastaa akhriyay bishaas. 

Waxaa jira dhowr dhadhan oo kala duwan oo ah jaantusyada bar is dulfuulan. Marka hore^(First) waxaan eegi doonaa jaantuska Bar istaandarka ah.^{(Standard stacked bar chart.)}

Kadib markaad geliso jaantuskaaga bar, laba-guji gudaha dhexdiisa, guddiga Tifaftiraha Chart^{(Chart Editor)} wuxuu u muuqan doonaa midig. 

Xusuusin^(Note) : Mar kasta waxaad bedeli kartaa cinwaanka jaantuska gudaha Tifaftiraha Jaantuska^{(Chart Editor)} ama adigoo laba jeer gujinaya cinwaanka jaantuska laftiisa.

Under Stacking , dooro Standard . 

Hadda waxaad arki doontaa qiyamka qayb kasta oo lagu soo ururiyay baarar keliya. 

Haddii kale, halkii aad ka heli lahayd Standard , waxaad dooran kartaa 100% si aad u sameyso jaantus jaantus ah oo muujinaya saamiga xogta shakhsi ahaaneed ee guud ahaan. Isticmaal tan marka wadarta guud aysan muhiim ahayn. 

Tusaale ahaan, tusaale ahaan, waxaa laga yaabaa inaan dan ka lahayn inta buug ee la wada akhriyey bishii - kaliya inta buug ee qof kastaa akhriyey marka loo eego dadka kale.

Ogaysii^(Notice) in 100% Shaxda Bar-taxan ee^{(Stacked Bar Chart)} sare, sumadaha ku teedsan dhidibka x ay hadda yihiin boqolleyda.

Sida Loo Beddelo Tiirarka & Safafka Shaxda^{(How to Swap Columns & Rows in a Chart)}

Isticmaalka tusaalaheenna, aan nidhaahno waxaad doonaysaa inaad si fudud u sawirto sida qof kasta caadooyinka wax-akhriskiisu isu beddelayo bil ilaa bisha. Xaashiyaha ^(Sheets)Google ayaa fududaynaya in tiirarkaaga loo rogo saf iyo caksi. 

1. Laba-guji jaantuska ama garaafka.
2. Ka dooro Setup dhanka midig.
3. Calaamadee sanduuqa ku xiga Switch rows/columns .

Garaafkeena caadiga ah hadda wuxuu u eg yahay sidan:

Haddii aan ka beddelno safafka iyo tiirarka jaantuska bar-xannuunsan, waxay u ekaan doontaa sidan:

Waxaad arki kartaa in mid kasta oo ka mid ah xulashooyinkan kala duwan ay ku habboon yihiin in laga sheekeeyo sheeko gaar ah oo ku saabsan xogtayada. Ka fakar sheekada aad^(you) rabto inaad sheegto, oo go'aami nooca garaafyada bar ee sida cad u dhigaya qodobkaaga.

Ku habeynta garaafyada Bar ee xaashiyaha Google^{(Customizing Bar Graphs in Google Sheets)}

Waxaa laga yaabaa inaad ku aragtay tafatirka jaantuska ee Customize tab.

Dooro tabkaas si aad u bedesho muuqaalka iyo dareenka shaxdaaga. Marka xigta waxaan mari doonaa qayb kasta oo ka mid ah tab Customize .

Habka^{(Chart style)} jaantusku wuxuu kuu ogolaanayaa inaad doorato midabka asalka, midabka xadka, iyo farta shaxdaaga. Haddii aadan jeclayn isbeddellada aad samaysay, waxaad had iyo jeer dooran kartaa badhanka qaabaynta Dib-^{(Reset layout)} u- dejinta si aad u bilowdo. 

Saxitaanka sanduuqa Maximize^(Maximize) waxay hoos u dhigi doontaa booska cad ee shaxdaaga. Isku day oo arag haddii aad jeceshahay waxa aad aragto.

Doorashada sanduuqa 3D waxay baararkaaga ka dhigi doontaa saddex-cabbir, sidan oo kale:

Habka isbarbardhigga^{(Compare mode)} ayaa iftiimin doona xogta la midka ah marka aad dulmarto jiirkaaga walxaha kala duwan ee jaantuskaaga. Jaantuska hoose, ka fiirso sida xogta Noofembar^(November) (qaybta ugu sareysa ee bar kasta oo la dulsaaray) loo iftiimiyay.

Qaybta cinwaannada jaantuska & dhidibada^{(Chart & axis titles)} waa meel kale oo aad ka beddeli karto cinwaanka jaantuska iyo sidoo kale fartiisa, cabbirka xarfaha, qaabka ( farta, geesiga ah, iwm.), iyo midabka qoraalka.

Qaybta Taxanaha^(Series) , waxaad bedeli kartaa muuqaalka calaamadahaaga taxanaha ah. Xaaladeena, taasi waa bilaha iyo qaybaha u dhigma ee garaafka bar. Tusaale ahaan, waxaad ka beddeli kartaa xogta Noofembar^(November) jaalaha ilaa cawl. 

Waxa kale oo aad qaabayn kartaa xog gaar ah sida, tusaale ahaan, xogta matalaysa tirada buugaagta Lisa akhriday Oktoobar^(October) . Riix^(Click) badhanka ku dar^(Add) ee ku xiga Format data point , halkaasna waxaad ka bedeli kartaa midabka barta xogta hal.

Qaybta Halyeyga^(Legend) , waxaad ku beddeli kartaa farta halyeeyga, cabbirka xarfaha, qaabka, iyo midabka qoraalka.

Dhinacyada dhidibka ^{(Horizontal axis)}tooska ah iyo dhidibka toosan^{(Vertical axis)} ayaa bixiya ikhtiyaaro isku mid ah oo loogu talagalay qaabaynta sumadaha mid kasta oo ka mid ah faasaskaaga jaantuska.

Ugu dambeyntii, Khadadka Gridlines iyo shilinada^{(Gridlines and ticks)} waa sifo cusub oo cusub (laga bilaabo Juun 2020^{(June 2020)} ) taasoo kuu ogolaaneysa inaad xoogga saarto qaybo ka mid ah faasaskaaga adigoo gelinaya calaamado sax ah, qaabeynaya, oo dejinaya farqiga u dhexeeya.

Xaashiyaha Google-ka waxa ay fududeeyaan garaafyada Bar

Hadda waxaad ogtahay in ku dhawaad ​​​​dhammaan ay jiraan inaad ka ogaato samaynta garaafyada bar ee Google Sheets . Haddii aad jeclaan lahayd inaad barato siyaabo badan oo loo isticmaalo Google Sheets , ka akhriso 5ta hawlood ee qoraalka Google Sheets ee aad u baahan tahay inaad ogaato^{(5 Google Sheets Script Functions You Need to Know)(5 Google Sheets Script Functions You Need to Know)} .

How to Make a Bar Graph in Google Sheets

Bar graphs can be еxtremely helpful when it сomes to visualizing data. They can displаy one ѕet of data or compare multiple data sets. 

In this article, we’ll go over how to make various types of bar graphs in Google Sheets.

How to Create a Bar Graph in Google Sheets

We’ll start with a simple, two-column spreadsheet. In the first column of your spreadsheet, add a label for each row in your series. If you like, you can add a category in the top cell and that category will appear as the title of your graph’s horizontal y-axis. The labels under that category name will appear along the horizontal axis of your chart.

Add at least one column of data. Enter a label in the first cell of the second column, and add the data in the cells beneath it.

Next, follow these steps to insert a bar graph to represent your data.

1. Select all the cells that have data in them.
2. From the menu, select Insert > Chart or select the Insert Chart icon.

Whichever method you choose, Google will insert a bar graph into your sheet. (Google calls it a column chart. This is the same thing.)

Making a Bar Graph with Multiple Data in Google Sheets

To make a bar graph that includes multiple sets of data, just add more columns of data.

Follow the same steps as above to insert a bar graph representation of your data.

1. Select all the cells that have data in them.
2. From the menu, select Insert > Chart or select the Insert Chart icon.

Here’s a bar graph that uses multiple columns of data from the spreadsheet above.

In this case, Google uses the categories in the first row of data as the chart title. 

Making a Stacked Bar Graph in Google Sheets

When you use multiple data sets, you can show the part-to-whole relationships in your data by opting for what’s called a stacked bar chart. In our example above, the chart showed how many books each person read in a particular month. If we switch the bar graph to a stacked bar chart, we’ll see how many books each person read that month compared to the total number of books everyone read that month. 

There are a couple different flavors of stacked bar charts. First we’ll look at the Standard stacked bar chart.

After you’ve inserted your bar chart, double-click inside it and the Chart Editor panel will appear to the right. 

Note: You can always change the chart’s title inside the Chart Editor or by double-clicking on the chart title itself.

Under Stacking, choose Standard. 

Now you’ll see the values of each category stacked into single bars. 

Alternatively, instead of Standard, you can choose 100% to make a stacked bar chart that depicts the ratio of individual data to the whole. Use this when the cumulative total isn’t important. 

So for our example, we might not care how many books were read in total each month—only how many books each person read relative to other people.

Notice that in the 100% Stacked Bar Chart above, the labels along the x axis are now percentages.

How to Swap Columns & Rows in a Chart

Using our example, let’s say you want to make it easy to visualize how each person’s reading habits changed from month to month. Google Sheets makes it easy to turn your columns into rows and vice versa. 

1. Double-click the chart or graph.
2. Select Setup on the right.
3. Check the box next to Switch rows/columns.

Our regular bar graph now looks like this:

If we switch rows and columns on our stacked bar chart, it will look like this:

You can see that each of these different options is ideal for telling a particular story about our data. Think about what story you want to tell, and determine which kind of bar graph most clearly makes your point.

Customizing Bar Graphs in Google Sheets

You may have noticed the Customize tab in the Chart Editor.

Select that tab to change the look and feel of your chart. Next we’ll go through each section of the Customize tab.

Chart style allows you to choose the background color, border color, and font for your chart. If you don’t like the changes you made, you can always select the Reset layout button to start over. 

Checking the Maximize box will decrease the white space in your chart. Try it and see if you like what you see.

Selecting the 3D box will make your bars three-dimensional, like this:

Compare mode will highlight comparable data when you hover your mouse over different elements of your chart. In the chart below, notice how the November data (the top-most section of each stacked bar) is highlighted.

The Chart & axis titles section is another place you can change the chart title as well as its font, font size, format (italics, bold, etc.), and text color.

In the Series section, you can change the appearance of your series labels. In our case, that’s the months and their corresponding parts of the bar graph. For example, you could change the November data from yellow to gray. 

You can also format a specific data point like, for example, the data representing the number of books Lisa read in October. Click the Add button next to Format data point, and from there you can change the color of that single data point.

In the Legend section, you can change the legend font, font size, format, and text color.

The Horizontal axis and Vertical axis sections offer similar options for formatting labels on each of your chart’s axes.

Finally, Gridlines and ticks is a relatively new feature (as of June 2020) allowing you to emphasize parts of your axes by inserting tick marks, formatting them, and setting the spacing between them.

Google Sheets Makes Bar Graphs Easy

Now you know almost all there is to know about making a bar graph in Google Sheets. If you’d like to learn more ways to use Google Sheets, read about the 5 Google Sheets Script Functions You Need to Know.

Related posts

• Google Search Bar Widget ma maqan yahay? Sida loo Soo Celiyo on Android

• Sida Loo Sameeyo Garaafka Khadka Google-ka

• 2 Xirmooyinka Ciwaanka Ciwaanka ee Chrome ka si loo abuuro Dhacdooyinka Kalandarka Google

• Sida Loo Isticmaalo Liisaska Hoos U Dhaca Google Sheets

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

• Sida Looga Sheegto Meherad Google-ka

• Sida loo hagaajiyo Gmail-ka marka aanu helin iimaylada

• Sida Loo Geliyo Saxiixa Google Docs

• Sida loo Beddelo Koontada Google-ka ee Default

• Sida Loo Isticmaalo Kalandarka Qoyska Google si aad qoyskaaga ugu ilaaliso wakhtiga

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

• Sida loogu Isticmaalo SUMIF gudaha Google Sheets

• Sida loo Kaydiyo Taariikhda Google Chrome

• Sida Loo Sameeyo Foom Google: Hage Dhamaystiran

• Waa maxay ilaalinta la xoojiyey ee Google Chrome ka iyo sida loo suurtogeliyo

• Waa maxay Google App-ka & Sida Loo Isticmaalo

• 7-da ugu Fiican ee lagu daro Gmail

• Waa maxay sababta Chrome uu u leeyahay habab badan oo socda?

• Sidee buu u shaqeeyaa Algorithm-ka YouTube?

• Sida uu u shaqeeyo Google Drive Launcher Application