Edit

Share via

ChartData.IsLinked property (PowerPoint)

  • Article

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

ChartData Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.