Haddii aad rabto in aad dib u magacawdo ama aad wax ka beddesho magaca taxanaha xogta ee Microsoft Excel garaafka ama jaantuska adoon beddelin magaca safafka ama tiirka, maqaalkani adiga ayuu kugu anfici doonaa. Taxanaha xogtu waa xogta ka muuqata gunta garaafyada ama jaantuska. Waxay noqon kartaa magacyada safka ama tiirarka.

Way sahlan tahay in la sameeyo garaafka bar ama jaantus^{(create a bar graph or chart)} , jaantuska laynka^{(Line chart)} , iwm. ee xaashida Excel . Markaad abuurto garaaf ama jaantus, waxay ka soo saartaa xogta unugyada la doortay. Aynu ka soo qaadno inaad jaantus ku samaysay xaashida Excel , laakiin waa inaad wax ka beddeshaa magaca taxanaha xogta.

Sida loogu beddelo Taxanaha Xogta^{(Data Series)} ee garaafka Excel ama jaantuska

Si aad u bedesho, wax uga beddesho ama dib ugu magacawdo Magaca Taxanaha Xogta ee ^{(Data Series)}Microsoft Excel Graph ama Chart adoon tafatirin safka asalka ah ama magaca tiirka, raac nidaamkan:

1. Fur xaashida xaashida ee Excel si aad u hesho jaantuska.
2. Dooro shaxda
3. Midig ku dhufo oo dooro Xulashada Xogta^{(Select Data)} .
4. Ka dooro taxanaha xogta sanduuqa gelinta Legend^{(Legend Entries)}
5. Guji badhanka wax ka beddel^(Edit)
6. Geli magaca cusub sanduuqa magaca Taxanaha^{(Series name)} .
7. Geli qiyamka Taxanaha^{(Series values)} haddii loo baahdo.
8. Guji badhanka OK

Fur xaashida xaashida ee Excel halkaas oo aad ka heli karto shaxda la rabo. Kadib, dooro jaantuska ku jira xaashida faafinta oo midigta ku dhufo. Liiska macnaha guud, waxaad ku arki doontaa ikhtiyaarka la yiraahdo Xulo Xogta^{(Select Data)} . Waxaad u baahan tahay inaad gujiso

Taas ka dib, dooro magaca taxanaha xogta ee aad rabto inaad ku bedesho sanduuqa Legend Entries . Waxay ka muuqataa dhinaca bidix ee daaqadda. Taas ka dib, dhagsii badhanka Edit .

Hadda, wax kasta ka saar sanduuqa magaca Taxanaha^{(Series name )} oo geli magaca cusub ee aad rabto inaad ku muujiso shaxda. Taas ka dib, geli qiyamka Taxanaha^{(Series values)} haddii aad rabto inaad sidoo kale habayso.

Marka la sameeyo, dhagsii badhanka OK laba jeer si aad u badbaadiso isbeddelka. Ka dib marka la keydiyo, jaantuska xaashida ama garaafku wuxuu la soo bixi doonaa magaca taxanaha xogta cusub.

Haddii aad rabto inaad bedesho magacyo taxane ah oo xog badan, raac talaabooyinka isku midka ah. Kahor intaadan gujin badhanka OK labaad si aad u badbaadiso isbeddelka, dooro taxanaha xogta xiga, oo sii wad isla tillaabooyinka halkan lagu sheegay.

Taa waa dhan! Rajo in ay ku caawin

How to rename Data Series in Excel graph or chart

If you want to rename or edit the data series name in Microsoft Excel graph or chart without changing the row or column name, this article will be handy for you. The data series is the data that appears at the bottom of the graph or chart. It can be the row or column names.

It is straightforward to create a bar graph or chart, Line chart, etc. in an Excel spreadsheet. When you create a graph or chart, it fetches data from the selected cells. Let’s assume that you made a chart in an Excel spreadsheet, but you have to edit the data series name.

How to rename Data Series in Excel graph or chart

To change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name, follow this procedure:

1. Open the Excel spreadsheet to find the chart.
2. Select the chart.
3. Right-click on it and choose the Select Data option.
4. Select the data series from the Legend Entries box.
5. Click the Edit button.
6. Enter the new name in the Series name box.
7. Enter the Series values if required.
8. Click the OK button.

Open up the Excel spreadsheet where you can find the desired chart. Then, select the chart in the spreadsheet and right-click on it. In the context menu, you will see an option called Select Data. You need to click on it.

After that, choose the data series name that you want to change in the Legend Entries box. It appears on the left-hand side of the window. Following that, click the Edit button.

Now, remove everything from the Series name box and enter the new name that you want to show in the chart. Following that, enter the Series values if you want to customize it as well.

Once done, click the OK button twice to save the change. After saving, the spreadsheet chart or graph will appear with the new data series name.

In case you want to change multiple data series names, follow the same steps. Before clicking the second OK button to save the change, select the next data series, and keep following the same steps as mentioned here.

Thar’s all! Hope it helps.

Related posts

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo Gelida Xogta laga soo qaatay muuqaalka sawirka ee Excel

• Isticmaal Xidhiidhiyaha Xogta PDF ee Excel si aad u soo dejiso xogta PDF xaashida

• Sida loo isticmaalo Data Visualizer Add-In for Excel si loo abuuro Flowcharts

• Sida loo isticmaalo Nooca Xogta Juquraafiga ee Excel

• Jadwalka xogtaada Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

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

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Si toos ah uga soo celi xogta Excel Bogga Shabakadda

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo isticmaalo shaqada ISODD ee Excel

• Xarunta Xogta Xaashida Shaqada ee Excel si loo daabaco

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

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel