Jonas.S


Hi all,

Anyone having a list over point_index which is used in GET.CHART.ITEM()

Regards

\Jonas





Re: GET.CHART.ITEM

duck thing


No but I'll let you know if it happens!







Re: GET.CHART.ITEM

Jon Peltier

Pardon the long post. This is from the old Excel 4 Macro Functions help file:

GET.CHART.ITEM(x_y_index, point_index, item_text)

X_y_index is a number specifying which of the coordinates you want returned.

X_y_index Coordinate returned

1 Horizontal coordinate
2 Vertical coordinate

Point_index is a number specifying the point on the chart item. These indexes are described below. If point_index is omitted, it is assumed to be 1.

If the specified item is a point, point_index must be 1.

If the specified item is any line other than a data line, use the following values for point_index.

Point_index Chart item position

1 Lower or left
2 Upper or right

If the selected item is a legend, plot area, chart area, or an area in an area chart, use the following values for point_index.

Point_index Chart item position

1 Upper left
2 Upper middle
3 Upper right
4 Right middle
5 Lower right
6 Lower middle
7 Lower left
8 Left middle

If the selected item is an arrow in Microsoft Excel 4.0, use the following values for point_index. In Microsoft Excel version 5.0 or later, arrows are named lines, and the arrowhead position returned is equivalent to the end of a line where the arrowhead begins.

Point_index Chart item position

1 Arrow shaft
2 Arrowhead

If the selected item is a pie slice, use the following values for point_index.

Point_index Chart item position

1 Outermost counterclockwise point
2 Outer center point
3 Outermost clockwise point
4 Midpoint of the most clockwise radius
5 Center point
6 Midpoint of the most counterclockwise radius

Item_text is a selection code that specifies which item of a chart to select. See the chart form of SELECT for the item_text codes to use for each item of a chart.

If item_text is omitted, it is assumed to be the currently selected item.
If item_text is omitted and no item is selected, GET.CHART.ITEM returns the #VALUE! error value.

Remarks

If the specified item does not exist, or if a chart is not active when the function is carried out, the #VALUE! error value is returned.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______






Re: GET.CHART.ITEM

Jonas.S

Better late then never Thanks Jon!