ChartData.IsLinked Property (PowerPoint)
True if the data for the chart is linked to an external Microsoft Excel workbook. Read-only Boolean.
Version Information
Version Added: PowerPoint 2007
Syntax
expression .IsLinked
expression A variable that represents a ChartData object.
Remarks
Using the BreakLink method to remove the link to an Excel workbook sets this property to False.
Example
Note
Although the following code applies to Microsoft Word, you can readily modify it to apply to PowerPoint.
The following example verifies whether the data for the first chart in the active document is linked to an external Excel workbook. If the data for the chart is linked, the example then uses the BreakLink method to remove the link. If the data for the chart is not linked, the example uses the Activate method to display the embedded data for the chart.
With ActiveDocument.InlineShapes(1)
If .HasChart Then
With .Chart.ChartData
If .IsLinked Then
.BreakLink
Else
.Activate
End If
End With
End If
End With