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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> Area AreaStacked AreaStacked100
|
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> Columns Rows
|
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> FALSE TRUE
|
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> FreeFloating Move MoveAndSize
|
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> FALSE TRUE
|
Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> Category Value Series
|
AxisGroup |
Specifies which axis group this series is plotted on.
Specify one of the following values or an arbitrary value:
<blank> Primary Secondary
|
AxisBetweenCategories |
Whether the value axis crosses between categories on the category axis.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
BaseUnit |
The base time unit for a category axis with a time-scale.
Specify one of the following values or an arbitrary value:
<blank> Days Months Years
|
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> FALSE TRUE
|
CategoryType |
The scale type on a category axis.
Specify one of the following values or an arbitrary value:
<blank> AutomaticScale CategoryScale TimeScale
|
AxisCrosses |
Where the other axis crosses this axis.
Specify one of the following values or an arbitrary value:
<blank> Automatic Custom Maximum Minimum
|
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> FALSE TRUE
|
HasMinorGridlines |
Whether an axis has minor gridlines.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> FALSE TRUE
|
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> None Inside Outside Cross
|
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> FALSE TRUE
|
MajorUnitScale |
The major time unit for a category axis with a time-scale.
Specify one of the following values or an arbitrary value:
<blank> Days Months Years
|
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> FALSE TRUE
|
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> FALSE TRUE
|
ReversePlotOrder |
Whether the axis scale values are in reverse order.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
ScaleType |
The scale type on a value axis.
Specify one of the following values or an arbitrary value:
<blank> Linear Logarithmic
|
TickLabelPosition |
The tick label position on an axis.
Specify one of the following values or an arbitrary value:
<blank> None Low High NextToAxis
|
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> FALSE TRUE
|
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> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
TickLabelsFontItalic |
Whether the tick-labels are italicized.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TickLabelsFontOutline |
Whether the tick-label fonts are outlined.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TickLabelsFontShadow |
Whether the tick-labels have shadows.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TickLabelsFontSize |
Font size of the chart's tick-labels.
Specify one of the following values or an arbitrary value:
<blank> 6 8 9 10 11 12 14 16 18 20 21 22 24 26 28 36 48 72
|
TickLabelsFontStrikeThrough |
Whether the tick-labels have strikes through them.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TickLabelsFontSubscript |
Whether the tick-labels are subscripted.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TickLabelsFontSuperscript |
Whether the tick-labels are superscripted.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> Single SingleAccounting Double DoubleAccounting None
|
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> 0 0.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> FALSE TRUE
|
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> FALSE TRUE
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> BarClustered BarStacked BarStacked100
|
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> Columns Rows
|
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> FALSE TRUE
|
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> FreeFloating Move MoveAndSize
|
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> FALSE TRUE
|
Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> ColumnClustered ColumnStacked ColumnStacked100
|
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> Columns Rows
|
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> FALSE TRUE
|
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> FreeFloating Move MoveAndSize
|
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> FALSE TRUE
|
Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
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> FALSE TRUE
|
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> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
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> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
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> FALSE TRUE
|
FontName | Select a font. |
FontSize |
Select or specify a font size.
Specify one of the following values or an arbitrary value:
<blank> 6 8 9 10 11 12 14 16 18 20 21 22 24 26 28 36 48 72
|
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> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FontBold |
Whether the font is bolded.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontItalic |
Whether the font is italicized.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontOutline |
Whether the font is outlined.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontShadow |
Whether the font is shadowed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontStrikeThrough |
Whether to apply Font strikethrough.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSubscript |
Whether the font is subscripted.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSuperscript |
Whether the font is superscripted.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> Single SingleAccounting Double DoubleAccounting None
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
HasDropLines |
Whether a line or area chart has drop lines.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
HasHiLoLines |
Whether a line chart has high-low lines.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
HasRadarAxisLabels |
Whether a radar chart has axis labels.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
HasSeriesLines |
Whether a stacked bar or pie of pie chart has series lines.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
HasUpDownBars |
Whether a line chart has up and down bars.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
RadarAxisLabelsFontItalic |
Whether to italicize the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
RadarAxisLabelsFontOutline |
Whether to outline the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
RadarAxisLabelsFontShadow |
Whether to apply shadow to the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> 6 8 9 10 11 12 14 16 18 20 21 22 24 26 28 36 48 72
|
RadarAxisLabelsFontStrikeThrough |
Whether to apply strikethrough to the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
RadarAxisLabelsFontSubscript |
Whether to subscript the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
RadarAxisLabelsFontSuperscript |
Whether to superscript the axis labels of a radar chart.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> Single SingleAccounting Double DoubleAccounting None
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
SizeRepresents |
What the size values represent on a bubble chart.
Specify one of the following values or an arbitrary value:
<blank> Area Width
|
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> Custom PercentValue Position Value
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
Position |
The position of the legend.
Specify one of the following values or an arbitrary value:
<blank> Bottom Corner Top Right Left Custom
|
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> FALSE TRUE
|
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> 6 8 9 10 11 12 14 16 18 20 21 22 24 26 28 36 48 72
|
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> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FontBold |
Whether the font is bolded.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontItalic |
Whether the font is italicized.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontOutline |
Whether the font is outlined.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontShadow |
Whether the font is shadowed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontStrikeThrough |
Whether to apply Font strikethrough.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSubscript |
Whether the font is subscripted.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSuperscript |
Whether the font is superscripted.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> Single SingleAccounting Double DoubleAccounting None
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> Line LineMarkers LineMarkersStacked LineMarkersStacked100 LineStacked LineStacked100
|
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> Columns Rows
|
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> FALSE TRUE
|
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> FreeFloating Move MoveAndSize
|
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> FALSE TRUE
|
Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> Pie PieExploded
|
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> Columns Rows
|
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> FALSE TRUE
|
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> FreeFloating Move MoveAndSize
|
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> FALSE TRUE
|
Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
DataLabelFontName | Specifies the font. |
DataLabelFontBold |
Whether the data-labels are bolded.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
DataLabelFontItalic |
Whether the data-labels are italicized.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelFontOutline |
Whether the data-label fonts are outlined.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelFontShadow |
Whether the data-labels have shadows.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelFontSize |
Font size of the series' data-labels.
Specify one of the following values or an arbitrary value:
<blank> 6 8 9 10 11 12 14 16 18 20 21 22 24 26 28 36 48 72
|
DataLabelFontStrikeThrough |
Whether the data-labels have strikes through them.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelFontSubscript |
Whether the data-labels are subscripted.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelFontSuperscript |
Whether the data-labels are superscripted.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> Single SingleAccounting Double DoubleAccounting None
|
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> FALSE TRUE
|
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> 0 0.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> FALSE TRUE
|
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> Mixed Automatic OutsideEnd InsideEnd Center InsideBase Above Below Left Right BestFit Custom
|
DataLabelShowBubbleSize |
Specifies whether to show the bubble size.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelShowCategoryName |
Specifies whether to show the category name.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelShowLegendKey |
Specifies whether to show the legend key.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelShowPercentage |
Specifies whether the show the percentage.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelShowValue |
Specifies whether to show the value.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> Automatic None Square Diamond Triangle X Star Dot Dash Circle Plus
|
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> FALSE TRUE
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> Primary Secondary
|
BarShape |
Specifies the shape of 3D bars.
Specify one of the following values or an arbitrary value:
<blank> Box ConeToMax ConeToPoint Cylinder PyramidToMax PyramidToPoint
|
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> Area AreaStacked AreaStacked100 BarClustered BarStacked BarStacked100 ColumnClustered ColumnStacked ColumnStacked100 Line LineMarkers LineMarkersStacked LineMarkersStacked100 LineStacked LineStacked100 Pie PieExploded StockHLC StockOHLC StockVHLC StockVOHLC XYScatter XYScatterLines XYScatterLinesNoMarkers
|
HasDataLabel |
Specifies whether the series has data labels.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
DataLabelFontName | Specifies the font. |
DataLabelFontBold |
Whether the data-labels are bolded.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
DataLabelFontItalic |
Whether the data-labels are italicized.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelFontOutline |
Whether the data-label fonts are outlined.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelFontShadow |
Whether the data-labels have shadows.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelFontSize |
Font size of the series' data-labels.
Specify one of the following values or an arbitrary value:
<blank> 6 8 9 10 11 12 14 16 18 20 21 22 24 26 28 36 48 72
|
DataLabelFontStrikeThrough |
Whether the data-labels have strikes through them.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelFontSubscript |
Whether the data-labels are subscripted.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelFontSuperscript |
Whether the data-labels are superscripted.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> Single SingleAccounting Double DoubleAccounting None
|
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> FALSE TRUE
|
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> 0 0.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> FALSE TRUE
|
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> Mixed Automatic OutsideEnd InsideEnd Center InsideBase Above Below Left Right BestFit Custom
|
DataLabelShowBubbleSize |
Specifies whether to show the bubble size.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelShowCategoryName |
Specifies whether to show the category name.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelShowLegendKey |
Specifies whether to show the legend key.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelShowPercentage |
Specifies whether the show the percentage.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
DataLabelShowValue |
Specifies whether to show the value.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
HasErrorBars |
Specifies whether the series has error bars.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
ErrorBarsEndStyle |
The end style cap of the series' error bars.
Specify one of the following values or an arbitrary value:
<blank> NoCap Cap
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
InvertIfNegative |
Specifies whether pattern colors are inverted on data points with negative values.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
HasLeaderLines |
Specifies whether the series has leader lines.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> FALSE TRUE
|
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> Automatic None Square Diamond Triangle X Star Dot Dash Circle Plus
|
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> FALSE TRUE
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> StockHLC StockOHLC StockVHLC StockVOHLC
|
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> Columns Rows
|
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> FALSE TRUE
|
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> FreeFloating Move MoveAndSize
|
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> FALSE TRUE
|
Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> 6 8 9 10 11 12 14 16 18 20 21 22 24 26 28 36 48 72
|
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> 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
FontBold |
Whether the font is bolded.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontItalic |
Whether the font is italicized.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontOutline |
Whether the font is outlined.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontShadow |
Whether the font is shadowed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontStrikeThrough |
Whether to apply Font strikethrough.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSubscript |
Whether the font is subscripted.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
FontSuperscript |
Whether the font is superscripted.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
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> Single SingleAccounting Double DoubleAccounting None
|
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
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> XYScatter XYScatterLines XYScatterLinesNoMarkers
|
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> Columns Rows
|
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> FALSE TRUE
|
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> FreeFloating Move MoveAndSize
|
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> FALSE TRUE
|
Locked |
Whether the chart is locked.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the chart is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
PrintChart |
Whether to print the chart.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|