Microsoft KB Archive/59970

{| = Excel: Getting Information from Chart Formula Bar with a Macro =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q59970

SUMMARY
To return information such as the series formula, title, or text labels from a chart to a macro sheet in Microsoft Excel, use the GET.FORMULA function. The GET.FORMULA function for a chart returns the following results for each argument:

The Function                   Returns ---

GET.FORMULA(&quot;SnP1&quot;)            Series formula as text for series n   GET.FORMULA(&quot;Title&quot;)            Title of chart GET.FORMULA(&quot;Text n&quot;)          Unattached text n   GET.FORMULA(&quot;Text SnPm&quot;)        Attached text for series n point m For more information on GET.FORMULA, see page 110 in the &quot;Microsoft Excel Function Reference&quot; version 3.0 manual. If you are using Excel 2.20, see page 238 in the &quot;Microsoft Excel Functions and Macros&quot; version 2.2 manual. For more information on chart items, see Form 3 of the SELECT command on pages 211-212 in the &quot;Microsoft Excel Function Reference&quot; version 3.0 manual. If you are using Excel 2.20, see Form 2 of the SELECT command on pages 275-276 in the &quot;Microsoft Excel Functions and Macros&quot; version 2.2 manual.
 * }