Optional Parameter Specification for Excel's GET.CHART.ITEM()

• Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
• Microsoft Excel for OS/2, versions 2.2 and 3.0

SUMMARY

The parameters point_index and item_text for GET.CHART.ITEM(x_y_index, point_index,item_text) are optional parameters. There is no standard in Microsoft Excel for the use of optional parameters, so the specific types of use follow:

1. If both point_index and item_text are omitted completely, regardless of whether the commas are used as place holders, the default values (explained on pages 294-296 of the "Microsoft Excel Functions and Macros," versions 2.x manual) are used. There is no special case here for the omission of commas. That is, if the commas are included in the formula, with nothing in either of the slots, it is the same as having left the commas out. The following examples are equivalent:

         GET.CHART.ITEM(1)
         GET.CHART.ITEM(1,)
         GET.CHART.ITEM(1,,)
   

2. If the default for point_index is used, and no item on the active chart is selected, the macro containing this function will halt during execution with a macro error. The resulting cell will contain #VALUE!.

REFERENCES

"Microsoft Excel Function Reference," version 3.0, pages 105, 106

"Microsoft Excel Functions and Macros," version 2.x, pages 294-296