Skip to main content

Conas lipéid ais a rothlú i gcairt in Excel?

Údar: Sun Athraithe Deiridh: 2014-09-17

Uaireanta, bíonn na lipéid aiseach sa chairt chomh fada sin go gcuirtear na lipéid le chéile mar a thaispeántar thíos. Mura dteastaíonn uait méid na cairte a athrú chun na lipéid a chomhlíonadh, is féidir leat na lipéid ais a rothlú chun na lipéid a thaispeáint go soiléir in Excel.

doc-rotae-ais-lipéad-1

Rothlaigh lipéid aiseach sa chairt

mboilgeog cheart gorm saighead Rothlaigh lipéid aiseach sa chairt

Lean na céimeanna seo le do thoil:

Rothlaigh lipéid aiseach in Excel 2007/2010

1. Cliceáil ar dheis ag an ais is mian leat a lipéid a rothlú, roghnaigh Ais na formáide ón roghchlár comhthéacs. Féach an pictiúr:

doc-rotae-ais-lipéad-2

2. Sa Ais na formáide dialóg, cliceáil Ailíniú cluaisín agus téigh go dtí an Leagan Amach an Téacs alt chun an treo atá uait a roghnú as bosca liosta de Treo an téacs. Féach an pictiúr:

doc-rotae-ais-lipéad-3

3. Dún an dialóg, ansin feiceann tú go bhfuil na lipéid ais rothlaithe.

doc-rotae-ais-lipéad-4

Rothlaigh lipéid aiseach i gcairt Excel 2013

Má tá Microsoft Excel 2013 á úsáid agat, is féidir leat na lipéid ais a rothlú leis na céimeanna seo a leanas:

1. Téigh go dtí an chairt agus cliceáil ar dheis ar a lipéid ais a rothlóidh tú, agus roghnaigh an Ais na formáide ón roghchlár comhthéacs.

2. Sa Ais na formáide pána ar dheis, cliceáil an Méid & Airíonna cnaipe, cliceáil an Treo an téacs bosca, agus sonraigh treo amháin ón liosta anuas. Féach an scáileán thíos:

doc-rotae-ais-lipéad-5

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup  |   VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle   |  Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla   |  Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí:  12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
Comments (12)
No ratings yet. Be the first to rate!
Droid
Droid
This comment was minimized by the moderator on the site
makasih broooo
Reply
0
0
Stef
Stef
This comment was minimized by the moderator on the site
Hi, if I have 2 lines text (AXIS CATEGORY) and I want to change the orientation only for the second text (from the bottom), it's possible? I followed all the steps, but only the first field changed.
Reply
0
0
Luke
Luke     Stef
This comment was minimized by the moderator on the site
I dont know if you found a solution, but I have the same problem now, and would very much apreciate if someone could tell me how to do it.
Reply
0
0
Michael
Michael
This comment was minimized by the moderator on the site
How about a "Rotate axis labels in chart of Excel 2016"? If they haven't removed that capability, they've sure hidden it well.
Reply
0
0
Aisha
Aisha     Michael
This comment was minimized by the moderator on the site
Right click x-axis --> format axis --> text options --> click the third image tab --> text box --> keep as horizontal and under custom angle, enter -45. Took too long to figure that out, but it worked!
Reply
0
0
Stephanie
Stephanie     Aisha
This comment was minimized by the moderator on the site
Thank you! This worked for me!
Reply
0
0
Owen
Owen     Aisha
This comment was minimized by the moderator on the site
Thank you!!! I've been trying to rotate some titles that way for a LONG time in Office 365. Why the h wouldn't they at least keep good functionality from earlier versions? Drives me batty the way the programs seem to keep getting less usable.
Reply
0
0
Sam
Sam     Aisha
This comment was minimized by the moderator on the site
Thank you, it wouldn't allow me to enter 135 degrees so I was wondering about it!
Reply
0
0
august_25@hotmail.com
    Michael
This comment was minimized by the moderator on the site
I found it. select the axis you want. I should form a box around the labels, and then right click. Select format axis. A menu on the right hand side will appear.

Now is the question of how to turn the labels to an angle other than 0-90-180-270.
Reply
Report
0
0
Caco
Caco    
This comment was minimized by the moderator on the site
Cant find it. Hate Microsoft and its constant tinkering with something that used to work well. Dislike the ribbon bar with a passion. Takes more mouse clicks to do the same thing vs the drop down menus of 2003
Reply
0
0
Frank
Frank    
This comment was minimized by the moderator on the site
Custom Angle, right beneath Text Direction :)
Reply
0
0
elliot
elliot    
This comment was minimized by the moderator on the site
I didn't find it. I'm almost about to give up. Word 2016 sucks.
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations