wxAutoExcel  2.0.0
wxAutoExcel::wxExcelChartGroup Class Reference

Represents Microsoft Excel ChartGroup object. More...

Inheritance diagram for wxAutoExcel::wxExcelChartGroup:
wxAutoExcel::wxExcelObject

Public Member Functions

wxExcelCategoryCollection CategoryCollection ()
 Returns an object that represents a collection of all of the visible categories (a CategoryCollection collection) in the chart group. More...
 
wxExcelCategoryCollection FullCategoryCollection ()
 Returns an object that represents a collection of all of the visible and filtered categories (a CategoryCollection collection) in the chart group. More...
 
wxExcelSeriesCollection SeriesCollection ()
 Returns an object that represents either a single series (a Series object) or a collection of all the series (a SeriesCollection collection) in the chart or chart group. More...
 
XlAxisGroup GetAxisGroup ()
 Returns an XlAxisGroup value that represents the type of axis group. More...
 
long GetBinsCountValue ()
 Specifies the number of bins in the histogram chart. More...
 
void SetBinsCountValue (long value)
 Specifies the number of bins in the histogram chart. More...
 
bool GetBinsOverflowEnabled ()
 Specifies whether a bin for values above the BinsOverflowValue is enabled. More...
 
void SetBinsOverflowEnabled (bool enabled)
 Specifies whether a bin for values above the BinsOverflowValue is enabled. More...
 
double GetBinsOverflowValue ()
 If an BinsOverflowEnabled is True, specifies the value above which an overflow bin is displayed. More...
 
void SetBinsOverflowValue (double value)
 If an BinsOverflowEnabled is True, specifies the value above which an overflow bin is displayed. More...
 
XlBinsType GetBinsType ()
 Specifies how the horizontal axis of the histogram chart is formatted, by bins type. More...
 
void SetBinsType (XlBinsType type)
 Specifies how the horizontal axis of the histogram chart is formatted, by bins type. More...
 
bool GetBinsUnderflowEnabled ()
 Specifies whether a bin for values below the BinsUnderflowValue is enabled. More...
 
void SetBinsUnderflowEnabled (bool enabled)
 Specifies whether a bin for values below the BinsUnderflowValue is enabled. More...
 
double GetBinsUnderflowValue ()
 If an BinsUnderflowEnabled is True, specifies the value below which an underflow bin is displayed. More...
 
void SetBinsUnderflowValue (double value)
 If an BinsUnderflowEnabled is True, specifies the value below which an underflow bin is displayed. More...
 
double GetBinWidthValue ()
 Specifies the number of points in each range. More...
 
void SetBinWidthValue (double value)
 Specifies the number of points in each range. More...
 
long GetBubbleScale ()
 Returns the scale factor for bubbles in the specified chart group. More...
 
void SetBubbleScale (long bubbleScale)
 Sets the scale factor for bubbles in the specified chart group. More...
 
long GetDoughnutHoleSize ()
 Returns the size of the hole in a doughnut chart group. More...
 
wxExcelDownBars GetDownBars ()
 Returns a DownBars object that represents the down bars on a line chart. More...
 
wxExcelDropLines GetDropLines ()
 Returns a DropLines object that represents the drop lines for a series on a line chart or area chart. More...
 
long GetFirstSliceAngle ()
 Returns the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). More...
 
void SetFirstSliceAngle (long firstSliceAngle)
 Sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical). More...
 
long GetGapWidth ()
 Bar and Column charts: Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. More...
 
void SetGapWidth (long gapWidth)
 Bar and Column charts: Returns or sets the space between bar or column clusters, as a percentage of the bar or column width. More...
 
bool GetHas3DShading ()
 True if the chart group has three-dimensional shading. More...
 
void SetHas3DShading (bool has3DShading)
 True if the chart group has three-dimensional shading. More...
 
bool GetHasDropLines ()
 True if the line chart or area chart has drop lines. More...
 
void SetHasDropLines (bool hasDropLines)
 True if the line chart or area chart has drop lines. More...
 
bool GetHasHiLoLines ()
 True if the line chart has high-low lines. More...
 
