Microsoft KB Archive/47762

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.