Garaafyada barku^{(Bar graphs)} waa tusaalayaal garaaf ahaan xogta tirakoobka ee qaabka xariijinta ama baararka. Tani waxay u oggolaanaysaa daawadayaasha inay fahmaan farqiga u dhexeeya cabbirrada kala duwan ee xogta hal jaleec halkii ay ka tilmaami lahaayeen oo ay is barbar dhigi lahaayeen xog kasta. Haddii aad rabto inaad abuurto garaaf bar gudaha Excel , akhri maqaalkan.

^(Bar)Garaafyada Bar ee Excel waa qaab jaantusyo ah waana in si la mid ah loo geliyo. Garaafyada^(Bar) barku waxay noqon karaan 2-cabbir iyo 3-cabbir iyadoo ku xiran nooca tifaftiraha Excel ee aad isticmaasho.^(Excel)

Sida loo sameeyo Graph Bar gudaha Excel

Si aad u abuurto garaaf bar gudaha Excel:

1. Dooro xogta su'aasha ku jirta, oo tag tabka^{(Insert )} Gelida.
2. Hadda qaybta jaantusyada^{(Charts )} , dhagsii fallaadha hoos u fiiqaysa ee ku xigta ikhtiyaarka Bar Graph .
3. Dooro nooca garaafka bar aad rabto inaad isticmaasho. Isla markiiba waxay ku tusi doontaa xaashida Excel laakiin waxay u baahan kartaa dhowr ilbiriqsi si ay xogta ugu shubto.

Caadiyan, goobta iyo cabbirka jaantusku waa dhexda. Waxaad isku hagaajin kartaa labadan cabbir hadba baahidaada.

Tusaale ahaan. Aynu nidhaahno waxa nala siiyay xogta calaamadaynta ardayda fasalka. Xogta waxaa lagu sii fidiyay maadooyin kala duwan. Tani waxay ka dhigaysaa xogta mid adag sababtoo ah marka la barbardhigo ardayda dhexdooda, waa inaad si dhab ah u doorataa qiime kasta liiska, calaamadee safka iyo tiirka mid mid oo hubi ardaygu waxa dhaliyay maaddadee.

Markaa, dooro xogta inta u dhaxaysa A1 ilaa G7 oo tag Geli^{(Insert )} > Bar Graph .

Dooro garaafka bar ku habboon oo beddel goobta^(location) iyo cabbirka^(size) .

Mawduucyada waxaa lagu sheegay dhamaan dhidibka Y^(Y-axis) iyo boqolleyda dhidibada X.^(X-axis)

Magacyada ardayda ayaa lagu sheegay iyadoo la isticmaalayo midabyo.

Hadda waxaad si fudud u barbar dhigi kartaa ardayda adiga oo ku salaynaya buundooyinka ay ka heleen maado kasta.

Sida loo sameeyo jaantuska safafka ee Excel

Haddii kale, waxaad samayn kartaa jaantus tiir ah. Nidaamku wuxuu la mid yahay kan garaafyada sida hore loo sharraxay, si kastaba ha ahaatee, markan dooro Insert > Column ka dibna dooro nooca jaantuska.

Jaantuska tiirka ayaa faahfaahin ka dhigaya xitaa mid cad maadaama aad si fudud u barbar dhigi karto calaamadaha 2 arday adoo eegaya dhererka tiirarka. Garaafka tiirka ee tusaalaha kor ku xusan ayaa lagu muujiyay sawirka hoose.

Si kastaba ha ahaatee, waa in la ogaadaa in garaafkani uu yahay mid taagan. Waxaad sidoo kale dooran kartaa inaad ku abuurto jaantus firfircoon gudaha Excel^{(dynamic chart in Excel)} .

Rajo inay ku caawiso!

How to create a Bar Graph or Column Chart in Excel

Bar graphs are graphical representations of statistical data in the form of strips or bars. This allows viewers to understand the difference between the various parameters of the data at a single glance rather than pointing out and comparing each set of data. If you wish to create a bar graph in Excel, read through this article.

Bar graphs in Excel are a form of charts and are to be inserted in the same manner. Bar graphs could be both 2-dimensional and 3-dimensional depending upon the type of Excel editor you use.

How to create a Bar Graph in Excel

To create a bar graph in Excel:

1. Select the data in question, and go to the Insert tab.
2. Now in the Charts section, click on the downward-pointing arrow next to the Bar Graph option.
3. Select the type of bar graph you wish to use. It would immediately show on the Excel sheet but might need a few seconds to load the data.

Usually, the location and size of the chart are centered. You can adjust both these parameters according to your needs.

Eg. Let us say we are provided with a set of data of the marks by students in a class. The data is further extended across various subjects. This makes the data complex because to compare between the students, you would have to literally pick each value from the list, highlight the row and column one by one and check which student scored what in which subject.

So, select the data from range A1 to G7 and go to Insert > Bar Graph.

Select the appropriate bar graph and change the location and size.

The subjects have been mentioned across Y-axis and the percentages across X-axis.

The names of the students have been mentioned using colors.

Now you can easily compare students on the basis of their marks scored in each subject.

How to make a Column Chart in Excel

Alternatively, you could create a column chart. The procedure is similar to that for a bar graph as explained earlier, however, this time select Insert > Column and then choose the chart type.

A column chart makes details even clearer as you can simply compare the marks of 2 students by observing the respective heights of the columns. A column graph for the above-mentioned example has been shown in the image below.

However, it should be noted that this graph is static. You can also choose to create a dynamic chart in Excel.

Hope it helps!

Related posts

• Sida loo sameeyo jaantuska xariiqda iyo garaafka firdhiya ee sawirka gudaha Excel

• Sida loo sameeyo garaafka fudud ama jaantuska gudaha Excel

• Sida Loo Sameeyo Garaafka Bar gudaha Google-ka

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loo beddelo midabka jaantuska caadiga ah ee Word, Excel, PowerPoint

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo abuuro jaantus isku-dhafan gudaha Excel

• Isticmaal kiiboodhka si aad u bedesho dhererka safka iyo ballaca tiirka gudaha Excel

• Sida loo xidho booska jaantuska xaashida xaashida ee Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo abuuro shaxda Pivot iyo shaxda Pivot gudaha Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

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

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel