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

Last reviewed: November 1, 1994
Article ID: Q52040
The information in this article applies to:
  • 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


KBCategory: kbother
KBSubcategory:

Additional reference words: 5.00 2.0 2.00 2.01 2.1 2.10 2.2 2.20 3.0 3.00
4.0 4.00


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 1, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.