Set-OfficeExcelChartSeries

Aliases: ExcelChartSeries

Namespace PSWriteOffice

Aliases

ExcelChartSeries

Inputs

OfficeIMO.Excel.ExcelChart

Outputs

OfficeIMO.Excel.ExcelChart

Source

Sources/PSWriteOffice/Cmdlets/Excel/SetOfficeExcelChartSeriesCommand.cs:16 Edit on GitHub

Configures Excel chart series colors, line style, and markers.

Remarks

Configures Excel chart series colors, line style, and markers.

Examples

Authored help example

Format a series by name.

PS>


$chart | Set-OfficeExcelChartSeries -SeriesName 'Revenue' -FillColor '#4472C4' -LineColor '#1F4E79' -MarkerStyle Circle -MarkerSize 6

Applies fill, line, and marker settings to the Revenue series.

Common Parameters

This command supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable.

For more information, see about_CommonParameters.

Syntax

Set-OfficeExcelChartSeries -Chart <ExcelChart> [-FillColor <String>] [-LineColor <String>] [-LineWidthPoints <Nullable`1>] [-MarkerFillColor <String>] [-MarkerLineColor <String>] [-MarkerLineWidthPoints <Nullable`1>] [-MarkerSize <Nullable`1>] [-MarkerStyle <String>] -SeriesIndex <Int32> [<CommonParameters>]

Parameter set: Index

Parameters

Chart ExcelChart requiredposition: namedpipeline: True (ByValue): Chart to update.
FillColor String optionalposition: namedpipeline: False: Series fill color in hex format.
LineColor String optionalposition: namedpipeline: False: Series line color in hex format.
LineWidthPoints Nullable`1 optionalposition: namedpipeline: False: Series line width in points.
MarkerFillColor String optionalposition: namedpipeline: False: Marker fill color in hex format.
MarkerLineColor String optionalposition: namedpipeline: False: Marker line color in hex format.
MarkerLineWidthPoints Nullable`1 optionalposition: namedpipeline: False: Marker line width in points.
MarkerSize Nullable`1 optionalposition: namedpipeline: False: Marker size.
MarkerStyle String optionalposition: namedpipeline: False: Marker style name.
SeriesIndex Int32 requiredposition: namedpipeline: False: Zero-based series index.

Outputs

OfficeIMO.Excel.ExcelChart

Set-OfficeExcelChartSeries -Chart <ExcelChart> [-FillColor <String>] [-IgnoreCase <Boolean>] [-LineColor <String>] [-LineWidthPoints <Nullable`1>] [-MarkerFillColor <String>] [-MarkerLineColor <String>] [-MarkerLineWidthPoints <Nullable`1>] [-MarkerSize <Nullable`1>] [-MarkerStyle <String>] -SeriesName <String> [<CommonParameters>]

Parameter set: Name

Parameters

Chart ExcelChart requiredposition: namedpipeline: True (ByValue): Chart to update.
FillColor String optionalposition: namedpipeline: False: Series fill color in hex format.
IgnoreCase Boolean optionalposition: namedpipeline: False: Ignore case when matching series name.
LineColor String optionalposition: namedpipeline: False: Series line color in hex format.
LineWidthPoints Nullable`1 optionalposition: namedpipeline: False: Series line width in points.
MarkerFillColor String optionalposition: namedpipeline: False: Marker fill color in hex format.
MarkerLineColor String optionalposition: namedpipeline: False: Marker line color in hex format.
MarkerLineWidthPoints Nullable`1 optionalposition: namedpipeline: False: Marker line width in points.
MarkerSize Nullable`1 optionalposition: namedpipeline: False: Marker size.
MarkerStyle String optionalposition: namedpipeline: False: Marker style name.
SeriesName String requiredposition: namedpipeline: False: Series name.

Outputs

OfficeIMO.Excel.ExcelChart