跳到主要内容

如何在Excel中旋转图表中的轴标签?

有时,图表中的轴标签太长,以致标签被挤在一起,如下图所示。 如果不想调整图表大小以适应标签,可以旋转轴标签以在Excel中清晰显示标签。

文档旋转轴标签 1

旋转图表中的轴标签


箭头蓝色右气泡 旋转图表中的轴标签

请按照以下步骤操作:

在Excel 2007/2010中旋转轴标签

1.右键单击要旋转其标签的轴,选择 格式轴 从上下文菜单中。 看截图:

文档旋转轴标签 2

2.在 格式轴 对话框中,单击 对准 标签,然后转到 文字版面 部分,从以下列表框中选择所需的方向 文字方向。 看截图:

文档旋转轴标签 3

3.关闭对话框,然后可以看到轴标签已旋转。

文档旋转轴标签 4

旋转Excel 2013图表中的轴标签

如果使用Microsoft Excel 2013,则可以按照以下步骤旋转轴标签:

1.转到图表,然后右键单击要旋转的轴标签,然后选择 格式轴 从上下文菜单。

2.在 格式轴 在右侧窗格中,单击 大小与属性 按钮,点击 文字方向 框,然后从下拉列表中指定一个方向。 请参阅以下屏幕截图:

文档旋转轴标签 5

最佳办公生产力工具

热门特色: 查找、突出显示或识别重复项   |  删除空白行   |  合并列或单元格而不丢失数据   |   不使用公式进行四舍五入 ...
超级查询: 多条件VLookup    多值VLookup  |   跨多个工作表的 VLookup   |   模糊查询 ....
高级下拉列表: 快速创建下拉列表   |  依赖下拉列表   |  多选下拉列表 ....
列管理器: 添加特定数量的列  |  移动列  |  切换隐藏列的可见性状态  |  比较范围和列 ...
特色功能: 网格焦点   |  设计图   |   大方程式酒吧    工作簿和工作表管理器   |  资源库 (自动文本)   |  日期选择器   |  合并工作表   |  加密/解密单元格    按列表发送电子邮件   |  超级筛选   |   特殊过滤器 (过滤粗体/斜体/删除线...)...
前 15 个工具集12 文本 工具 (添加文本, 删除字符,...)   |   50+ 图表 类型 (甘特图,...)   |   40+ 实用 公式 (根据生日计算年龄,...)   |   19 插入 工具 (插入二维码, 从路径插入图片,...)   |   12 转化 工具 (小写金额转大写, 货币兑换,...)   |   7 合并与拆分 工具 (高级组合行, 分裂细胞,...)   |   ... 和更多

使用 Kutools for Excel 增强您的 Excel 技能,体验前所未有的效率。 Kutools for Excel 提供了 300 多种高级功能来提高生产力并节省时间。  单击此处获取您最需要的功能...

kte选项卡201905


Office Tab 为 Office 带来选项卡式界面,让您的工作更加轻松

  • 在Word,Excel,PowerPoint中启用选项卡式编辑和阅读,发布者,Access,Visio和Project。
  • 在同一窗口的新选项卡中而不是在新窗口中打开并创建多个文档。
  • 每天将您的工作效率提高50%,并减少数百次鼠标单击!
Comments (12)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
makasih broooo
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.
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.
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.
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!
This comment was minimized by the moderator on the site
Thank you! This worked for me!
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.
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!
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.
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
This comment was minimized by the moderator on the site
Custom Angle, right beneath Text Direction :)
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.
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations