Iyadoo lagu siinayo fursado badan oo aad ku abuuri karto jaantusyada Excel , jaantus kastaa wuxuu leeyahay baaxad ka duwan iyo isticmaalka kala duwan. Jaantuska pie caadi ahaan waa shax laba-cabbir ah oo loo isticmaalo isbarbardhigga qiyamka u dhexeeya 2 tiir. Haddii aad rabto inaad ku abuurto jaantus-pie gudaha Excel , fadlan akhri maqaalkan.

Sida loo sameeyo shaxda Pie ee Excel

Maqaalkan, waxaan u tixgelin doonaa jaantuska Hierarchical Sunburst inuu yahay nooc ka mid ah jaantusyada pie, in kasta oo habka lagu daro uu ka duwan yahay. Habka lagu abuurayo jaantus kee ah oo loogu talagalay xogta ku baahsan 2 tiir oo kaliya waa mid fudud.

Ka dooro xogta 2da tiir ee su'aasha laga hadlayo.

• Guji Insert > Pie Chart .
• Kadib dooro shaxda 2-D pie.

Aragti weyn ee shaxda 2-D pie waa sida soo socota:

• Haddii aad dooratid xogta in ka badan 2 tiir marka aad isticmaalayso jaantuska 2-D pie, jaantusku waxa uu iska indhatiraa wixii ka baxsan 2da tiir ee hore.
• Waxa la mid ah kiiska jaantuska qorrax dhaca ee kala sareynta^{(hierarchical sunburst chart)} .
• Ka dooro xogta 2da tiir ee su'aasha laga hadlayo.
• Guji Insert > Other Charts > Hierarchical > Sunburst .

Aragti weyn oo ku saabsan jaantuska qorrax-burstaha kala sareynta^{(hierarchical sunburst chart )} waa sida soo socota:

Jaantusku wuxuu u muuqan doonaa mid la mid ah jaantuska xaashida Excel , laakiin qiyamka waxaa laga yaabaa in lagu xuso gudaha pies.

Samee jaantus xogta ku faafsan tiirar badan oo Excel ah^(Excel)

Fikrad ahaan, jaantusku maaha ikhtiyaarka ugu fiican ee kuwa ka shaqeeya tiirar badan. Haddii sidaas la sameeyo waxay u sii kala qaybin doontaa pie kasta oo u qaybin doona gelinta tiirarka. Waa in aad isku daydaa jaantuska tiirka. Si kastaba ha ahaatee, habka loo abuurayo jaantuska xogta safafka badan waa sida soo socota:

Dooro xogta oo dhamaystiran dhammaan tiirar badan

Guji Insert > Pie Chart .

Hadda dooro mid ka mid ah Donut^(Doughnut) -ka ama jaantusyada 3-cabbirka ah^{(3-dimensional charts)} .

Waa in la ogaadaa in ikhtiyaarrada jaantuska pie ee aan ka ahayn jaantuska 2-D ay isla shaqeyn doonaan xitaa markaad u isticmaasho 2 tiir oo keliya.

Jaantusyada pie-ka ee halkan lagaga hadlay waa kuwo dabiici ah, taas oo macnaheedu yahay in qiyamka jaantusku uu ahaan doono mid joogto ah xitaa marka aad bedesho qiyamka liiska xogta.

Haddii aad u baahan tahay qiyamka si aad u bedesho qiyamka shaxanka pie marka isbeddelada ku yimaad liiska xogta, isku day in aad abuurto jaantus firfircoon^{(creating a dynamic chart )} gudaha Excel.

Rajo inay ku caawiso!

How to make a Pie Chart in Excel

While you are provided with а lot of options for creаting charts in Excel, every chart has a differеnt scope and different use. A pie chart is a usually 2-dimensional chart υsed for comparing values between 2 columns. If you wish to create a pie chart in Εxcel, plеaѕe read through this article.

How to make a Pie Chart in Excel

In this article, we would consider the Hierarchical Sunburst chart as a type of pie chart, though the procedure for adding it is a little different. The procedure to create a pie chart for data spread across 2 columns only is simple.

Select the data across the 2 columns in question.

• Click on Insert > Pie Chart.
• Then select the 2-D pie chart.

A larger view of the 2-D pie chart is as follows:

• In case you select data across more than 2 columns while using the 2-D pie chart, the chart will ignore entries beyond the first 2 columns.
• Similar is the case for a hierarchical sunburst chart.
• Select the data across the 2 columns in question.
• Click on Insert > Other Charts > Hierarchical > Sunburst.

A larger view of the hierarchical sunburst chart is as follows:

The chart will appear similar to the pie chart of your Excel sheet, but the values would probably be mentioned inside the pies.

Make a chart with data spread across multiple columns in Excel

Ideally, a pie chart isn’t the best option for those dealing with multiple columns. Doing so would further divide each pie into the entries across the columns. You should rather try a column chart. However, the procedure for creating a multiple column data pie chart is as follows:

Select the complete data across all multiple columns.

Click on Insert > Pie Chart.

Now select any of the Doughnut or 3-dimensional charts.

It should be noted that the pie chart options other than the 2-D chart would work the same even when you use them for just 2 columns.

The pie charts discussed here are static in nature, which means that the values in the chart will remain constant even when you change the values in the data list.

If you need the values to change in the values in the pie chart upon changes in the data list, try creating a dynamic chart in Excel.

Hope it helps!

Related posts

• Sida loo sameeyo shaxda Pie ee Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo abuuro Graph Bar ama Shaxda Saxiixa ee Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo abuuro shaxda Pivot iyo shaxda Pivot gudaha Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

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

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo xidho booska jaantuska xaashida xaashida ee Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

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

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

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