![]() |
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 |
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 |
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