| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Plot lines between plot points on a line chart | Charts and Charting in Excel | |||
| How to convert a dotted line to a solid line in a line graph | Charts and Charting in Excel | |||
| How to add a line plot onto a stacked plot in Excel | Charts and Charting in Excel | |||
| Macro problem on, Yellowed line - previous line or next line. | Excel Programming | |||
| Workbook Title Line | Excel Programming | |||
Hybrid Mode
