Marka la samaynayo jaantus, barnaamijku waxa uu tilmaamayaa habka saxda ah ee loo habayn karo xogta; barnaamijku wuxuu go'aamiyaa midka lagu calaamadinayo dhidibka jiifka ah iyo halka lagu dhejiyo halyeeyga jaantuska, laakiin ka waran haddii uu jiro qalad? Tusaale ahaan, waxaad doonaysaa in safafka xogta lagu soo bandhigay dhidibka toosan lagu muujiyo dhidibka toosan. Markaa waxaad safafka u beddeli kartaa tiirar si xogtu u muujiso sidaad rabto; tan waxa lagu sameeyaa iyadoo la isticmaalayo badhanka Switch Row/ Column

Sida loo beddelo safafka^(Rows) iyo tiirarka^(Columns) gudaha Excel

Qaabka Safka^{(Switch Row)} Wareega ama Tiirka^(Column) ayaa u oggolaanaya isticmaalaha inuu ku beddelo xogta dhidibka; xogta ku taal dhidibka-X waxa ay u guuri doontaa dhidibka Y-^(Y-axis) . Waa muuqaal beddela xogta shaxda.

1. Bilaw Microsoft Excel
2. Samee jaantus ama isticmaal jaantus jira
3. Guji shaxda
4. Guji tab Nakhshadda Shaxda
5. Riix^(Click) badhanka Switch Row / Column Saadaasha
6. Safafka ayaa loo beddelaa tiir

Si aad u bedesho safafka iyo tiirarka shaxda Excel, raac hababka hoose.

Bilaw Microsoft Excel .

Samee miis xisaabeed ama isticmaal mid jira.

Muuji miiska.

Kadib tag Geli^{(Insert )} oo dooro shaxda^(Chart) kooxda Charts ; casharkan, waxaanu ku dooranay shaxda Bar^{(Bar Chart)} .

Markaad gujiso Shaxda Bar^{(Bar Chart)} , ka dooro shaxda Bar ee^{(Bar Chart)} aad rabto liiska hoos u dhaca.

Hadda oo jaantuska la sameeyay, tab Nakhshad Jaantus^{(Chart Design)} ayaa ka soo muuqan doonta bar menu-ka.

Haddii aad haysato jaantus jira, sidoo kale waad isticmaali kartaa.

Tabka kooxda Xogta^{(Data )} , dhagsii badhanka Switch Row / Column .

Safafka ayaa loo beddelaa tiirar.

Waxaan rajeyneynaa in casharkaan uu kaa caawiyo inaad fahamto sida loo beddelo safafka iyo tiirarka shaxda Excel^{(Excel Chart)} .

Akhri soo socda^{(Read next)} : Sida loo isticmaalo shaqada DVAR ee Excel^{(How to use the DVAR function in Excel)} .

How to switch Rows and Columns in Excel

When creating a chart, the program figures oυt the correct way to organize the data; the рrogram determineѕ which to labelѕ to assign to the horizontal axis and where to put the chart’s legend, but what if there is an error? For іnstance, you want the rows of the data displayed on the horizontal axis to be displayed on the νertical axis inѕtead. So уоu can switch the rows to columns so that the data can demonstrate thе way you want; this is done using the Switch Row/ Column button.

How to switch Rows and Columns in Excel

The Switch Row or Column feature allows the user to swap data over the axis; the data on the X-axis will move to the Y-axis. It’s a feature that transforms the data in the chart.

1. Launch Microsoft Excel
2. Create a chart or use an existing chart
3. Click the Chart
4. Click the Chart Design tab
5. Click the Switch Row / Column button
6. The rows are switch to column

To switch the rows and columns in an excel chart, follow the methods below.

Launch Microsoft Excel.

Create a statistical table or used an existing one.

Highlight the table.

Then go to Insert and select a Chart in the Charts group; in this tutorial, we have chosen a Bar Chart.

Once you click the Bar Chart, select the Bar Chart you want from the drop-down list.

Now that the chart is created, a Chart Design tab will appear on the menu bar.

If you have an existing chart, you can also use it.

On the tab in the Data group, click the Switch Row / Column button.

The rows are switch to columns.

We hope this tutorial helps you understand how to switch rows and columns in an Excel Chart.

Read next: How to use the DVAR function in Excel.

Related posts

• Sida loo beddelo tiirarka safafka gudaha Excel oo wata foomamka

• Sida loo codsado Midabka safafka ama Saafka kale ee Excel

• Sida Looga Badalo Saafka ama Saafka Excel [Tallaabo Talaabo]

• Sida loo qaboojiyo safafka iyo tiirarka gudaha Excel

• Safka Kooxda iyo Tiirarka ku jira xaashida shaqada ee Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo isticmaalo shaqada ISODD ee Excel

• Sida loo qariyo safafka iyo tiirarka xaashida Google-ka

• Sida loo xidho unugyada qaacidada Excel si loo ilaaliyo

• Sida loo isticmaalo Find and FindB functional in Excel

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

• Sida Looga Saaro Safka Kooban Ee Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

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

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah

• Sida Loo Mideeyo Unugyada, Tiirarka & Safafka gudaha Excel

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay