Jaantusyada Pie^(Pie) waa nooca caadiga ah ee muuqaalaynta xogta. Jaantusyada Pie^(Pie) waxay u fududayn karaan kuwa kale inay fahmaan xogta aad soo bandhigayso. Jeex kasta oo ka mid ah pie waa hal qayb, qaybaha oo dhanna waxay ku daraan pie oo dhan. Si kale haddii loo dhigo, jaantusyada pie ayaa aad faa'iido u leh marka aad haysato xog ururin oo isku darka ah ilaa 100%. 

Dhab ahaantii dhammaan softiweerka xaashida ayaa bixiya hab lagu abuuro jaantusyada pie. Maanta waxaan diiradda saari doonaa abuurista jaantusyada pie ee Microsoft Excel .

Sida loo sameeyo jaantuska Pie ee Excel

Microsoft Excel waa halbeegga dahabiga ah ee software xaashida xaashida. Waxaan adeegsan doonnaa arjiga desktop-ka, laakiin waxaad dooran kartaa inaad isticmaasho nooca shabakadda. Ka dib oo dhan, qaybta Microsoft Office ee shabakada internetka ayaa diyaar u ah bilaash! Aynu eegno sida loo sameeyo shaxda pie xogtaada gudaha Excel .

1. Ka bilow^(Start) xogtaada Tusaalahan, waxaan ku aragnaa wadarta lacagta uu ciyaaryahan kastaa ku guuleystay fiidkii.

1. Dooro tabka^(Insert) Gelida, ka dibna dooro amarka jaantuska pie ee kooxda Charts ee ribbon.

1. Dooro ikhtiyaarka 2-D Pie .

1. Waxaad arki doontaa tiro xulashooyin jaantusyo kee ah oo diyaar ah. Hadda, aynu doorano shaxda 2-D ee aasaasiga ah. Isla marka aad doorato summada pie 2-D, Excel waxa ay soo saari doontaa jaantus ka kooban xaashida shaqada.

Waxaad hadda abuurtay shaxda pie! Marka xigta waxaanu sahamin doonaa hagaajinta muuqaalka iyo dareenka shaxda pie. 

Samaynta Shaxda Pie

Excel wuxuu bixiyaa dhowr siyaabood oo loo qaabeeyo jaantusyada pie.

Waxaad bedeli kartaa Ciwaanka Shaxda^{(Chart Title)} haddii aad rabto. Excel waxay si toos ah u isticmaashaa madaxa tiirka meesha xogta shaxdaadu ku kaydsan tahay - kiiskan, "Guulashada Turubka." Haddii aad cusboonaysiiso qoraalka madaxa tiirkaas, jaantuska ciwaanka ayaa si toos ah u cusboonaysiin doona. Haddii kale, waxaad laba-guji kartaa cinwaanka jaantuska laftiisa oo aad wax ka beddeli kartaa.

Waa inaad sidoo kale u dejisaa xogtaada sida saxda ah. Bal qiyaas saacad analooga ah oo dusha sare ka saaran shaxanka pie. Jeexa ugu weyn ee keega waa inuu bilaabmaa 12:00. Markaad u socoto dhanka saacadda ee hareeraha pie, jeexyadu waa inay si tartiib tartiib ah u sii yaraanayaan. Si taas loo gaaro, waxaad u baahan tahay inaad kala soocdo xogtaada tirooyinka tan ugu weyn ilaa tan ugu yar. 

Dooro shayga liiska guriga . ^(Home)Hubi^(Make) in calaamaduhu ku jiro mid ka mid ah unugyada tiirka oo wata xog tirooyin ah. Dooro badhanka Kala soocida & Shaandhaynta^{(Sort & Filter)} ee ribbon ku yaal oo dooro kala sooci^{(Sort Largest to Smallest)} kan ugu wayn .

