Microsoft KB Archive/38361

-

{| 2.x 3.00 4.00 4.00a 5.00 | 2.20 2.21 3.00 WINDOWS                 | OS/2 kbusage The information in this article applies to:
 * width="100%"|


 * Microsoft Excel for Windows, version 2.x, 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for OS/2 versions 2.2, 2.21, 3.0

SUMMARY
The following is a macro that allows you to enter a title for a chart created by a macro or enter the title in an interactive manner:

A1: =ACTIVATE(&quot;chart1&quot;) A2: =INPUT(&quot;Enter title of chart&quot;,2) A3: =ATTACH.TEXT(1) A4: =SELECT(&quot;Title&quot;) A5: =FORMULA(&quot;=&quot;&&quot;&quot;&quot;&quot;&DEREF(A2)&&quot;&quot;&quot;&quot;) A6: =SELECT(&quot;&quot;) A7: =RETURN Note: there are four double quotation marks (&quot;) in each set before and after the DEREF(A2) statement.
 * }

-

Last reviewed: November 4, 1994

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.