View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Greg Glynn Greg Glynn is offline
external usenet poster
 
Posts: 137
Default 2-line title on a xy line plot

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.

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