Entering a Two-Line Chart Title from a Macro PSS ID Number: Q51385 Article last modified on 02-26-1993 PSS database name: W_eXceL
2.00 2.01 2.10 3.00 | 2.20 2.21 3.00
WINDOWS | OS/2
Summary:
To enter a two-line chart title from a macro, use the following code as an example:
A1: Title A2: =ACTIVATE(“Chart1”) A3: =ATTACH.TEXT(1) A4: =FORMULA(“=”“first line|second line”"") A5: =RETURN()
The vertical bar is created by pressing ALT+Keypad 0013. This enters the ANSI character 13, which is equivalent to using the CTRL+ENTER key combination.
Note: You must replace the formula in cell A4 with:
A4: =FORMULA(“=”“first line”&CHAR(13)&“second line”"")
for this to work with Excel version 3.0. Note the use of the double quotation marks (""), the ampersands (&), and the CHAR(13) function.
Additional reference words: 2.0 2.00 2.10 2.1 2.2 2.20 2.21 3.0 3.00
Copyright Microsoft Corporation 1993.