Ku darista garaafka xaashida balaadhinta wax weyn maaha ilaa inta aad ogtahay habka. Si kastaba ha ahaatee, ma ogtahay in aad samayn karto garaaf xariiq qalloocan gudaha Excel ama Google Sheets^{(make a curved line graph in Excel or Google Sheets)} ? Hadday maya tahay, waa inaad hubisaa casharkan si aad cidhifyada fiiqan ugu rogaan khadad siman.

Mararka qaarkood waxaa laga yaabaa inaad u baahato inaad garaaf geliso xaashida faafinta si aad u muujiso xogta si qurux badan. Garaafka ama jaantusku wuxuu ka dhigaa xaashida mid wax soo saar leh oo si soo jiidasho leh u sawirta xogta. Way sahlan tahay in la abuuro oo lagu daro garaaf^{(create and add a graph)} - haddii aad isticmaalayso Microsoft Excel ama Google Sheets . Dhibaatada garaafka caadiga ah waa geesaha fiiqan. Inkasta oo ay qeexayso kor u kaca iyo hoos u dhaca xogtaada, dadka qaarkiis ma jecla. Haddii aad ka mid tahay iyaga, waxaad simi kartaa cidhifyada adiga oo raacaya hagahan. Macluumaadkaaga, waxaad u rogi kartaa geesaha fiiqan ee garaafka ee jira gees siman iyo sidoo kale waxaad ku dari kartaa garaaf qalloocan oo cusub. Si kastaba ha noqotee, uma baahnid wax ku-darka dhinac saddexaad.

Sida loo sameeyo garaaf xariiq qaloocan gudaha Excel

Si aad u samayso garaaf xariiq toosan oo qaloocan gudaha Excel , raac talaabooyinkan-

1. Geli xogtaada xaashida faafinta oo dooro si aad garaaf u samayso.
2. Tag Gelida tab oo geli^(Insert) garaaf 2-D.
3. Midig ku dhufo^{(Right-click)} khadka oo dooro Qaabka Xogta Taxanaha^{(Format Data Series)} .
4. Tag Buuxi & Khadka tab.
5. Hubi ikhtiyaarka khadka toosan.

Si aad u bilowdo, waxaad u baahan tahay inaad geliso xogtaada aad rabto inaad isticmaasho si aad u abuurto garaafka. Intaa ka dib, u tag Gelida^{(Insert )} tab oo guji badhanka Gelida ama Jaantuska Goobta^{(Insert Line or Area Chart)} ee qaybta Charts . Intaa ka dib, dooro garaaf 2-D Line ah oo aad rabto inaad ku muujiso xaashidaada.

Kadib gelinta garaafka, midig-guji khadka buluuga ah, oo dooro ikhtiyaarka Qaabka Xogta Taxanaha^{(Format Data Series)} .

Dhinacaaga midig, waa inaad ku aragtaa guddi meesha aad u baahan tahay inaad u beddesho tabka Buuxinta & Laynka . ^{(Fill & Line )}Taas ka dib, sax ku dheji^{(Smoothed line)} sanduuqa hubinta ee khadka toosan.

Waxaad isla markiiba heli kartaa beddelka.

Sida loo sameeyo garaaf xariiq qalloocan gudaha Xaashiyaha Google

Si aad garaaf qalloocan ugu samayso Google Sheets , raac tillaabooyinkan-

1. Geli dhammaan xogta oo geli jaantus.
2. Shaxda u beddel Line.
3. Ka dooro Smooth tab^(Customize) tab.

Ugu horreyntii^(First) , waxaad u baahan tahay inaad abuurto xaashida faafinta xogta saxda ah. Kadib, dooro dhammaan xogta, dhagsii badhanka^{(Insert )} Gelida, oo ka dooro shaxda^(Chart) liiska.

Sida caadiga ah, waxay tusinaysaa jaantus sida ku cad xogtaada. Waxaad u baahan tahay inaad u beddesho garaaf xariiq. Taas awgeed, dhagsii jaantuska^(Chart) , balaadhi jaantuska nooca^{(Chart type )} liiska hoos-u-dhaca ah, oo dooro wax hoosta calaamadda laynka^(Line) .

Hadda, u gudub tab Customize^{(Customise )} , oo balaadhi shaxda qaabka shaxda^{(Chart style)} . Taas ka dib, sax ku dheji sanduuqa hubinta ee Smooth .

Hadda, cidhifyada fiiqan waa in la beddelaa.

Waa kaas! Waxaan rajeyneynaa in casharkaani uu noqon doono mid waxtar leh.

How to make a curved line graph in Excel and Google Sheets

Αdding a graph in а spreadsheet is nо big deal as long as you know the prоcess. However, do you know that you can make a curved line graph in Excel or Google Sheets? If no, you should check out this tutorial to turn the sharp edges into smoothed lines.

Sometimes you may need to insert a graph in a spreadsheet to show data more beautifully. A graph or chart makes the spreadsheet productive and attractively visualizes the data. It is straightforward to create and add a graph – whether you are using Microsoft Excel or Google Sheets. The problem with the default graph is the sharp edges. Although it defines the exact ups and downs of your data, some people do not like it. If you are one of them, you can smoothen the edges by following this guide. For your information, you can convert existing sharp edges of a graph into a smoothen corner as well as add a new curved graph. Either way, you do not need any third-party add-on.

How to make a curved line graph in Excel

To make a smooth curved line graph in Excel, follow these steps-

1. Enter your data in the spreadsheet and select it to make a graph.
2. Go to Insert tab and insert a 2-D line graph.
3. Right-click on the line and select the Format Data Series.
4. Go to Fill & Line tab.
5. Check the Smoothed line option.

To get started, you need to enter your data that you want to use to create the graph. After that, go to Insert tab and click the Insert Line or Area Chart button in the Charts section. After that, select a 2-D Line graph that you want to display in your spreadsheet.

After inserting the graph, right-click on the blue line, and select Format Data Series option.

On your right side, you should see a panel from where you need to switch to the Fill & Line tab. After that, make a tick in the Smoothed line checkbox.

You can find the conversion immediately.

How to make a curved line graph in Google Sheets

To make a curved graph in Google Sheets, follow these steps-

1. Enter all data and insert a chart.
2. Convert the Chart into Line.
3. Select Smooth from the Customize tab.

First of all, you need to create a spreadsheet with the proper data. Then, select all the data, click the Insert button, and select Chart from the list.

By default, it shows a chart as per your data. You need to convert it to a line graph. For that, click on the Chart, expand the Chart type drop-down menu, and select something under the Line label.

Now, go to Customise tab, and expand the Chart style menu. Following that, make a tick in the Smooth checkbox.

Now, the sharp edges should be changed.

That’s it! Hope this tutorial will be helpful.

Related posts

• 4 siyaabood oo Excel loogu badalo Google Sheets

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• Sida loo muujiyo Taariikhda iyo Waqtiga Hadda ee Excel iyo Google Sheets

• Sida loo sameeyo liiska hoos u dhaca ee Excel iyo Google Sheets

• Sida loogu xidho Google Sheets iyo Excel

• Sida loo sameeyo Histogram gudaha Excel

• Wax-soo-saarka ugu fiican ee Google Sheets si loo horumariyo wax soo saarka

• Isticmaal daaqada daawashada Excel si aad ula socoto unugyada muhiimka ah ee buug-shaqeedka

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

• Sida loo dejiyo xadka Character ee Excel iyo Google Sheets

• Sida loo isticmaalo Sparklines gudaha Excel

• Jadwalka xogtaada Excel

• Sida qoraalka loogu qaybiyo tiirarka ku jira Excel iyo Google Sheets

• Sida loo shaandheeyo xogta gudaha Excel

• Sida loo isticmaalo COUNTIFS, SUMIFS, AVERAGEIFS gudaha Excel

• Ku tiriso qiimayaasha kala go'ay ee hal unug ee Excel iyo Google Sheets

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

• Sida Loogu Beddelayo Inta u dhaxaysa Waraaqaha Shaqada ee Excel

• Sida otomaatig loogu sameeyo hawlaha xaashida Google ee Macros

• Isku xidh Unugyada u dhexeeya Xaashiyaha iyo Buugaagta Shaqada ee Excel