Table of contents
TOC
折叠目录
展开目录

Series.BubbleSizes 属性 (PowerPoint)Series.BubbleSizes Property (PowerPoint)

office 365 dev account|上次更新日期: 2018/3/13
|
2 参与人员

返回或设置 string 类型的值,引用包含 x 值、 y 值和气泡图大小数据的工作表单元格。读/写variant 类型的值Returns or sets a string that refers to the worksheet cells that contain the x-value, y-value, and size data for the bubble chart. Read/write Variant.

语法Syntax

表达式BubbleSizesexpression. BubbleSizes

表达式_一个表示Series对象的变量。_expression A variable that represents a Series object.

注解Remarks

在返回单元格引用时,它将返回以 A1 样式表示法描述单元格的字符串。若要为气泡图设置大小数据,则必须使用 R1C1 样式表示法。When you return the cell reference, it will return a string that describes the cells in A1-style notation. To set the size data for the bubble chart, you must use R1C1-style notation.

请注意 此属性仅适用于气泡图。Note This property applies only to bubble charts.

示例Example

请注意 尽管下面的代码适用于 Microsoft Word 中,您可以随时修改将其应用到 PowerPoint。Note Although the following code applies to Microsoft Word, you can readily modify it to apply to PowerPoint.

以下示例演示对单元格的引用,这些单元格包含活动文档中第一个图表的气泡图 x 值、y 值和大小数据。The following example displays the cell reference for the cells that contain the bubble chart x-value, y-value, and size data for the first chart in the active document.

With ActiveDocument.InlineShapes(1)

    If .HasChart Then

        MsgBox .Chart.SeriesCollection(1).BubbleSizes

    End If

End With

请注意 尽管下面的代码适用于 Microsoft Word 中,您可以随时修改将其应用到 PowerPoint。Note Although the following code applies to Microsoft Word, you can readily modify it to apply to PowerPoint.

此示例说明如何使用 R1C1 样式表示法设置该属性。This example shows how to set this property using R1C1-style notation.

With ActiveDocument.InlineShapes(3)
    If .HasChart Then
        .Chart.SeriesCollection(1). _
            BubbleSizes = "Sheet1!r2c3:r5c3"
    End If
End With

另请参阅See also

概念Concepts

Series 对象Series Object

© 2018 Microsoft