Shaxankaaga keega si toos ah ayuu u cusboonaysiin doonaa, oo hadda waxaad raacaysaa hab-dhaqannada ugu wanaagsan ee ku saabsan siday u kala horreeyaan xogtaada gudaha jaantuska keega.

Dooro Summadaada Xogta^{(Data Labels)} . Ku bilow adigoo gujinaya shaxda pie oo dooro calaamada cagaarka iyo cagaarka oo ku taal dhanka midig ee jaantuska si aad u muujiso Chart Elements .

Hadda calaamadee sanduuqa ku xiga Calaamadaha Xogta^{(Data Labels)} .

Balaadhi fursadaha Summadaha Xogta^{(Data Labels)} ka dibna dooro Ikhtiyaar badan…^{(More Options…)}

Taasi waxay furi doontaa guddiga Calaamadaha Xogta Qaabka^{(Format Data Labels)} .

Sida Calaamadaha Shaxda ee Excel Pie u shaqeeyaan

Qaabka qaabka xogta^{(Format Data Labels)} guddiga waa meesha aad ka dooran karto summadaha ka soo muuqan doona shaxanka pie. 

Dooro summada garaafka ee loo yaqaan ' Label Options ' . 

Kordhi qaybta Ikhtiyaarada Summada^{(Label Options)} oo waxaad arki doontaa tiro calaamado ah oo aad dooran karto inaad ku muujiso jaantuskaaga.

Waa kan sida ikhtiyaar kasta oo sumaduhu u shaqeeyo:

• Qiimaha Unugyada^{(Value from Cells)} : Tusaalaha kore, shaxda pie waxay soo bandhigaysaa hal tiir oo xog ah. Haddii aad haysatid tiir kale oo xog ah, waxaad isticmaali kartaa doorashadan si aad u isticmaasho qiyamkaas marka aad calaamadaynayso jeex kasta oo keega ah.
  
  Si kale haddii loo dhigo, waxaad dooran kartaa inaad u isticmaasho xogta unugyo kala duwan si ay xogtaadu u calaamadiso. Tusaale ahaan, waxaad ku dari kartaa tiirka saddexaad xogtaada, " Isbeddelka^(Change) usbuucii hore." Haddii aad ka doorato qiimaha unugyada^{(value from cells)} oo aad doorato unugyada C2:C6, markaa shaxda pieadu waxay u ekaan doontaa sidan:

• Magaca Taxanaha:^{(Series Name: )} Hubinta doorashadan waxay ku dari doontaa ciwaanka xogta tiirarkaaga jeex kasta oo pie ah. Tusaalahayaga, jeex kasta oo ka mid ah keega ayaa heli doona calaamad odhanaysa " Guusha turubka^{(Poker Winnings)} ."
• Magaca Qaybta:^{(Category Name: )} Midkan ayaa lagula talinayaa. Halkii laga lahaa inaad tixraacdo halyeeyga, doorashadani waxay ku calaamadin doontaa jeex kasta oo pie ah oo leh qiyamka qaybta.
• Qiimaha:^{(Value: )} Tan si toos ah ayaa loo hubiyaa. Jeex kasta oo ka mid ah keega waxaa lagu calaamadeeyay qiimaha xogta ee u dhiganta boggaas. Tusaalahayaga, taasi waa lacagta doollarka ah ee ciyaaryahan kasta uu ku guuleystay.
• Boqolkiiba^(Percentage) : Tani inta badan aad bay faa'iido u leedahay. Immisa boqolkiba keega oo dhan ayuu cadku ka dhigan yahay? Saxida santuuqan waxay hubin doontaa in jeex-jeexa lagu calaamadeeyay boqolleyda cad-caddu ka dhigan tahay.
• Tus Khadadka Hogaamiye:^{(Show Leader Lines: )} Haddi calaamada xogtu aanay ku wada haboonayn jeex jeex, doorashadani waxay ku dari doontaa xariiq isku xidha calaamada xogta jeex.
• Furaha Halyeyga^{(Legend Key)} : Haddii aadan awood u lahayn Magaca Qaybta^{(Category Name )} , hubi inaad saxdo sanduuqan si uu halyeygu uga soo muuqdo xagga hoose ee jaantuskaaga.

Beddelidda Midabka Shaxda Pie

Si aad u bedesho nidaamka midabka jaantuskaaga, ku bilow adiga oo dooranaya shaxda pie. Kadib dooro astaanta burushka rinjiga, Qaababka Jaantuska. ^{(Chart Styles. )}

Waxaad arki doontaa laba tabs, Style iyo Colors . Sahami ikhtiyaarada ku jira labada tab oo dooro nidaamka midabka aad jeceshahay.

Haddii aad rabto inaad muujiso jeex gaar ah oo pie ah, mari midab jeexkaas markaad dooranayso hadh cawl dhammaan xaleefyada kale. 

Waxaad dooran kartaa hal jeex oo keega ah adiga oo dooranaya jaantuska keega ka dibna riixaya jeexista aad rabto inaad qaabayso. Waxa kale oo aad ka dhaqaajin kartaa jeexjeexa aad rabto in aad wax yar ka iftiimiso xarunta si aad ugu wacdo sidatan:

Beddelka Nooca Shaxda Pie

Si aad u bedesho nooca jaantuska, dooro tabka Naqshadaynta^{(Design )} ee ribbon ka dooro Beddel Nooca Shaxda^{(Change Chart Type)} .

Tusaale ahaan, dooro Shaxda Donut^{(Donut Chart)} .

Hadda shaxda tusaleheenu waxay u egtahay sidan:

Noocyada kale ee Charts ee Excel

Hadda oo aad ogtahay aasaaska abuurista jaantuska pie ee Excel , fiiri maqaalkeena, " Charting Your Excel Data " si aad u barato tabo iyo tabo dheeraad ah oo ku saabsan sida loo soo bandhigo sawirada xogtaada siyaabo cad oo adag. 

How to Make a Pie Chart in Excel

Pie charts are a common type of data visualization. Pie charts can make it easier for others to understand the datа you’re presenting. Eaсh slice of the pie is one component, аnd the compоnents all add up to the whole pie. In other words, pie charts are most usefυl whеn you have data sets that add up to 100%. 

Virtually all spreadsheet software offers a way to create pie charts. Today we’ll focus on creating pie charts in Microsoft Excel.

How to Create a Pie Chart in Excel

Microsoft Excel is the gold standard of office spreadsheet software. We’ll be using the desktop application, but you can opt to use the web version. After all, the Microsoft Office suite for the web is available for free! Let’s look at how to create a pie chart from your data in Excel.

1. Start with your data. In this example, we see the total amount of money that each player has won during an evening of poker.

1. Select the Insert tab, and then select the pie chart command in the Charts group on the ribbon.

1. Select the 2-D Pie option.

1. You’ll see a number of pie chart options available. For now, let’s choose the basic 2-D pie chart. As soon as you select the 2-D pie icon, Excel will generate a pie chart inside your worksheet.

You have just created a pie chart! Next we’ll explore adjusting the look and feel of your pie chart. 

Formatting Your Pie Chart

Excel offers several ways to format pie charts.

You can change the Chart Title if you like. Excel automatically uses the header of the column where your chart data is stored—in this case, “Poker Winnings.” If you update the text of that column’s header, the pie chart’s title will update automatically. Alternatively, you can double-click on the chart title itself and edit it.

You should also put your data in the right order. Imagine an analog clock superimposed on top of your pie chart. The biggest slice of the pie should begin at 12:00. As you go clockwise around the pie, the slices should get progressively smaller. In order to accomplish this, you need to sort your numerical data from largest to smallest. 

Select the Home menu item. Make sure your cursor is in one of the cells in the column with numerical data. Select the Sort & Filter button on the ribbon and choose Sort Largest to Smallest.

Your pie chart will automatically update, and now you’re following best practices regarding the order of your data within the pie chart.

Choose your Data Labels. Begin by clicking on the pie chart and selecting the green plus icon to the right of the chart to display Chart Elements.

Now check the box next to Data Labels.

Expand the options for Data Labels and then select More Options…

That will open the Format Data Labels panel.

How Excel Pie Chart Labels Work

The Format Data Labels panel is where you can choose which labels will appear on your pie chart. 

Select the bar graph icon called Label Options. 

Expand the Label Options section and you’ll see a number of labels you can choose to display on your pie chart.

Here’s how each label option works:

• Value from Cells: In the example above, the pie chart displays one column of data. If you had another column of data, you could use this option to use those values when labeling each slice of the pie.
  
  In other words, you can choose to use the data from a different range of cells as your data labels. For example, you can add a third column to your data, “Change from last week.” If you choose value from cells and select cells C2:C6, then your pie chart would look like this:

• Series Name: Checking this option will add the heading of your data column to every slice of the pie. In our example, each slice of the pie would get a label saying “Poker Winnings.”
• Category Name: This one is recommended. Instead of having to refer to the legend, this option will label each slice of the pie with the category values.
• Value: This is checked automatically. Each slice of the pie is labeled with the data value corresponding to that slide. In our example, that’s the dollar amount each poker player won.
• Percentage: This is often very useful. What percentage of the whole pie does the slice represent? Checking this box will ensure that the slice is labeled with the percentage the slice represents.
• Show Leader Lines: If the data label won’t fit entirely inside the slice, this option will add a line connecting the data label to the slice.
• Legend Key: If you don’t have Category Name enabled, be sure to check this box so the legend appears at the bottom of your pie chart.

Changing Pie Chart Colors

To change your pie chart color scheme, begin by selecting the pie chart. Then select the paintbrush icon, Chart Styles. 

You’ll see two tabs, Style and Colors. Explore the options in both tabs and choose a color scheme you like.

If you want to highlight a specific slice of the pie, apply a color to that slice while choosing a shade of gray for all the other slices. 

You can select a single slice of the pie by selecting the pie chart and then clicking on the slice you want to format. You can also move the slice you want to highlight slightly away from the center to call attention to it like this:

Changing Pie Chart Type

To change the chart type, select the Design tab on the ribbon and select Change Chart Type.

For example, select the Donut Chart.

Now our example pie chart looks like this:

Other Kinds of Charts in Excel

Now that you know the basics of creating a pie chart in Excel, check out our article, “Charting Your Excel Data” to learn more tips and tricks on how to present your data visualizations in clear, compelling ways. 

Related posts

• Sida loo tirtiro khadadka banaan ee Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Sida loo isticmaalo Excel's What-If Analysis

• Sida Loo Hagaajiyo Safka gudaha Excel

• Sida loo raad raaco Ku-tiirsanaanta gudaha Excel

• Sida Loo Raadiyo Excel

• Goorta la Isticmaalayo Tusaha-Match Bedelkii VLOOKUP ee Excel

• Sida loo Furo Word iyo Excel si Badbaado ah

• Safka Kooxda iyo Tiirarka ku jira xaashida shaqada ee Excel

• Sida Looga Saaro Safka Kooban Ee Excel

• Sida looga saaro Gridlines gudaha Excel

• 3 Siyood Oo Unugyada Excel Loogu Kala Qaybiyo

• 10 Talooyin iyo Tabaha Excel ee 2019

• Hal-Column iyo Xog-urur badan oo Aasaaska ah oo ku kala soocida xaashida faafinta ee Excel

• Sida loo Hagaajiyo #N/A Khaladaadka gudaha Foomamka Excel sida VLOOKUP

• Hagaha VBA Sare ee MS Excel

• Si degdeg ah ugu qor nambarada Word iyo Excel

• Adeegsiga Qalab Raadinta Hadafka ee Excel Maxaa-Haddii Falanqaynta

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