MS Excel + VBA：以编程方式设置数据标签方向
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10124427/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
MS Excel + VBA: setting data label orientation programmatically
提问by LeRascalier
I'm trying to set the orientation of data labels on a bar chart to vertical. Normally I'd find out how to do this by recording a macro, but for some reason it doesn't seem to generate any code. Is it possible to do?
我正在尝试将条形图上数据标签的方向设置为垂直。通常我会通过录制宏来找出如何做到这一点，但由于某种原因，它似乎没有生成任何代码。有可能吗？
I'm using Excel 2010.
我正在使用 Excel 2010。
回答by Francis P
Here is what recording the macro generated:
以下是记录宏生成的内容：
With Selection.TickLabels
.ReadingOrder = xlContext
.Orientation = xlDownward
End With
Hope this helps! :)
希望这可以帮助！:)