void SetHasHiLoLines (bool hasHiLoLines)
 True if the line chart has high-low lines. More...
 
bool GetHasRadarAxisLabels ()
 True if a radar chart has axis labels. More...
 
void SetHasRadarAxisLabels (bool hasRadarAxisLabels)
 True if a radar chart has axis labels. More...
 
bool GetHasSeriesLines ()
 True if a stacked column chart or bar chart has series lines or if a Pie of Pie chart or Bar of Pie chart has connector lines between the two sections. More...
 
void SetHasSeriesLines (bool hasSeriesLines)
 True if a stacked column chart or bar chart has series lines or if a Pie of Pie chart or Bar of Pie chart has connector lines between the two sections. More...
 
bool GetHasUpDownBars ()
 True if a line chart has up and down bars. More...
 
void SetHasUpDownBars (bool hasUpDownBars)
 True if a line chart has up and down bars. More...
 
wxExcelHiLoLines GetHiLoLines ()
 Returns a HiLoLines object that represents the high-low lines for a series on a line chart. More...
 
long GetIndex ()
 Returns a Long value that represents the index number of the object within the collection of similar objects. More...
 
long GetOverlap ()
 Specifies how bars and columns are positioned. More...
 
void SetOverlap (long overlap)
 Specifies how bars and columns are positioned. More...
 
wxExcelTickLabels GetRadarAxisLabels ()
 Returns a TickLabels object that represents the radar axis labels for the specified chart group. More...
 
long GetSecondPlotSize ()
 Returns the size of the secondary section of either a pie of pie chart or a bar of pie chart, as a percentage of the size of the primary pie. More...
 
void SetSecondPlotSize (long secondPlotSize)
 Sets the size of the secondary section of either a pie of pie chart or a bar of pie chart, as a percentage of the size of the primary pie. More...
 
wxExcelSeriesLines GetSeriesLines ()
 Returns a SeriesLines object that represents the series lines for a 2-D stacked bar, 2-D stacked column, pie of pie, or bar of pie chart. More...
 
bool GetShowNegativeBubbles ()
 True if negative bubbles are shown for the chart group. More...
 
void SetShowNegativeBubbles (bool showNegativeBubbles)
 True if negative bubbles are shown for the chart group. More...
 
XlSizeRepresents GetSizeRepresents ()
 Returns what the bubble size represents on a bubble chart. More...
 
void SetSizeRepresents (XlSizeRepresents sizeRepresents)
 Sets what the bubble size represents on a bubble chart. More...
 
XlChartSplitType GetSplitType ()
 Returns the way the two sections of either a pie of pie chart or a bar of pie chart are split. More...
 
void SetSplitType (XlChartSplitType splitType)
 Sets the way the two sections of either a pie of pie chart or a bar of pie chart are split. More...
 
double GetSplitValue ()
 Returns the threshold value separating the two sections of either a pie of pie chart or a bar of pie chart. More...
 
void SetSplitValue (double splitValue)
 Sets the threshold value separating the two sections of either a pie of pie chart or a bar of pie chart. More...
 
wxExcelUpBars GetUpBars ()
 Returns an UpBars object that represents the up bars on a line chart. More...
 
bool GetVaryByCategories ()
 True if Microsoft Excel assigns a different color or pattern to each data marker. More...
 
void SetVaryByCategories (bool varyByCategories)
 True if Microsoft Excel assigns a different color or pattern to each data marker. More...
 
virtual wxString GetAutoExcelObjectName_ () const
 Returns "ChartGroup". More...
 
- Public Member Functions inherited from wxAutoExcel::wxExcelObject
bool IsOk_ () const
 Returns true if the object has a valid dispatch. More...
 
wxString GetAutomationObjectName_ (bool stripUnderscores=false) const
 Returns object name as provided by IDispatch->GetTypeInfo()->GetDocumentation(MEMBERID_NIL, &name, NULL, NULL, NULL). More...
 
wxSharedPtr< wxAutomationObject > GetAutomationObject_ ()
 Returns the underlying wxAutomationObject. More...
 
 operator bool () const
 Returns true if the object has a valid dispatch and its last automation call (if any), i.e. More...
 
