Sets the specified properties of a chart. The chart is created if it doesn't exist.
| Overload Name | Description |
|---|---|
| Area | Add or modify a Area chart. |
| AxisProperties | Set the properties of a chart axis. |
| Bar | Add or modify a Bar chart. |
| Column | Add or modify a Column chart. |
| Format | Set the format properties of a chart. |
| GroupProperties | Set the properties of a chart group. |
| LegendProperties | Set the properties of a chart's legend. |
| Line | Add or modify a Line chart. |
| Pie | Add or modify a Pie chart. |
| PointProperties | Set the properties of a chart point. |
| Remove | Remove a chart. |
| Select | Select a chart. |
| SeriesProperties | Set the properties of a chart series. |
| Stock | Add or modify a Stock chart. |
| TitleProperties | Set the properties of a chart's title. |
| XYScatter | Add or modify a XYScatter chart. |
Add or modify a Area chart.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| AreaChartType |
Select a chart-type.
Specify one of the following values or an arbitrary value:
<blank>AreaAreaStackedAreaStacked100
|
| DataRange | The address of the chart's data range. |
| SeriesOrientation |
Whether the chart's series are in row or column orientation.
Specify one of the following values or an arbitrary value:
<blank>ColumnsRows
|
| Title | The text for the chart's title. |
| HasLegend |
Whether to display the chart's legend.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| OnClickProcedure | The name of the procedure to execute when the chart is clicked. |
| OnDoubleClickProcedure | The name of the procedure to execute when the chart is double-clicked. |
| Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank>FreeFloatingMoveMoveAndSize
|
| Column | The column to put the Chart into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
| EndColumn | The column the will define the width of the chart. The Width argument can be used instead of this. |
| ColumnPoints | The position of the left edge of the Chart in points. If used with the Column argument then the two are added together. |
| Row | The row to put the Chart into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
| EndRow | The row the will define the height of the chart. The Height argument can be used instead of this. |
| RowPoints | The position of the top edge of the Chart in points. If used with the Row argument then the two are added together. |
| Width | The width of the Chart in points. The EndColumn argument can be used instead of this. |
| Height | The height of the Chart in points. The EndRow argument can be used instead of this. |
| LockAspectRatio |
Whether the chart's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
Set the properties of a chart axis.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| AxisType |
The type of the axis (readonly). Use AxisType along with AxisGroup to identify which Axis to modify.
Specify one of the following values or an arbitrary value:
<blank>CategoryValueSeries
|
| AxisGroup |
Specifies which axis group this series is plotted on.
Specify one of the following values or an arbitrary value:
<blank>PrimarySecondary
|
| AxisBetweenCategories |
Whether the value axis crosses between categories on the category axis.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| BaseUnit |
The base time unit for a category axis with a time-scale.
Specify one of the following values or an arbitrary value:
<blank>DaysMonthsYears
|
| BaseUnitIsAuto |
Whether the base unit is automatically set based on the category axis data.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CategoryType |
The scale type on a category axis.
Specify one of the following values or an arbitrary value:
<blank>AutomaticScaleCategoryScaleTimeScale
|
| AxisCrosses |
Where the other axis crosses this axis.
Specify one of the following values or an arbitrary value:
<blank>AutomaticCustomMaximumMinimum
|
| AxisCrossesAt | Custom (double) value where the other axis crosses this axis. |
| HasMajorGridlines |
Whether an axis has major gridlines.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| HasMinorGridlines |
Whether an axis has minor gridlines.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| MajorGridlinesColor | Select the color for the major gridlines's. |
| MajorGridlinesTransparency | From 0.0 to 1.0 (opaque to transparent). |
| MajorGridlinesVisible |
Whether the major gridlines are visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| MajorGridlinesWeight | The weight of the major gridlines, in points. |
| MajorTickMark |
The type of major tick marks on an axis.
Specify one of the following values or an arbitrary value:
<blank>NoneInsideOutsideCross
|
| MajorUnit | The major unit of an axis (double). |
| MajorUnitIsAuto |
Whether the major unit is automatically determined on an axis.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| MajorUnitScale |
The major time unit for a category axis with a time-scale.
Specify one of the following values or an arbitrary value:
<blank>DaysMonthsYears
|
| MaximumScale | The maximum scale value of an axis (double). |
| MaximumScaleIsAuto |
The maximum scale value of an axis.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| MinimumScale | The minimum scale value of an axis (double). |
| MinimumScaleIsAuto |
The minimum scale value of an axis.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ReversePlotOrder |
Whether the axis scale values are in reverse order.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ScaleType |
The scale type on a value axis.
Specify one of the following values or an arbitrary value:
<blank>LinearLogarithmic
|
| TickLabelPosition |
The tick label position on an axis.
Specify one of the following values or an arbitrary value:
<blank>NoneLowHighNextToAxis
|
| TickLabelsFontName | Font of the chart's tick-labels. |
| TickLabelsFontBold |
Whether the tick-labels are bolded.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| TickLabelsFontColor | Select the tick-labels font color. |
| TickLabelsFontColorIndex |
Excel color palette index to use for the tick-labels's Font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| TickLabelsFontItalic |
Whether the tick-labels are italicized.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| TickLabelsFontOutline |
Whether the tick-label fonts are outlined.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| TickLabelsFontShadow |
Whether the tick-labels have shadows.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| TickLabelsFontSize |
Font size of the chart's tick-labels.
Specify one of the following values or an arbitrary value:
<blank>689101112141618202122242628364872
|
| TickLabelsFontStrikeThrough |
Whether the tick-labels have strikes through them.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| TickLabelsFontSubscript |
Whether the tick-labels are subscripted.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| TickLabelsFontSuperscript |
Whether the tick-labels are superscripted.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| TickLabelsFontTintAndShade | Controls darkening (values between -1.0 and 0.0) or lightening (values between 0.0 and 1.0) of the underlying theme color. |
| TickLabelsFontUnderline |
None, Single, Double, SingelAccounting, DoubleAccounting.
Specify one of the following values or an arbitrary value:
<blank>SingleSingleAccountingDoubleDoubleAccountingNone
|
| TickLabelsNumberFormat |
Number format of the axis labels. Select number format from a list of format strings for numbers, or enter a valid string.
Specify one of the following values or an arbitrary value:
<blank>00.00#,##0#,##0.00#,##0_);(#,##0)#,##0_);[Red](#,##0)#,##0.00_);(#,##0.00)#,##0.00_);[Red](#,##0.00)_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
|
| TickLabelsNumberFormatLinked |
Whether the axis labels use the same number format as the cells that contain the data for the axis labels.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| TickLabelsOrientation | The text orientation of the axis labels, which may be from -90 to 90 degrees or one of the TickLabelOrientation constants. |
| TickLabelSpacing | The number of categories between each tick label on a category axis. |
| TickLabelSpacingIsAuto |
Whether the tick label spacing is automatically determined on an axis.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| TickMarkSpacing | The number of categories between each tick mark on a category axis. |
Add or modify a Bar chart.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| BarChartType |
Select a chart-type.
Specify one of the following values or an arbitrary value:
<blank>BarClusteredBarStackedBarStacked100
|
| DataRange | The address of the chart's data range. |
| SeriesOrientation |
Whether the chart's series are in row or column orientation.
Specify one of the following values or an arbitrary value:
<blank>ColumnsRows
|
| Title | The text for the chart's title. |
| HasLegend |
Whether to display the chart's legend.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| OnClickProcedure | The name of the procedure to execute when the chart is clicked. |
| OnDoubleClickProcedure | The name of the procedure to execute when the chart is double-clicked. |
| Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank>FreeFloatingMoveMoveAndSize
|
| Column | The column to put the Chart into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
| EndColumn | The column the will define the width of the chart. The Width argument can be used instead of this. |
| ColumnPoints | The position of the left edge of the Chart in points. If used with the Column argument then the two are added together. |
| Row | The row to put the Chart into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
| EndRow | The row the will define the height of the chart. The Height argument can be used instead of this. |
| RowPoints | The position of the top edge of the Chart in points. If used with the Row argument then the two are added together. |
| Width | The width of the Chart in points. The EndColumn argument can be used instead of this. |
| Height | The height of the Chart in points. The EndRow argument can be used instead of this. |
| LockAspectRatio |
Whether the chart's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
Add or modify a Column chart.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| ColumnChartType |
Select a chart-type.
Specify one of the following values or an arbitrary value:
<blank>ColumnClusteredColumnStackedColumnStacked100
|
| DataRange | The address of the chart's data range. |
| SeriesOrientation |
Whether the chart's series are in row or column orientation.
Specify one of the following values or an arbitrary value:
<blank>ColumnsRows
|
| Title | The text for the chart's title. |
| HasLegend |
Whether to display the chart's legend.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| OnClickProcedure | The name of the procedure to execute when the chart is clicked. |
| OnDoubleClickProcedure | The name of the procedure to execute when the chart is double-clicked. |
| Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank>FreeFloatingMoveMoveAndSize
|
| Column | The column to put the Chart into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
| EndColumn | The column the will define the width of the chart. The Width argument can be used instead of this. |
| ColumnPoints | The position of the left edge of the Chart in points. If used with the Column argument then the two are added together. |
| Row | The row to put the Chart into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
| EndRow | The row the will define the height of the chart. The Height argument can be used instead of this. |
| RowPoints | The position of the top edge of the Chart in points. If used with the Row argument then the two are added together. |
| Width | The width of the Chart in points. The EndColumn argument can be used instead of this. |
| Height | The height of the Chart in points. The EndRow argument can be used instead of this. |
| LockAspectRatio |
Whether the chart's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
Set the format properties of a chart.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| BorderColor | Select the color for the line forecolor. |
| BorderColorIndex |
Excel color palette index to use for the line forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| BorderTransparency | From 0.0 to 1.0 (opaque to transparent). |
| BorderVisible |
Whether the line is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| BorderWeight | The weight of the line, in points. |
| FillBackColor | Select the fill back color. |
| FillBackColorIndex |
Excel color palette index to use for the fill back color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| FillColor | Select the color for the fill's forecolor. |
| FillColorIndex |
Excel color palette index to use for the fill forecolor. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| FillTransparency | From 0.0 to 1.0 (opaque to transparent). |
| FillVisible |
Whether the fill is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontName | Select a font. |
| FontSize |
Select or specify a font size.
Specify one of the following values or an arbitrary value:
<blank>689101112141618202122242628364872
|
| FontColor | Select the font color. |
| FontColorIndex |
Excel color palette index to use for the font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| FontBold |
Whether the font is bolded.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontItalic |
Whether the font is italicized.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontOutline |
Whether the font is outlined.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontShadow |
Whether the font is shadowed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontStrikeThrough |
Whether to apply Font strikethrough.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontSubscript |
Whether the font is subscripted.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontSuperscript |
Whether the font is superscripted.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontTintAndShade | Specifies the TintAndShade of the font. Values between -1.0 and 0.0 darken, while values between 0.0 and 1.0 lighten the font color. |
| FontUnderline |
None, Single, Double, SingelAccounting, DoubleAccounting.
Specify one of the following values or an arbitrary value:
<blank>SingleSingleAccountingDoubleDoubleAccountingNone
|
Set the properties of a chart group.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| GroupIndex | The index of the chart group. This value is used to identify which chart group to modify. |
| BubbleScale | The percentage of the default bubble size to use for the size of bubbles on a bubble chart. |
| DoughnutHoleSize | The percentage of the chart size to use for the size of the hole in a doughnut chart. |
| DownBarsFillColor | The fill color of the group's DownBars. |
| DownBarsFillTransparency | The fill transparency of the group's DownBars. From 0.0 to 1.0 (opaque to transparent). |
| DownBarsFillVisible |
The fill visible of the group's DownBars.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DownBarsLineColor | The color of the group's SeriesLines DownBars. |
| DownBarsLineTransparency | The transparency of the group's SeriesLines DownBars. From 0.0 to 1.0 (opaque to transparent). |
| DownBarsLineVisible |
The visible of the group's SeriesLines DownBars.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DownBarsLineWeight | The weight of the group's SeriesLines DownBars. |
| DropLinesFillColor | The fill color of the group's DropLines. |
| DropLinesFillTransparency | The fill transparency of the group's DropLines. From 0.0 to 1.0 (opaque to transparent). |
| DropLinesFillVisible |
The fill visible of the group's DropLines.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DropLinesLineColor | The color of the group's SeriesLines DropLines. |
| DropLinesLineTransparency | The transparency of the group's SeriesLines DropLines. From 0.0 to 1.0 (opaque to transparent). |
| DropLinesLineVisible |
The visible of the group's SeriesLines DropLines.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DropLinesLineWeight | The weight of the group's SeriesLines DropLines. |
| FirstSliceAngle | The angle, in degrees, of the first slice in a pie or doughnut chart. |
| GapWidth | The distance between bars in a clustered bar chart as a percentage of the bar width, or the distance between each plotted section in a pie of pie chart. |
| Has3DShading |
Whether a surface chart has 3D shading.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| HasDropLines |
Whether a line or area chart has drop lines.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| HasHiLoLines |
Whether a line chart has high-low lines.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| HasRadarAxisLabels |
Whether a radar chart has axis labels.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| HasSeriesLines |
Whether a stacked bar or pie of pie chart has series lines.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| HasUpDownBars |
Whether a line chart has up and down bars.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| HiLoLinesFillColor | The fill color of the group's HiLoLines. |
| HiLoLinesFillTransparency | The fill transparency of the group's HiLoLines. From 0.0 to 1.0 (opaque to transparent). |
| HiLoLinesFillVisible |
The fill visible of the group's HiLoLines.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| HiLoLinesLineColor | The color of the group's SeriesLines HiLoLines. |
| HiLoLinesLineTransparency | The transparency of the group's SeriesLines HiLoLines. From 0.0 to 1.0 (opaque to transparent). |
| HiLoLinesLineVisible |
The visible of the group's SeriesLines HiLoLines.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| HiLoLinesLineWeight | The weight of the group's SeriesLines HiLoLines. |
| Overlap | The overlap or space between bars within a category as a percentage of the bar width.". |
| RadarAxisLabelsFont | The name of the font to use for the axis labels of a radar chart. |
| RadarAxisLabelsFontBold |
Whether to bold the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| RadarAxisLabelsFontColor | The font color to use for the axis labels of a radar chart. |
| RadarAxisLabelsFontColorIndex |
The Excel color index to use for the font of the axis labels of a radar chart. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| RadarAxisLabelsFontItalic |
Whether to italicize the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| RadarAxisLabelsFontOutline |
Whether to outline the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| RadarAxisLabelsFontShadow |
Whether to apply shadow to the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| RadarAxisLabelsFontSize |
The font size to use for the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank>689101112141618202122242628364872
|
| RadarAxisLabelsFontStrikeThrough |
Whether to apply strikethrough to the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| RadarAxisLabelsFontSubscript |
Whether to subscript the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| RadarAxisLabelsFontSuperscript |
Whether to superscript the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| RadarAxisLabelsFontTintAndShade | The tint-and-shade value to apply to the axis labels of a radar chart. |
| RadarAxisLabelsFontUnderline |
The underline style to apply to the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank>SingleSingleAccountingDoubleDoubleAccountingNone
|
| SecondPlotSize | The size of the second plot as a percentage of the size of the first plot on a pie of pie chart. |
| SeriesLinesFillColor | The fill color of the group's SeriesLines (of a stacked bar or pie of pie chart). |
| SeriesLinesFillTransparency | The fill transparency of the group's SeriesLines (of a stacked bar or pie of pie chart). From 0.0 to 1.0 (opaque to transparent). |
| SeriesLinesFillVisible |
The fill visible of the group's SeriesLines (of a stacked bar or pie of pie chart).
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| SeriesLinesLineColor | The color of the group's SeriesLines (of a stacked bar or pie of pie chart). |
| SeriesLinesLineTransparency | The transparency of the group's SeriesLines (of a stacked bar or pie of pie chart). From 0.0 to 1.0 (opaque to transparent). |
| SeriesLinesLineVisible |
The visible of the group's SeriesLines (of a stacked bar or pie of pie chart).
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| SeriesLinesLineWeight | The weight of the group's SeriesLines (of a stacked bar or pie of pie chart). |
| ShowNegativeBubbles |
Whether bubbles with negative values are shown on a bubble chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| SizeRepresents |
What the size values represent on a bubble chart.
Specify one of the following values or an arbitrary value:
<blank>AreaWidth
|
| SplitType |
The property which specifies how values are split on a pie of pie chart.
Specify one of the following values or an arbitrary value:
<blank>CustomPercentValuePositionValue
|
| SplitValue | The property which specifies the separation value on a pie of pie chart. |
| UpBarsFillColor | The fill color of the group's UpBars. |
| UpBarsFillTransparency | The fill transparency of the group's UpBars. From 0.0 to 1.0 (opaque to transparent). |
| UpBarsFillVisible |
The fill visible of the group's UpBars.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| UpBarsLineColor | The color of the group's SeriesLines UpBars. |
| UpBarsLineTransparency | The transparency of the group's SeriesLines UpBars. From 0.0 to 1.0 (opaque to transparent). |
| UpBarsLineVisible |
The visible of the group's SeriesLines UpBars.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| UpBarsLineWeight | The weight of the group's SeriesLines UpBars. |
| VaryByCategories |
Whether colors are varied for each data point of the first series in a chart containing only one series.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
Set the properties of a chart's legend.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| IncludeInLayout |
Whether the legend will be included in the chart layout area.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Position |
The position of the legend.
Specify one of the following values or an arbitrary value:
<blank>BottomCornerTopRightLeftCustom
|
| Left | The left position. |
| Top | The top position of the chart title. |
| LegendHeight | The height of the legend. |
| LegendWidth | The width of the legend. |
| BorderColor | Select the color for the line forecolor. |
| BorderTransparency | From 0.0 to 1.0 (opaque to transparent). |
| BorderVisible |
Whether the line is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| BorderWeight | The weight of the line, in points. |
| FillColor | Select the color for the fill's forecolor. |
| FillTransparency | From 0.0 to 1.0 (opaque to transparent). |
| FontName | Select a font. |
| FontSize |
Select or specify a font size.
Specify one of the following values or an arbitrary value:
<blank>689101112141618202122242628364872
|
| FontColor | Select the font color. |
| FontColorIndex |
Excel color palette index to use for the font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| FontBold |
Whether the font is bolded.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontItalic |
Whether the font is italicized.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontOutline |
Whether the font is outlined.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontShadow |
Whether the font is shadowed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontStrikeThrough |
Whether to apply Font strikethrough.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontSubscript |
Whether the font is subscripted.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontSuperscript |
Whether the font is superscripted.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontTintAndShade | Specifies the TintAndShade of the font. Values between -1.0 and 0.0 darken, while values between 0.0 and 1.0 lighten the font color. |
| FontUnderline |
None, Single, Double, SingelAccounting, DoubleAccounting.
Specify one of the following values or an arbitrary value:
<blank>SingleSingleAccountingDoubleDoubleAccountingNone
|
Add or modify a Line chart.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| LineChartType |
Select a chart-type.
Specify one of the following values or an arbitrary value:
<blank>LineLineMarkersLineMarkersStackedLineMarkersStacked100LineStackedLineStacked100
|
| DataRange | The address of the chart's data range. |
| SeriesOrientation |
Whether the chart's series are in row or column orientation.
Specify one of the following values or an arbitrary value:
<blank>ColumnsRows
|
| Title | The text for the chart's title. |
| HasLegend |
Whether to display the chart's legend.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| OnClickProcedure | The name of the procedure to execute when the chart is clicked. |
| OnDoubleClickProcedure | The name of the procedure to execute when the chart is double-clicked. |
| Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank>FreeFloatingMoveMoveAndSize
|
| Column | The column to put the Chart into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
| EndColumn | The column the will define the width of the chart. The Width argument can be used instead of this. |
| ColumnPoints | The position of the left edge of the Chart in points. If used with the Column argument then the two are added together. |
| Row | The row to put the Chart into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
| EndRow | The row the will define the height of the chart. The Height argument can be used instead of this. |
| RowPoints | The position of the top edge of the Chart in points. If used with the Row argument then the two are added together. |
| Width | The width of the Chart in points. The EndColumn argument can be used instead of this. |
| Height | The height of the Chart in points. The EndRow argument can be used instead of this. |
| LockAspectRatio |
Whether the chart's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
Add or modify a Pie chart.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| PieChartType |
Select a chart-type.
Specify one of the following values or an arbitrary value:
<blank>PiePieExploded
|
| DataRange | The address of the chart's data range. |
| SeriesOrientation |
Whether the chart's series are in row or column orientation.
Specify one of the following values or an arbitrary value:
<blank>ColumnsRows
|
| Title | The text for the chart's title. |
| HasLegend |
Whether to display the chart's legend.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| OnClickProcedure | The name of the procedure to execute when the chart is clicked. |
| OnDoubleClickProcedure | The name of the procedure to execute when the chart is double-clicked. |
| Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank>FreeFloatingMoveMoveAndSize
|
| Column | The column to put the Chart into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
| EndColumn | The column the will define the width of the chart. The Width argument can be used instead of this. |
| ColumnPoints | The position of the left edge of the Chart in points. If used with the Column argument then the two are added together. |
| Row | The row to put the Chart into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
| EndRow | The row the will define the height of the chart. The Height argument can be used instead of this. |
| RowPoints | The position of the top edge of the Chart in points. If used with the Row argument then the two are added together. |
| Width | The width of the Chart in points. The EndColumn argument can be used instead of this. |
| Height | The height of the Chart in points. The EndRow argument can be used instead of this. |
| LockAspectRatio |
Whether the chart's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
Set the properties of a chart point.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| SeriesName | The name that identifies the series. |
| SeriesIndex | The one-based index that identifies the series. |
| PointIndex | The one-based index that identifies the point within the series. |
| HasDataLabel |
Specifies whether the series has data labels.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelAutoText |
Specifies whether the text is automatically generated based on the data label type.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFillColor | Specifies the data label fill color. |
| DataLabelFillColorSpec | Specifies the data label fill color as an ARGB (alpha, red, green, blue) string, such as Color [A=255, R=255, G=192, B=0]. |
| DataLabelFillTransparency | Specifies the transparency. From 0.0 to 1.0 (opaque to transparent). |
| DataLabelFillVisible |
Specifies whether the fill is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontName | Specifies the font. |
| DataLabelFontBold |
Whether the data-labels are bolded.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontColor | Specifies the data-labels font color. |
| DataLabelFontColorIndex |
Excel color palette index to use for the data-labels's Font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| DataLabelFontItalic |
Whether the data-labels are italicized.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontOutline |
Whether the data-label fonts are outlined.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontShadow |
Whether the data-labels have shadows.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontSize |
Font size of the series' data-labels.
Specify one of the following values or an arbitrary value:
<blank>689101112141618202122242628364872
|
| DataLabelFontStrikeThrough |
Whether the data-labels have strikes through them.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontSubscript |
Whether the data-labels are subscripted.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontSuperscript |
Whether the data-labels are superscripted.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontTintAndShade | Specifies the TintAndShade of the font. Values between -1.0 and 0.0 darken, while values between 0.0 and 1.0 lighten the font color. |
| DataLabelFontUnderline |
Specifies the underline style of the font.
Specify one of the following values or an arbitrary value:
<blank>SingleSingleAccountingDoubleDoubleAccountingNone
|
| DataLabelLineColor | Specifies the data label line color. |
| DataLabelLineColorSpec | Specifies the data label line color as an ARGB (alpha, red, green, blue) string, such as Color [A=255, R=255, G=192, B=0]. |
| DataLabelLineTransparency | Specifies the transparency of the lines. From 0.0 to 1.0 (opaque to transparent). |
| DataLabelLineVisible |
Specifies whether the lines are visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelLineWeight | Specifies the weight of the lines, in points. |
| DataLabelNumberFormat |
Specifies the number format.
Specify one of the following values or an arbitrary value:
<blank>00.00#,##0#,##0.00#,##0_);(#,##0)#,##0_);[Red](#,##0)#,##0.00_);(#,##0.00)#,##0.00_);[Red](#,##0.00)_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
|
| DataLabelNumberFormatLinked |
Specifies whether to use the same number format as the cells that contain the data for the associated data points.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelPosition |
Specifies the position (Mixed, Automatic, OutsideEnd, InsideEnd, Center, InsideBase, Above, Below, Left, Right, BestFit, Custom).
Specify one of the following values or an arbitrary value:
<blank>MixedAutomaticOutsideEndInsideEndCenterInsideBaseAboveBelowLeftRightBestFitCustom
|
| DataLabelShowBubbleSize |
Specifies whether to show the bubble size.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelShowCategoryName |
Specifies whether to show the category name.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelShowLegendKey |
Specifies whether to show the legend key.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelShowPercentage |
Specifies whether the show the percentage.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelShowValue |
Specifies whether to show the value.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelText | The text of the point's data label. |
| Explosion | Specifies the explosion value for all of the data points on a pie or doughnut chart. |
| PointFillColor | Specifies the fill color. |
| PointFillColorSpec | Specifies the fill color as an ARGB (alpha, red, green, blue) string, such as Color [A=255, R=255, G=192, B=0]. |
| PointFillTransparency | Specifies the transparency. From 0.0 to 1.0 (opaque to transparent). |
| PointFillVisible |
Specifies whether the fill is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| PointLineColor | Specifies the point line color. |
| PointLineColorSpec | Specifies the point line color as an ARGB (alpha, red, green, blue) string, such as Color [A=255, R=255, G=192, B=0]. |
| PointLineTransparency | Specifies the transparency of the lines. From 0.0 to 1.0 (opaque to transparent). |
| PointLineVisible |
Specifies whether the lines are visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| PointLineWeight | Specifies the weight of the lines, in points. |
| InvertIfNegative |
Specifies whether pattern colors are inverted on data points with negative values.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| MarkerSize | Specifies the size of the markers in points. |
| MarkerStyle |
Specifies the marker style.
Specify one of the following values or an arbitrary value:
<blank>AutomaticNoneSquareDiamondTriangleXStarDotDashCirclePlus
|
| SecondaryPlot |
Whether the data point is in the secondary plot on a pie of pie chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
Remove a chart.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
Select a chart.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| Replace |
Whether to replace the current selection of charts, or add this chart to the selections.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
Set the properties of a chart series.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| SeriesName | The name that identifies the series. |
| SeriesIndex | The one-based index that identifies the series. |
| AxisGroup |
Specifies which axis group this series is plotted on.
Specify one of the following values or an arbitrary value:
<blank>PrimarySecondary
|
| BarShape |
Specifies the shape of 3D bars.
Specify one of the following values or an arbitrary value:
<blank>BoxConeToMaxConeToPointCylinderPyramidToMaxPyramidToPoint
|
| BubbleSizes | The bubble size values for the series. |
| ChartType |
Specifies the chart type of the series.
Specify one of the following values or an arbitrary value:
<blank>AreaAreaStackedAreaStacked100BarClusteredBarStackedBarStacked100ColumnClusteredColumnStackedColumnStacked100LineLineMarkersLineMarkersStackedLineMarkersStacked100LineStackedLineStacked100PiePieExplodedStockHLCStockOHLCStockVHLCStockVOHLCXYScatterXYScatterLinesXYScatterLinesNoMarkers
|
| HasDataLabel |
Specifies whether the series has data labels.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelAutoText |
Specifies whether the text is automatically generated based on the data label type.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFillColor | Specifies the data label fill color. |
| DataLabelFillTransparency | Specifies the transparency. From 0.0 to 1.0 (opaque to transparent). |
| DataLabelFillVisible |
Specifies whether the fill is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontName | Specifies the font. |
| DataLabelFontBold |
Whether the data-labels are bolded.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontColor | Specifies the data-labels font color. |
| DataLabelFontColorIndex |
Excel color palette index to use for the data-labels's Font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| DataLabelFontItalic |
Whether the data-labels are italicized.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontOutline |
Whether the data-label fonts are outlined.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontShadow |
Whether the data-labels have shadows.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontSize |
Font size of the series' data-labels.
Specify one of the following values or an arbitrary value:
<blank>689101112141618202122242628364872
|
| DataLabelFontStrikeThrough |
Whether the data-labels have strikes through them.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontSubscript |
Whether the data-labels are subscripted.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontSuperscript |
Whether the data-labels are superscripted.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelFontTintAndShade | Specifies the TintAndShade of the font. Values between -1.0 and 0.0 darken, while values between 0.0 and 1.0 lighten the font color. |
| DataLabelFontUnderline |
Specifies the underline style of the font.
Specify one of the following values or an arbitrary value:
<blank>SingleSingleAccountingDoubleDoubleAccountingNone
|
| DataLabelLineColor | Specifies the data label line color. |
| DataLabelLineTransparency | Specifies the transparency of the lines. From 0.0 to 1.0 (opaque to transparent). |
| DataLabelLineVisible |
Specifies whether the lines are visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelLineWeight | Specifies the weight of the lines, in points. |
| DataLabelNumberFormat |
Specifies the number format.
Specify one of the following values or an arbitrary value:
<blank>00.00#,##0#,##0.00#,##0_);(#,##0)#,##0_);[Red](#,##0)#,##0.00_);(#,##0.00)#,##0.00_);[Red](#,##0.00)_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)
|
| DataLabelNumberFormatLinked |
Specifies whether to use the same number format as the cells that contain the data for the associated data points.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelPosition |
Specifies the position (Mixed, Automatic, OutsideEnd, InsideEnd, Center, InsideBase, Above, Below, Left, Right, BestFit, Custom).
Specify one of the following values or an arbitrary value:
<blank>MixedAutomaticOutsideEndInsideEndCenterInsideBaseAboveBelowLeftRightBestFitCustom
|
| DataLabelShowBubbleSize |
Specifies whether to show the bubble size.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelShowCategoryName |
Specifies whether to show the category name.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelShowLegendKey |
Specifies whether to show the legend key.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelShowPercentage |
Specifies whether the show the percentage.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| DataLabelShowValue |
Specifies whether to show the value.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| HasErrorBars |
Specifies whether the series has error bars.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ErrorBarsEndStyle |
The end style cap of the series' error bars.
Specify one of the following values or an arbitrary value:
<blank>NoCapCap
|
| ErrorBarsFillColor | Specifies the fill color of the series' error bars. |
| ErrorBarsFillTransparency | Specifies the transparency of the series' error bars fill. From 0.0 to 1.0 (opaque to transparent). |
| ErrorBarsFillVisible |
Specifies whether the series' error bars fill is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ErrorBarsLineColor | Specifies the series' error bars line color. |
| ErrorBarsLineTransparency | Specifies the transparency of the series' error bar lines. From 0.0 to 1.0 (opaque to transparent). |
| ErrorBarsLineVisible |
Specifies whether the series' error bar lines are visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ErrorBarsLineWeight | Specifies the weight of the series' error bar lines, in points. |
| Explosion | Specifies the explosion value for all of the data points on a pie or doughnut chart. |
| SeriesFillColor | Specifies the fill color of the series. |
| SeriesFillTransparency | Specifies the transparency of the series' fill. From 0.0 to 1.0 (opaque to transparent). |
| SeriesFillVisible |
Specifies whether the series' fill is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| SeriesLineColor | Specifies the series' line color. |
| SeriesLineTransparency | Specifies the transparency of the series' lines. From 0.0 to 1.0 (opaque to transparent). |
| SeriesLineVisible |
Specifies whether the series' lines are visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| SeriesLineWeight | Specifies the weight of the series' lines, in points. |
| Has3DEffect |
Specifies whether all the bubbles in a bubble series are displayed with a 3D effect.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| InvertIfNegative |
Specifies whether pattern colors are inverted on data points with negative values.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| HasLeaderLines |
Specifies whether the series has leader lines.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| LeaderLinesColor | Specifies the series' leader lines color. |
| LeaderLinesTransparency | Specifies the transparency of the series' leader lines. From 0.0 to 1.0 (opaque to transparent). |
| LeaderLinesVisible |
Specifies whether the series' leader lines are visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| LeaderLinesWeight | Specifies the weight of the series' leader lines, in points. |
| MarkerSize | Specifies the size of the markers in points. |
| MarkerStyle |
Specifies the marker style.
Specify one of the following values or an arbitrary value:
<blank>AutomaticNoneSquareDiamondTriangleXStarDotDashCirclePlus
|
| SeriesValues | The address of the series' data range. |
| SeriesXValues | The address of the series' X (horizontal) axis values. |
| Smooth |
Specifies whether smoothing is used on a line series.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
Add or modify a Stock chart.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| StockChartType |
Select a chart-type.
Specify one of the following values or an arbitrary value:
<blank>StockHLCStockOHLCStockVHLCStockVOHLC
|
| DataRange | The address of the chart's data range. |
| SeriesOrientation |
Whether the chart's series are in row or column orientation.
Specify one of the following values or an arbitrary value:
<blank>ColumnsRows
|
| Title | The text for the chart's title. |
| HasLegend |
Whether to display the chart's legend.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| OnClickProcedure | The name of the procedure to execute when the chart is clicked. |
| OnDoubleClickProcedure | The name of the procedure to execute when the chart is double-clicked. |
| Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank>FreeFloatingMoveMoveAndSize
|
| Column | The column to put the Chart into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
| EndColumn | The column the will define the width of the chart. The Width argument can be used instead of this. |
| ColumnPoints | The position of the left edge of the Chart in points. If used with the Column argument then the two are added together. |
| Row | The row to put the Chart into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
| EndRow | The row the will define the height of the chart. The Height argument can be used instead of this. |
| RowPoints | The position of the top edge of the Chart in points. If used with the Row argument then the two are added together. |
| Width | The width of the Chart in points. The EndColumn argument can be used instead of this. |
| Height | The height of the Chart in points. The EndRow argument can be used instead of this. |
| LockAspectRatio |
Whether the chart's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
Set the properties of a chart's title.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| Title | The text for the chart's title. |
| Left | The left position. |
| Top | The top position of the chart title. |
| BorderColor | Select the color for the line forecolor. |
| BorderTransparency | From 0.0 to 1.0 (opaque to transparent). |
| BorderVisible |
Whether the line is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| BorderWeight | The weight of the line, in points. |
| FillColor | Select the color for the fill's forecolor. |
| FillTransparency | From 0.0 to 1.0 (opaque to transparent). |
| FontName | Select a font. |
| FontSize |
Select or specify a font size.
Specify one of the following values or an arbitrary value:
<blank>689101112141618202122242628364872
|
| FontColor | Select the font color. |
| FontColorIndex |
Excel color palette index to use for the font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| FontBold |
Whether the font is bolded.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontItalic |
Whether the font is italicized.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontOutline |
Whether the font is outlined.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontShadow |
Whether the font is shadowed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontStrikeThrough |
Whether to apply Font strikethrough.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontSubscript |
Whether the font is subscripted.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontSuperscript |
Whether the font is superscripted.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FontTintAndShade | Specifies the TintAndShade of the font. Values between -1.0 and 0.0 darken, while values between 0.0 and 1.0 lighten the font color. |
| FontUnderline |
None, Single, Double, SingelAccounting, DoubleAccounting.
Specify one of the following values or an arbitrary value:
<blank>SingleSingleAccountingDoubleDoubleAccountingNone
|
Add or modify a XYScatter chart.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ChartName | The name assigned to the Chart. This can be used to identify the chart after it is created. |
| XYScatterChartType |
Select a chart-type.
Specify one of the following values or an arbitrary value:
<blank>XYScatterXYScatterLinesXYScatterLinesNoMarkers
|
| DataRange | The address of the chart's data range. |
| SeriesOrientation |
Whether the chart's series are in row or column orientation.
Specify one of the following values or an arbitrary value:
<blank>ColumnsRows
|
| Title | The text for the chart's title. |
| HasLegend |
Whether to display the chart's legend.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| OnClickProcedure | The name of the procedure to execute when the chart is clicked. |
| OnDoubleClickProcedure | The name of the procedure to execute when the chart is double-clicked. |
| Placement |
The placement behavior of the chart. FreeFloating: Do not move with cells. Move: Do not move with cells. MoveAndSize: Move and size with cells.
Specify one of the following values or an arbitrary value:
<blank>FreeFloatingMoveMoveAndSize
|
| Column | The column to put the Chart into. 0.0 is the left edge of the first column. 0.5 is the middle of the first column, etc. If used with the ColumnPoints argument then the two are added together. |
| EndColumn | The column the will define the width of the chart. The Width argument can be used instead of this. |
| ColumnPoints | The position of the left edge of the Chart in points. If used with the Column argument then the two are added together. |
| Row | The row to put the Chart into. 0.0 is the top edge of the first row. 0.5 is the middle of the first row, etc. If used with the RowPoints argument then the two are added together. |
| EndRow | The row the will define the height of the chart. The Height argument can be used instead of this. |
| RowPoints | The position of the top edge of the Chart in points. If used with the Row argument then the two are added together. |
| Width | The width of the Chart in points. The EndColumn argument can be used instead of this. |
| Height | The height of the Chart in points. The EndRow argument can be used instead of this. |
| LockAspectRatio |
Whether the chart's aspect ratio is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|