Function Reference

_XLChart_BubbleGroupSet

Set properties of a bubble chart group.

#Include <ExcelChart.au3>
_XLChart_BubbleGroupSet($oObject[, $iBubbleScale = Default[, $iSizeRepresents = Default[, $ibShowNegativeBubbles = Default]]])

 

Parameters

$oObject Chart group for which the properties should be set
$iBubbleScale Optional: Value from 0 to 300, corresponding to a percentage of the default size (default = Default)
$iSizeRepresents Optional: Sets what the bubble size represents. Can be one of the XlSizeRepresents enumeration (default = Default)
$ibShowNegativeBubbles Optional: True if negative bubbles are shown for the chart group (default = Default)

 

Return Value

Success: Returns 1
Failure: Returns 0 and sets @error:
    1 - $oObject is not an object
    2 - $iBubbleScale is not an integer
    3 - $iSizeRepresents is not an integer
    4 - $ibShowNegativeBubbles is not boolean

 

Remarks

A chart contains one or more chart groups, each chart group contains one or more series, and
each series contains one or more points.

You have to pass an item of the ChartGroups collection

 

Related

 

Example


#AutoIt3Wrapper_UseX64=n
#AutoIt3Wrapper_AU3Check_Parameters= -d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6
#AutoIt3Wrapper_AU3Check_Stop_OnWarning=Y
#include-once
#include <ExcelChart.au3>

; *****************************************************************************
; Create example environment
; *****************************************************************************
Global $aExcel = _XLChart_Example(True, 0, -1, -1, -1)
If @error = 2 Then Exit MsgBox(16, "Excel Chart Example Script", "The installed Excel version is not supported by this UDF!" & @CRLF & "Version must be >= 12 (Excel 2007).")
If @error <> 0 Then Exit MsgBox(16, "Excel Chart Example Script", "Error " & @error & " returned by _XLChart_Example on line " & @ScriptLineNumber)
; Change chart 1 to a bubble chart
_XLChart_ChartSet($aExcel[1], $xlBubble)
If @error <> 0 Then Exit MsgBox(16, "Excel Chart Example Script", "Error " & @error & " returned by _XLChart_Example on line " & @ScriptLineNumber)

; *****************************************************************************
; Example 1
; Set the bubble scale
; *****************************************************************************
MsgBox(64, "Excel Chart Example Script", "Now changing chart 1 ..." & @CRLF & "Set the bubble scale")
_XLChart_BubbleGroupSet($aExcel[1].ChartGroups(1), 50)
If @error Then MsgBox(64, "Excel Chart Example Script", "Error " & @error & " returned by function '_XLChart_BubbleGroupSet' on line " & @ScriptLineNumber)