ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   2-line title on a xy line plot (https://www.excelbanter.com/excel-programming/367901-2-line-title-xy-line-plot.html)

[email protected]

2-line title on a xy line plot
 
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

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



[email protected]

2-line title on a xy line plot
 
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.

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




All times are GMT +1. The time now is 05:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com