Shaxda iyo garaafyada^{(Charts and Graphs)} waa qalab waxtar leh oo loo isticmaalo gudbinta macluumaadka macaamiisha. Xogta isku dhafan ee tirooyinka inta badan waxaa lagu soo bandhigaa qaab garaaf ah si ay si fudud u fahmaan oo loo xasuusto. Tusidda garaafka ee xogta waxa ay caawisaa in ay si degdeg ah u soo bandhigto macluumaadka iyo isbeddelkeeda soo koraya ee muddo wakhti ah.

Sawirada muuqaalka ah sida jaantusyada iyo garaafyada sidoo kale waxay gacan ka geystaan ​​muujinta xaqiiqooyinka muhiimka ah ee si fudud loo xasuusan karo lana fahmi karo. Jaantusyada waxaa inta badan loo adeegsadaa ganacsiga iyo hawl maalmeedka taasoo kuu oggolaanaysa inaad si fudud u aragto isbeddellada iyo isbarbardhigga qaab muuqaal ah. Haddii aad rabto inaad soo bandhigto bandhig si aad u qaabayso warbixin, jaantusyadu waxay door muhiim ah ka qaataan muuqaalka falanqaynta xogta adag ee dhagaystayaashaada.

Maalmahan, Google Sheets waxaa loo arkaa beddelka macquulka ah ee Excel si ay online uga helaan qalab kasta. Sida Excel , Google Sheets waxaa ku jira sifooyin kala duwan si loo toosiyo hawlaha loona kordhiyo wax soo saarka. Codsigan shabakada ku salaysan wuxuu kuu ogolaanayaa inaad abuurto jaantusyo la mid ah xaashida faafinta kale si aad ugu gudbiso xaqiiqooyinka dhagaystayaasha. Waxa ay ka kooban tahay garaafyo iyo jaantusyo kala duwan oo aad si bilaash ah u dooran karto si aad xogta ugu gudbiso hab muuqaal ah.

Maqaalkan, waxaan ku sharaxaynaa sida si toos ah loogu soo saaro jaantusyada Google Sheets .

Ku samee jaantusyada xaashida Google-ka

Bilaw Google Sheets oo samee xaashi cusub ama fur xaashi jira.

Ku buuxi^(Fill) xaashida xogta unugyada oo ku habbee xaqiiqooyinka tirada leh madax tiir.

U gudub Gelida oo^(Insert) dooro jaantuska ikhtiyaarka ah ee^{( Chart)} liiska hoos-u-hoosaadka ah. Daaqada tifaftiraha shaxda ayaa soo baxaysa

Guji ikhtiyaarka dejinta^(Setup) ee daaqada tifaftiraha shaxda.

Goobta nooca Chart^{(Chart type)} , ka dooro nooca jaantuska aad rabto inaad ka abuurto liiska hoos u dhaca. Xaashiyaha Google^{(Google Sheets)} waxa ay ku siinayaa 30 jaantus oo kala duwan oo aad dooran karto inaad u samayso xogtaada.

Goobta kala duwan ee xogta^{(Data range)} , dooro tirada unugyada aad rabto in lagu soo bandhigo miiska dushiisa. Waxaad dooran kartaa inaad gacanta ku geliso xadka ama isticmaal tilmaanta si aad u doorato tirada xogta.

Marka xadka xogta la geliyo, dhagsii OK.

Xaashida Google^{(Google Sheet)} ayaa hadda abuuri doonta oo soo bandhigi doonta jaantus ay ku jiraan dhammaan xogta laga soo xulay tirada unugyada xaashida.

Hadda haddii aad wax ka bedesho xogta xaashida, jaantuska si toos ah ayaa loogu cusboonaysiin doonaa natiijooyinka cusub iyada oo aan loo baahnayn in la abuuro jaantus cusub qiimaha la cusboonaysiiyay.

Waxaad sidoo kale si fudud ugu beddeli kartaa nooca jaantuska isla xogta Google Sheets .

Si aad u bedesho nooca jaantuska, laba jeer guji shaxda. Tani waxay furi doontaa liiska Tifaftiraha Shaxda^{(Chart Editor)}

Tag Setup oo goobta nooca Chart^{(Chart type)} dooro nooc cusub oo ka mid ah liiska hoos u dhaca.

Guji OK , oo xaashida Google-^{(Google Sheet)} ku waxay u beddeli doontaa jaantuska qaab shax cusub oo xogtaada ah.

Ku beddel jaantusyada Google Sheets

Intaa waxaa dheer, Google Sheets waxay kuu oggolaaneysaa inaad si buuxda u habayn karto jaantusyadaada iyadoo lagu saleynayo xogta. Ikhtiyaarada habaynta ayaa kuu oggolaanaya inaad habayso taxanaha jaantuska, qaabka, midabka asalka, calaamadaha dhidibka, halyeeyga, iyo in ka badan.

Si aad u habayn karto jaantuska, laba jeer guji shaxda oo dooro Customize tab ee daaqada tifaftiraha shaxanka.