WXLCID GetAutomationLCID_ () const
 Returns the locale identifier used in automation calls. More...
 
bool SetAutomationLCID_ (WXLCID lcid)
 Sets the locale identifier to be used in automation calls. More...
 
bool GetPropertyAndMethodNames_ (wxArrayString &propertyNames, wxArrayString &methodNames, bool includeHidden=false)
 Returns lists of property and method names the automation interface exposes. More...
 
bool GetUnimplementedObject_ (const wxString &name, wxAutomationObject &object)
 Helper function for receiving an automation object not implemented in wxAutoExcel, see FAQ on how to use. More...
 

Additional Inherited Members

- Public Types inherited from wxAutoExcel::wxExcelObject
enum  ErrorFlags {
  Err_DoNothing = 0 , Err_LogOnInvalidDispatch = 1 , Err_AssertOnInvalidDispatch = 1 << 1 , Err_ThrowOnInvalidDispatch = 1 << 2 ,
  Err_LogOnInvalidArgument = 1 << 3 , Err_AssertOnInvalidArgument = 1 << 4 , Err_ThrowOnInvalidArgument = 1 << 5 , Err_LogOnFailedInvoke = 1 << 6 ,
  Err_AssertOnFailedInvoke = 1 << 7 , Err_ThrowOnFailedInvoke = 1 << 8 , Err_LogOnInvalidReturnType = 1 << 9 , Err_AssertOnInvalidReturnType = 1 << 10 ,
  Err_ThrowOnInvalidReturnType = 1 << 11 , Err_LogOnOtherError = 1 << 12 , Err_AssertOnOtherError = 1 << 13 , Err_ThrowOnOtherError = 1 << 14
}
 Flags affecting the behaviour of wxExcelObject and its descendants when an error occurs during accessing an Excel object property or calling its method. More...
 
- Static Public Member Functions inherited from wxAutoExcel::wxExcelObject
static unsigned GetErrorMode_ ()
 Sets the error mode to the combination of wxExcelObject::ErrorFlags. More...
 
static void SetErrorMode_ (unsigned mode)
 Sets the error mode as the combination of wxExcelObject::ErrorFlags. More...
 
static bool GetUnimplementedCollectionItem_ (wxAutomationObject &collection, const long index, wxAutomationObject &item, bool asProperty)
 Helper function for obtaining an item from MS Excel collection not implemented in wxAutoExcel, see FAQ on how to use. More...
 

Detailed Description

Represents Microsoft Excel ChartGroup object.

Member Function Documentation

◆ CategoryCollection()

wxExcelCategoryCollection wxAutoExcel::wxExcelChartGroup::CategoryCollection ( )

Returns an object that represents a collection of all of the visible categories (a CategoryCollection collection) in the chart group.

MSDN documentation for ChartGroup.CategoryCollection.

◆ FullCategoryCollection()

wxExcelCategoryCollection wxAutoExcel::wxExcelChartGroup::FullCategoryCollection ( )

Returns an object that represents a collection of all of the visible and filtered categories (a CategoryCollection collection) in the chart group.

MSDN documentation for ChartGroup.FullCategoryCollection.

◆ SeriesCollection()

wxExcelSeriesCollection wxAutoExcel::wxExcelChartGroup::SeriesCollection ( )

Returns an object that represents either a single series (a Series object) or a collection of all the series (a SeriesCollection collection) in the chart or chart group.

MSDN documentation for ChartGroup.SeriesCollection.

◆ GetAxisGroup()

XlAxisGroup wxAutoExcel::wxExcelChartGroup::GetAxisGroup ( )

Returns an XlAxisGroup value that represents the type of axis group.

MSDN documentation for ChartGroup.AxisGroup.

◆ GetBinsCountValue()

long wxAutoExcel::wxExcelChartGroup::GetBinsCountValue ( )

Specifies the number of bins in the histogram chart.

Since Excel 2016.

MSDN documentation for ChartGroup.BinsCountValue.

◆ SetBinsCountValue()

void wxAutoExcel::wxExcelChartGroup::SetBinsCountValue ( long  value)

