ChartData.BreakLink Method
Removes the link between the data for a chart and a Microsoft Excel workbook.
Namespace: Microsoft.Office.Interop.PowerPoint
Assembly: Microsoft.Office.Interop.PowerPoint (in Microsoft.Office.Interop.PowerPoint.dll)
Syntax
'Declaration
Sub BreakLink
'Usage
Dim instance As ChartData
instance.BreakLink()
void BreakLink()
Remarks
Calling this method sets the IsLinked property of the ChartData object to False.
Examples
The following example removes the link between the ChartData object for the first chart in the active document and the Microsoft Excel workbook that provided the data for the chart.
With ActivePresentation.Slides(1).Shapes(1)
If .HasChart Then
.Chart.ChartData.Activate
.Chart.ChartData.BreakLinkEnd If
End With