Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
VBA for chart title issue
I have the following macro to modify a chart title if "mypattern" is changed.
I'm having one problem though. At the place where I have vbnewline in the mypattern code, it appears that it's displaying 2 line breaks. How do I fix this? Thanks, Barb Reinhardt Public Sub SetChartTitle(WS As Worksheet, mypattern As String) Dim objCht As ChartObject mypattern = WS.Name & vbNewLine & "Division Target " & mypattern & " Days" For Each objCht In WS.ChartObjects With objCht .Chart.ChartTitle.Text = mypattern End With Next objCht End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedded Chart Versus Chart - ShowDetail Issue | Charts and Charting in Excel | |||
Longer Chart Title? | Charts and Charting in Excel | |||
Excel chart - how to assign the file name in the chart title? | Charts and Charting in Excel | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel | |||
Chart Title | Charts and Charting in Excel |