Specifies the number of bins in the histogram chart.

Since Excel 2016.

MSDN documentation for ChartGroup.BinsCountValue.

◆ GetBinsOverflowEnabled()

bool wxAutoExcel::wxExcelChartGroup::GetBinsOverflowEnabled ( )

Specifies whether a bin for values above the BinsOverflowValue is enabled.

Since Excel 2016.

MSDN documentation for ChartGroup.BinsOverflowEnabled.

◆ SetBinsOverflowEnabled()

void wxAutoExcel::wxExcelChartGroup::SetBinsOverflowEnabled ( bool  enabled)

Specifies whether a bin for values above the BinsOverflowValue is enabled.

Since Excel 2016.

MSDN documentation for ChartGroup.BinsOverflowEnabled.

◆ GetBinsOverflowValue()

double wxAutoExcel::wxExcelChartGroup::GetBinsOverflowValue ( )

If an BinsOverflowEnabled is True, specifies the value above which an overflow bin is displayed.

Since Excel 2016.

MSDN documentation for ChartGroup.BinsOverflowValue.

◆ SetBinsOverflowValue()

void wxAutoExcel::wxExcelChartGroup::SetBinsOverflowValue ( double  value)

If an BinsOverflowEnabled is True, specifies the value above which an overflow bin is displayed.

Since Excel 2016.

MSDN documentation for ChartGroup.BinsOverflowValue.

◆ GetBinsType()

XlBinsType wxAutoExcel::wxExcelChartGroup::GetBinsType ( )

Specifies how the horizontal axis of the histogram chart is formatted, by bins type.

Since Excel 2016.

MSDN documentation for ChartGroup.BinsOverflowValue.

◆ SetBinsType()

void wxAutoExcel::wxExcelChartGroup::SetBinsType ( XlBinsType  type)

Specifies how the horizontal axis of the histogram chart is formatted, by bins type.

Since Excel 2016.

MSDN documentation for ChartGroup.BinsOverflowValue.

◆ GetBinsUnderflowEnabled()

bool wxAutoExcel::wxExcelChartGroup::GetBinsUnderflowEnabled ( )

Specifies whether a bin for values below the BinsUnderflowValue is enabled.

Since Excel 2016.

MSDN documentation for ChartGroup.BinsUnderflowEnabled.

◆ SetBinsUnderflowEnabled()

void wxAutoExcel::wxExcelChartGroup::SetBinsUnderflowEnabled ( bool  enabled)

Specifies whether a bin for values below the BinsUnderflowValue is enabled.

Since Excel 2016.

MSDN documentation for ChartGroup.BinsUnderflowEnabled.

◆ GetBinsUnderflowValue()

double wxAutoExcel::wxExcelChartGroup::GetBinsUnderflowValue ( )

If an BinsUnderflowEnabled is True, specifies the value below which an underflow bin is displayed.

Since Excel 2016.

MSDN documentation for ChartGroup.BinsUnderflowValue.

◆ SetBinsUnderflowValue()

void wxAutoExcel::wxExcelChartGroup::SetBinsUnderflowValue ( double  value)

If an BinsUnderflowEnabled is True, specifies the value below which an underflow bin is displayed.

Since Excel 2016.

MSDN documentation for ChartGroup.BinsUnderflowValue.

◆ GetBinWidthValue()

double wxAutoExcel::wxExcelChartGroup::GetBinWidthValue ( )

Specifies the number of points in each range.

Since Excel 2016.

MSDN documentation for ChartGroup.BinWidthValue.

◆ SetBinWidthValue()

void wxAutoExcel::wxExcelChartGroup::SetBinWidthValue ( double  value)

Specifies the number of points in each range.

Since Excel 2016.

MSDN documentation for ChartGroup.BinWidthValue.

◆ GetBubbleScale()

long wxAutoExcel::wxExcelChartGroup::GetBubbleScale ( )

Returns the scale factor for bubbles in the specified chart group.

Can be an integer value from 0 (zero) to 300, corresponding to a percentage of the default size. Applies only to bubble charts.

MSDN documentation for ChartGroup.BubbleScale.

◆ SetBubbleScale()

