Microsoft KB Archive/51385

From BetaArchive Wiki

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



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.