如何在图表工作表上包装x轴标签 [英] How to wrap x axis label on chart sheet
问题描述
使用VB.NET,我在图表工作表上有一个图表,想要在Excel 2010中包装x轴标签。如果我减少了图表区域的宽度,它省略或截断x轴标签。有没有快速解决方法。
Using VB.NET, I have a chart on Chart sheet and want to wrap x axis label in Excel 2010.If i reduce the chartarea's width, It omits or truncates x axis label. Is there any quick fix for it.
x轴标签有价值:0,500,000,000,000,1,000,000,000,000,1500,000,000,000,2,000,000,000,000
x axis labels have value :0, 500,000,000,000,1,000,000,000,000,1500,000,000,000,2,000,000,000,000
按照要求,我不能设置为50百万,并且必须显示完整的数字。任何帮助表示赞赏。
As per the requirement, I cant set to 50 millions and have to display full digits. Any help is appreciated.
提前致谢
推荐答案
您可以旋转轴标签
you can rotate the axis labels
从
这里下载样本 获得一些想法
download the samples from here to get some ideas
这篇关于如何在图表工作表上包装x轴标签的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!