void wxAutoExcel::wxExcelChartGroup::SetBubbleScale ( long  bubbleScale)

Sets the scale factor for bubbles in the specified chart group.

Can be an integer value from 0 (zero) to 300, corresponding to a percentage of the default size. Applies only to bubble charts.

MSDN documentation for ChartGroup.BubbleScale.

◆ GetDoughnutHoleSize()

long wxAutoExcel::wxExcelChartGroup::GetDoughnutHoleSize ( )

Returns the size of the hole in a doughnut chart group.

The hole size is expressed as a percentage of the chart size, between 10 and 90 percent.

MSDN documentation for ChartGroup.DoughnutHoleSize.

◆ GetDownBars()

wxExcelDownBars wxAutoExcel::wxExcelChartGroup::GetDownBars ( )

Returns a DownBars object that represents the down bars on a line chart.

Applies only to line charts.

MSDN documentation for ChartGroup.DownBars.

◆ GetDropLines()

wxExcelDropLines wxAutoExcel::wxExcelChartGroup::GetDropLines ( )

Returns a DropLines object that represents the drop lines for a series on a line chart or area chart.

Applies only to line charts or area charts.

MSDN documentation for ChartGroup.DropLines.

◆ GetFirstSliceAngle()

long wxAutoExcel::wxExcelChartGroup::GetFirstSliceAngle ( )

Returns the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical).

Applies only to pie, 3-D pie, and doughnut charts. Can be a value from 0 through 360.

MSDN documentation for ChartGroup.FirstSliceAngle.

◆ SetFirstSliceAngle()

void wxAutoExcel::wxExcelChartGroup::SetFirstSliceAngle ( long  firstSliceAngle)

Sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical).

Applies only to pie, 3-D pie, and doughnut charts. Can be a value from 0 through 360.

MSDN documentation for ChartGroup.FirstSliceAngle.

◆ GetGapWidth()

long wxAutoExcel::wxExcelChartGroup::GetGapWidth ( )

Bar and Column charts: Returns or sets the space between bar or column clusters, as a percentage of the bar or column width.

Pie of Pie and Bar of Pie charts: Returns or sets the space between the primary and secondary sections of the chart.

MSDN documentation for ChartGroup.GapWidth.

◆ SetGapWidth()

void wxAutoExcel::wxExcelChartGroup::SetGapWidth ( long  gapWidth)

Bar and Column charts: Returns or sets the space between bar or column clusters, as a percentage of the bar or column width.

Pie of Pie and Bar of Pie charts: Returns or sets the space between the primary and secondary sections of the chart.

MSDN documentation for ChartGroup.GapWidth.

◆ GetHas3DShading()

bool wxAutoExcel::wxExcelChartGroup::GetHas3DShading ( )

True if the chart group has three-dimensional shading.

This property only applies to surface charts and will return a run-time error if you try to set it to a non-surface chart.

MSDN documentation for ChartGroup.Has3DShading.

◆ SetHas3DShading()

void wxAutoExcel::wxExcelChartGroup::SetHas3DShading ( bool  has3DShading)

True if the chart group has three-dimensional shading.

This property only applies to surface charts and will return a run-time error if you try to set it to a non-surface chart.

MSDN documentation for ChartGroup.Has3DShading.

◆ GetHasDropLines()

bool wxAutoExcel::wxExcelChartGroup::GetHasDropLines ( )

True if the line chart or area chart has drop lines.

Applies only to line and area charts.

MSDN documentation for ChartGroup.HasDropLines.

◆ SetHasDropLines()

void wxAutoExcel::wxExcelChartGroup::SetHasDropLines ( bool  hasDropLines)

True if the line chart or area chart has drop lines.

Applies only to line and area charts.

MSDN documentation for ChartGroup.HasDropLines.

◆ GetHasHiLoLines()

bool wxAutoExcel::wxExcelChartGroup::GetHasHiLoLines ( )

True if the line chart has high-low lines.

Applies only to line charts.

MSDN documentation for ChartGroup.HasHiLoLines.

◆ SetHasHiLoLines()

void wxAutoExcel::wxExcelChartGroup::SetHasHiLoLines ( bool  hasHiLoLines)

True if the line chart has high-low lines.

Applies only to line charts.

MSDN documentation for ChartGroup.HasHiLoLines.

◆ GetHasRadarAxisLabels()

bool wxAutoExcel::wxExcelChartGroup::GetHasRadarAxisLabels ( )

True if a radar chart has axis labels.

Applies only to radar charts.

MSDN documentation for ChartGroup.HasRadarAxisLabels.

◆ SetHasRadarAxisLabels()

void wxAutoExcel::wxExcelChartGroup::SetHasRadarAxisLabels ( bool  hasRadarAxisLabels)

True if a radar chart has axis labels.

Applies only to radar charts.

MSDN documentation for ChartGroup.HasRadarAxisLabels.

◆ GetHasSeriesLines()

bool wxAutoExcel::wxExcelChartGroup::GetHasSeriesLines ( )

True if a stacked column chart or bar chart has series lines or if a Pie of Pie chart or Bar of Pie chart has connector lines between the two sections.

Applies only to 2-D stacked bar, 2-D stacked column, pie of pie, or bar of pie charts.

MSDN documentation for ChartGroup.HasSeriesLines.

◆ SetHasSeriesLines()

void wxAutoExcel::wxExcelChartGroup::SetHasSeriesLines ( bool  hasSeriesLines)

True if a stacked column chart or bar chart has series lines or if a Pie of Pie chart or Bar of Pie chart has connector lines between the two sections.

Applies only to 2-D stacked bar, 2-D stacked column, pie of pie, or bar of pie charts.

MSDN documentation for ChartGroup.HasSeriesLines.

◆ GetHasUpDownBars()

bool wxAutoExcel::wxExcelChartGroup::GetHasUpDownBars ( )

True if a line chart has up and down bars.

Applies only to line charts.

MSDN documentation for ChartGroup.HasUpDownBars.

◆ SetHasUpDownBars()

void wxAutoExcel::wxExcelChartGroup::SetHasUpDownBars ( bool  hasUpDownBars)

True if a line chart has up and down bars.

Applies only to line charts.

MSDN documentation for ChartGroup.HasUpDownBars.

◆ GetHiLoLines()

wxExcelHiLoLines wxAutoExcel::wxExcelChartGroup::GetHiLoLines ( )

Returns a HiLoLines object that represents the high-low lines for a series on a line chart.

Applies only to line charts.

MSDN documentation for ChartGroup.HiLoLines.

◆ GetIndex()

long wxAutoExcel::wxExcelChartGroup::GetIndex ( )

Returns a Long value that represents the index number of the object within the collection of similar objects.

MSDN documentation for ChartGroup.Index.

◆ GetOverlap()

long wxAutoExcel::wxExcelChartGroup::GetOverlap ( )

Specifies how bars and columns are positioned.

Can be a value between – 100 and 100. Applies only to 2-D bar and 2-D column charts.

MSDN documentation for ChartGroup.Overlap.

◆ SetOverlap()

void wxAutoExcel::wxExcelChartGroup::SetOverlap ( long  overlap)

Specifies how bars and columns are positioned.

Can be a value between – 100 and 100. Applies only to 2-D bar and 2-D column charts.

MSDN documentation for ChartGroup.Overlap.

◆ GetRadarAxisLabels()

wxExcelTickLabels wxAutoExcel::wxExcelChartGroup::GetRadarAxisLabels ( )

Returns a TickLabels object that represents the radar axis labels for the specified chart group.

MSDN documentation for ChartGroup.RadarAxisLabels.

◆ GetSecondPlotSize()

long wxAutoExcel::wxExcelChartGroup::GetSecondPlotSize ( )

Returns the size of the secondary section of either a pie of pie chart or a bar of pie chart, as a percentage of the size of the primary pie.

Can be a value from 5 to 200.

MSDN documentation for ChartGroup.SecondPlotSize.

◆ SetSecondPlotSize()

void wxAutoExcel::wxExcelChartGroup::SetSecondPlotSize ( long  secondPlotSize)

