Shaxda Isku-dhafka^{(Combination Chart)} ah waxaa loo isticmaalaa in lagu muujiyo hal jaantus ka sarreeya kan kale iyadoo la isticmaalayo miisaan la mid ah boqolkiiba. Shaxda Isku-dhafka^{(Combination Chart)} ah waxaa sidoo kale loo yaqaan jaantusyada Combo Charts^{(Combo Charts)} . Jaantusyada^(Charts) Isku-dhafka ah waxay u oggolaanayaan akhristaha inuu barto xogta si loo go'aamiyo haddii uu jiro xidhiidh ka dhexeeya labada xog ee xogta. In Microsoft Excel , marka la abuurayo garaaf, guud ahaan waxay leedahay dhidibka X iyo dhidibka Y, laakiin leh garaaf isku dhafan, waxaa jira laba Y-axis oo u oggolaanaya isticmaalaha inuu haysto laba nooc oo kala duwan oo xog ah oo isku mid ah jaantus isku mid ah. .

Isticmaalayaasha Excel^(Excel) waxay isticmaalaan jaantusyo isku dhafan haddii qiyamka hal taxane ay aad u weyn yihiin ama yar yihiin marka la barbardhigo xogta kale; Waxa kale oo ay awood u siinaysaa isticmaalayaasha in ay dib u eegaan xogta waaweyn oo leh miisas xogeedyo badan oo ay ku muujiyaan tirooyinka si habaysan oo hal jaantus ah. Shaxda isku-darka ahi^{(Combination Chart)} waxay tusinaysaa laba nooc oo jaantus ah, kuwaas oo kala ah tiirar iyo xariiqyo, waxayna ku yaalaan jaantus isku mid ah.

Sida loo abuuro jaantus isku^{(Combination Chart)} -dhafan gudaha Excel

Fur Microsoft Excel .

Miis samee ama fur miis jira.

Markaad abuureyso Shaxda Isku-dhafka^{(Combination Chart)} , waxa ugu horreeya ee aad u baahan tahay inaad sameyso waa inaad muujiso miiska oo dhan.

Ka dib u gudub tab^(Insert) Gelida oo guji batoonka Combo Chart ee kooxda ^{(Combo Chart)}Charts .

Liiska hoos-u-hoosaadka, waxaad dooran kartaa nooca jaantusyada combo ee aad rabto.

Noocyada waa jaantusyada Combo ee^{(Combo Charts)} lagu soo bandhigay liiska waxaa loo isticmaalaa in lagu muujiyo noocyada kala duwan ee macluumaadka. Shaxdan Combo^{(Combo Charts)} waa:

• Tiirka-kooxeed -Line^{(Clustered Column -Line)} : Jaantuska^(Chart) noocaan ah waxaa la isticmaalaa marka aad haysatid noocyada xogta.
• Tiirka Isku dhafan -Line on Axis Secondary^{(Clustered Column -Line on Secondary Axis)} : Nooca jaantuskan waxa la isticmaalaa marka kala duwanaanta jaantusku si weyn u kala duwan yahay oo uu leeyahay noocyo xog isku dhafan.
• Aagga La Dulmaray -^{(Stacked Area – Clustered Column)} Tiirka Kooxaysan : Sida Safka Isku-dhafan -Line^{(Clustered Column -Line)} -ka, Aagga La Dulmaray -^{(Stacked Area – Clustered Column)} Tiirka Kooxaysan waxa la isticmaalaa marka aad haysatid noocyada xogta ee isku dhafan.

Ku-kormeeraha ku dul heehaabaya jaantuska Combo^{(Combo Chart)} ama noocyada jaantuska isku-darka^{(Combination Chart)} waxay ku tusi doontaa horudhac xaashidaada.

Dooro Safka Isku dhafan -Line on dhidibka sare^{(Select the Clustered Column -Line on Secondary Axis)} ; Jaantuska noocaan ah wuxuu muujinayaa sharraxaadda ugu habboon si loo barbardhigo xiriirka ka dhexeeya labada xog.

Marka la doorto, waxaad arki doontaa jaantuska leh tiirar iyo xariiqyo isbarbar dhigaya labada xog ee xaashidaada.

Akhri^(Read) : Sida loo geliyo xaashida Excel ee OneNote^{(insert Excel spreadsheet in OneNote)} .

Ku samee shaxda Combo Chart^{(Custom Combo Chart)} ee Excel

Waxaad xitaa samayn kartaa jaantuska Combo Chart^{(Combo Chart)} .

Riix badhanka Combo Chart , dhagsii Abuur Chart Custom Combo^{(Create Custom Combo Chart)} .

Sanduuqa wada hadalka Gelida Shaxda^{(Insert Chart)} ayaa soo bixi doona.

Sanduuqa wada hadalka ee sare, dhagsii badhanka Isku-dhafka Gaarka ah^{(Custom Combination)}

Qeybta hoos timaada, dooro nooca jaantuska iyo dhidibka taxanaha xogtaada; ^{(choose the chart type and axis for your data series;)}Qaybta Nooca Jaantuska^{(Chart Type)} , waxaad dooran kartaa inaad habayso jaantuska adigoo gujinaya liiska sanduuqyada hoose oo dooranaya xulashooyinka aad uga baahan tahay shaxanka.

Hoosta dhidibka sare^{(Secondary Axis)} , dhagsii sanduuqa hubinta ee u dambeeya.

Horudhac Shaxda Isku-dhafka Gaarka^{(Custom Combination Chart)} ah ayaa lagu eegi doonaa dhexda sanduuqa wada hadalka.

Kadib dhagsii OK .

Hadda waxaan haynaa Shaxda Isku-dhafka Gaarka^{(Custom Combination Chart)} ah .

Waxaan rajeyneynaa in casharkaan uu kaa caawiyo inaad fahamto sida loo abuuro jaantusyada isku dhafka^{(Combination Charts)} ah ee Microsoft Excel .

Hadda akhri^{(Now read)} : Sida loo  helo Xididka labajibbaaran ee nambarka ee Excel .

How to create a Combination Chart in Excel

A Combination Chart is used to showcase one chart above the other using the same scale by percentage. The Combination Chart is also called Combo Charts. Combination Charts allow the reader to study data to determine if there is a relationship between the two data sets. In Microsoft Excel, when creating a graph, it generally has an X-axis and a Y-axis, but with a combination graph, there are two Y-axis which allows the user to have two different types of data points in the same chart.

Excel users use combination charts if the values from one series are too large or small compared to the other data; it also enables users to review large data sets with multiple data tables and show the numbers in an orderly manner in one chart. The Combination Chart shows two chart types, namely columns and lines, and is on the same chart.

How to create a Combination Chart in Excel

Open Microsoft Excel.

Create a table or open an existing table.

When creating a Combination Chart, the first thing you need to do is highlight the entire table.

Then go to the Insert tab and click the Combo Chart button in the Charts group.

In the drop-down list, you can select the type of combo charts you want.

The types are Combo Charts displayed in the list is used to highlight different kinds of information. These Combo Charts are:

• Clustered Column -Line: This Chart type is used when you have mixed types of data.
• Clustered Column -Line on Secondary Axis: This chart type is used when the chart’s range varies widely and has mixed data types.
• Stacked Area – Clustered Column: Like the Clustered Column -Line, the Stacked Area – Clustered Column is used when you have mixed types of data.

Hovering your cursor over the Combo Chart or Combination Chart types will display a preview on your spreadsheet.

Select the Clustered Column -Line on Secondary Axis; this chart type showcase the perfect description to compare the relationship between the two data.

Once selected, you will see the chart with columns and lines comparing the two data on your spreadsheet.

Read: How to insert Excel spreadsheet in OneNote.

Create a Custom Combo Chart in Excel

You can even create a custom Combo Chart.

Click the Combo Chart button, click Create Custom Combo Chart.

An Insert Chart dialog box will appear.

In the dialog box above, click the Custom Combination button

Under the section, choose the chart type and axis for your data series; in the Chart Type category, you can choose to customize the chart by clicking the list boxes below and selecting the options you need in the chart.

Under the Secondary Axis, click the last checkbox.

A preview of the Custom Combination Chart will be previewed in the middle of the dialog box.

Then click OK.

Now we have a Custom Combination Chart.

We hope this tutorial helps you understand how to create Combination Charts in Microsoft Excel.

Now read: How to find the Square Root of a Number in Excel.

Related posts

• 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 sameeyo shaxda Pie ee Excel

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

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo sameeyo garaafka fudud ama jaantuska gudaha Excel

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

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo isticmaalo Rept Function gudaha Excel