Share via

HasChartSpaceTitle Property

  • Article

True if the specified chart workspace has a title. Read/write Boolean.

expression.HasChartSpaceTitle

expression   Required. An expression that returns a ChartSpace object.

Remarks

Setting this property to False causes the title to be deleted from the chart workspace. When this happens, all custom formatting is lost and must be reset if the property is subsequently set to True.

Example

This example sets the chart workspace title and positions the chart workspace legend on the left side of the workspace.

  Sub Format_ChartSpace()
    Dim chConstants

    Set chConstants = ChartSpace1.Constants

    ' Enable the title for the chartspace.
    ChartSpace1.HasChartSpaceTitle = True

    ' Set the chartspace title.
    ChartSpace1.ChartSpaceTitle.Caption = "Monthly Sales Data"

    ' Enable the legend for the chartspace.
    ChartSpace1.HasChartSpaceLegend = True

    ' Specify the position of the chartspace legend.
    ChartSpace1.ChartSpaceLegend.Position = chConstants.chLegendPositionLeft
End Sub