Table of contents
TOC
Collapse the table of content
Expand the table of content

ChartData.IsLinked Property (PowerPoint)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

True if the data for the chart is linked to an external Microsoft Excel workbook. Read-only Boolean.

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

See also

Concepts

ChartData Object

© 2018 Microsoft