excel - 使用 VBA 获取用于定义误差线的范围

Question

我有一个 Excel 图表。其中一个系列具有根据工作表范围定义的 X 和 Y 误差线。

我想通过 VBA 获取这些范围(而不是设置它们)。这可能吗？

Answer 1

Jon Peltier 在他的博客上有一篇关于误差线的文章 here

引自:

Programmatically Defining Custom Error Bars

The command to add error bars using Excel is: {Series}.ErrorBar Direction:={xlX or xlY}, Include:=xlBoth, Type:=xlCustom, _ Amount:={positive values}, MinusValues:={negative values} Values can be a single numerical value, for example, 1, an comma-separated array of numerical values in curly braces, such as {1,2,3,4}, or a range address in R1C1 notation. For values in Sheet1!$G$2:$G$10, enter the address as Sheet1!R2C7:R10C7. Combine both plus and minus in the same command. In Excel 2007, if you don’t want to show a particular error bar, you must enter a value of zero in this command. In 2003, you can enter a null string “”. In Excel 2003, the range address must begin with an equals sign, =Sheet1!R2C7:R10C7; Excel 2007 accepts the address with or without the equals sign. Single values or arrays may be entered with or without the equals sign in either version of Excel.

在 Ozgrid 上的帖子中，乔恩·珀尔帖说

the range for custom error bar values is not exposed to VBA

如果乔恩说做不到，那就做不到。