2-line title on a xy line plot

[[email protected]]

Is it possible to code a 2-line title into an XY line plot? I'd like
the lines to be different font sizes - the first larger than the
subtitle.

Any help is really appreciated.

Regards,

Mike

[Greg Glynn]

You can get two lines like this ( Using CHR$(10) )

ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartTitle.Characters.Text = "First Line Title" &
Chr(10) & "Second Line Title"

The font thing might be trickier.

[email protected] wrote:
> Is it possible to code a 2-line title into an XY line plot? I'd like
> the lines to be different font sizes - the first larger than the
> subtitle.
>
> Any help is really appreciated.
>
> Regards,
>
> Mike

[[email protected]]

Thanks Greg - That worked like a charm!

Mike
Greg Glynn wrote:
> You can get two lines like this ( Using CHR$(10) )
>
> ActiveSheet.ChartObjects("Chart 1").Activate
> ActiveChart.ChartTitle.Characters.Text = "First Line Title" &
> Chr(10) & "Second Line Title"
>
> The font thing might be trickier.
>
> [email protected] wrote:
> > Is it possible to code a 2-line title into an XY line plot? I'd like
> > the lines to be different font sizes - the first larger than the
> > subtitle.
> >
> > Any help is really appreciated.
> >
> > Regards,
> >
> > Mike