Daaqaddu waxay soo bandhigaysaa xulashooyin ay ka mid yihiin qaabka jaantuska, cinwaannada dhidibka, taxanaha, calaamadaha dhidibka, khadadka^{(Chart style, axis titles, series, axis labels, gridlines)} , iyo qaar kale oo badan kuwaas oo aad dooran karto iyadoo ku saleysan nooca jaantuska aad rabto inaad abuurto.

Guji^(Click) ikhtiyaar kasta oo aad rabto inaad habayso oo aad ku dhaqanto isbeddellada.

Dhammaan hagaajinta aad ku samayso xogta iyo tifaftiraha jaantusyada si toos ah ayaa loo cusboonaysiiyaa iyada oo aan lagu celin habka oo dhan. Isbeddellada ayaa ka muuqda adiga oo aan xitaa dib u cusbooneysiin bogga.

Rajo in tani ay ku caawiso.^{(Hope this helps.)}

How to automatically generate Charts and Graphs in Google Sheets

Charts and Graphs are a useful tool used for conveying information to clients. Complex numerical data are often presented in the graphical form so that they can be easily understood and remembered. The Graphical representation of data helps to present the information and its developing trends over a period of time in a quick way.

Visual images like charts and graphs also help to highlight the important facts which can be easily remembered and understood. Charts are most often used in business and for daily assignments allowing you to easily see trends and comparisons in a visually appealing way. Whether you want to deliver a presentation to frame a report, charts take an important role in visualizing a complex data analysis to your audience.

Nowadays, Google Sheets is considered a viable alternative to Excel for its online accessibility from any device. Like Excel, Google Sheets includes various features to automate tasks and increase productivity. This web-based application lets you generate charts like any other spreadsheet to convey facts to the audience. It features a wide range of graphs and charts which you can choose for free to convey data in a visually appealing way.

In this article, we explain how to automatically generate charts in Google Sheets.

Generate Charts in Google Sheets

Launch Google Sheets and create a new spreadsheet or open an existing sheet.

Fill the sheets with data into the cells and organize the numerical facts with a column header.

Navigate to Insert and select the option Chart from the drop-down menu. A chart editor window pops up.

Click the option Setup in the chart editor window.

In the Chart type field, select the type of chart you want to create from the drop-down menu. Google Sheets provides 30 variety of charts that you can choose to create for your data.

In the Data range field, select the range of cells that you want to be displayed on the table. You can either choose to manually enter the range or use the pointer to select the data range.

Once the data range is entered, click OK.

Google Sheet will now create and display a chart with all the data selected from the range of cells in the sheet.

Now if you make any changes to the data in the sheets, the chart will be automatically updated with the new results without having to create a new chart for the updated value.

You can also change the type of chart for the same data easily in Google Sheets.

To change the chart type, double click on the chart. This will open a Chart Editor menu.

Go to Setup and in the Chart type field select a new type from the drop-down menu.

Click OK, and the Google Sheet will transform the chart into a new chart style for your data.

Customize charts in Google Sheets

Additionally, Google Sheets allow you to fully customize your charts based on the data. The customizing options allow you to configure the chart series, style, background color, axis labels, legend, and more.

To customize the chart, double click on the chart and select the Customize tab in the chart editor window.

The window displays options like Chart style, axis titles, series, axis labels, gridlines, and many more which you can choose based on the type of chart you want to create.

Click on any options which you want to configure and apply the changes.

All the adjustments you make in data and charts editor are automatically updated without having to repeat the entire process. The changes are reflected without you having to even refresh the page.

Hope this helps.

Related posts

• Sida qoraalka loogu beddelo abka shabakadda Google Sheets

• Sida loo sameeyo Koofida Dhibcaha ee Google Docs dhowr daqiiqo gudahood

• Hagaaji Google Docs Spellcheck oo aan si sax ah u shaqayn

• Sida loo geliyo sanduuqa qoraalka gudaha Google Docs

• Sida loo sameeyo Google Slides loop iyada oo aan la daabicin

• Wax-ku-darka Google Docs-ka ugu fiican ee qorayaasha madax-bannaan

• Sida loo geliyo Shaxda Tusmada Google Docs

• Sida loogu daro Caption Sawirada Google Docs

• Sida loogu daro oo wax looga beddelo Shaxda Google Docs ee habka ugu fudud

• Khariidadaha Kiiboodhka Google Docs ee Windows 11/10 PC

• Sida loo abuuro Indent Hang ee Microsoft Word iyo Google Docs

• Sida loo isticmaalo Madaxa, Footer, iyo Footnote gudaha Google Docs

• Sida loo geliyo WordArt xaashida Google-ka iyadoo la isticmaalayo Google Drawings

• Sida Loo Sameeyo Shaxda Org ee Google Docs

• Sida loogu daro tixraacyada iyo tixraacyada Google Docs

• Sida loo abuuro oo wax looga beddelo liiska hoos-u-dhaca ee Google Sheets

• Sida loo qoro Screenplay gudaha Google Docs

• Sida Loo Isticmaalo Qaabka Bilaashka Ah ee Kala-reebista ee Google Docs iyo Google Slides

• Sida loo isticmaalo IF iyo Nsted IF shaqooyinka Google Sheets

• Sida loogu xidho Google Sheets iyo Excel