Microsoft KB Archive/47762

Using Get.Formula with Charts in Excel PSS ID Number: Q47762 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.x 3.00

WINDOWS

Summary:

When used in conjunction with charts, the Get.Formula command has additional features that are not documented in the Microsoft Excel documentation. These features are as follows:

Formula Result ——- ——

=Get.Formula(“S#P#”) Returns the series formula for the specified point.

=Get.Formula(“Title”) Returns the formula used in creating the title. If no formula is used, this returns a blank.

=Get.Formula(“Text Axis 1”) Returns the formula used in creating the value axis label. It returns blank if no formula is used.

=Get.Formula(“Text Axis 2”) Returns the formula used in creating the category axis label. It returns blank if no formula is used.

=Get.Formula(“Text S#P#”) Returns the formulas used in assigning a label to a specified point. It returns blank if no formula is used.

Copyright Microsoft Corporation 1993.