Sets the size of the secondary section of either a pie of pie chart or a bar of pie chart, as a percentage of the size of the primary pie.

Can be a value from 5 to 200.

MSDN documentation for ChartGroup.SecondPlotSize.

◆ GetSeriesLines()

wxExcelSeriesLines wxAutoExcel::wxExcelChartGroup::GetSeriesLines ( )

Returns a SeriesLines object that represents the series lines for a 2-D stacked bar, 2-D stacked column, pie of pie, or bar of pie chart.

MSDN documentation for ChartGroup.SeriesLines.

◆ GetShowNegativeBubbles()

bool wxAutoExcel::wxExcelChartGroup::GetShowNegativeBubbles ( )

True if negative bubbles are shown for the chart group.

Valid only for bubble charts.

MSDN documentation for ChartGroup.ShowNegativeBubbles.

◆ SetShowNegativeBubbles()

void wxAutoExcel::wxExcelChartGroup::SetShowNegativeBubbles ( bool  showNegativeBubbles)

True if negative bubbles are shown for the chart group.

Valid only for bubble charts.

MSDN documentation for ChartGroup.ShowNegativeBubbles.

◆ GetSizeRepresents()

XlSizeRepresents wxAutoExcel::wxExcelChartGroup::GetSizeRepresents ( )

Returns what the bubble size represents on a bubble chart.

Can be either of the following XlSizeRepresents constants: xlSizeIsArea or xlSizeIsWidth.

MSDN documentation for ChartGroup.SizeRepresents.

◆ SetSizeRepresents()

void wxAutoExcel::wxExcelChartGroup::SetSizeRepresents ( XlSizeRepresents  sizeRepresents)

Sets what the bubble size represents on a bubble chart.

Can be either of the following XlSizeRepresents constants: xlSizeIsArea or xlSizeIsWidth.

MSDN documentation for ChartGroup.SizeRepresents.

◆ GetSplitType()

XlChartSplitType wxAutoExcel::wxExcelChartGroup::GetSplitType ( )

Returns the way the two sections of either a pie of pie chart or a bar of pie chart are split.

Read/write XlChartSplitType.

MSDN documentation for ChartGroup.SplitType.

◆ SetSplitType()

void wxAutoExcel::wxExcelChartGroup::SetSplitType ( XlChartSplitType  splitType)

Sets the way the two sections of either a pie of pie chart or a bar of pie chart are split.

Read/write XlChartSplitType.

MSDN documentation for ChartGroup.SplitType.

◆ GetSplitValue()

double wxAutoExcel::wxExcelChartGroup::GetSplitValue ( )

Returns the threshold value separating the two sections of either a pie of pie chart or a bar of pie chart.

Read/write Variant.

MSDN documentation for ChartGroup.SplitValue.

◆ SetSplitValue()

void wxAutoExcel::wxExcelChartGroup::SetSplitValue ( double  splitValue)

Sets the threshold value separating the two sections of either a pie of pie chart or a bar of pie chart.

Read/write Variant.

MSDN documentation for ChartGroup.SplitValue.

◆ GetUpBars()

wxExcelUpBars wxAutoExcel::wxExcelChartGroup::GetUpBars ( )

Returns an UpBars object that represents the up bars on a line chart.

Applies only to line charts.

MSDN documentation for ChartGroup.UpBars.

◆ GetVaryByCategories()

bool wxAutoExcel::wxExcelChartGroup::GetVaryByCategories ( )

True if Microsoft Excel assigns a different color or pattern to each data marker.

The chart must contain only one series.

MSDN documentation for ChartGroup.VaryByCategories.

◆ SetVaryByCategories()

void wxAutoExcel::wxExcelChartGroup::SetVaryByCategories ( bool  varyByCategories)

True if Microsoft Excel assigns a different color or pattern to each data marker.

The chart must contain only one series.

MSDN documentation for ChartGroup.VaryByCategories.

◆ GetAutoExcelObjectName_()

virtual wxString wxAutoExcel::wxExcelChartGroup::GetAutoExcelObjectName_ ( ) const
inlinevirtual

Returns "ChartGroup".

Reimplemented from wxAutoExcel::wxExcelObject.