Cmdlet

Set-OfficeExcelChartSeries

Aliases: ExcelChartSeries

Module: PSWriteOffice
Aliases: ExcelChartSeries
Inputs: OfficeIMO.Excel.ExcelChart
Outputs: OfficeIMO.Excel.ExcelChart
Source: SetOfficeExcelChartSeriesCommand.cs:20 Edit on GitHub

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

Syntax

Set-OfficeExcelChartSeries
-Chart <ExcelChart>
[-FillColor <String>]
[-LineColor <String>]
[-LineWidthPoints <Double>]
[-MarkerFillColor <String>]
[-MarkerLineColor <String>]
[-MarkerLineWidthPoints <Double>]
[-MarkerSize <Int32>]
[-MarkerStyle <OfficeChartMarkerShape>]
[-PassThru]
-SeriesIndex <Int32>
[<CommonParameters>]

Parameter set: Index

Set-OfficeExcelChartSeries
-Chart <ExcelChart>
[-FillColor <String>]
[-IgnoreCase <Boolean>]
[-LineColor <String>]
[-LineWidthPoints <Double>]
[-MarkerFillColor <String>]
[-MarkerLineColor <String>]
[-MarkerLineWidthPoints <Double>]
[-MarkerSize <Int32>]
[-MarkerStyle <OfficeChartMarkerShape>]
[-PassThru]
-SeriesName <String>
[<CommonParameters>]

Parameter set: Name

Examples

Format a series by name.

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

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

Parameters

-Chart ExcelChart requiredpipeline: True (ByValue): Chart to update.
-FillColor String optional: Series fill color. Named colors and hexadecimal values are accepted.
-LineColor String optional: Series line color. Named colors and hexadecimal values are accepted.
-LineWidthPoints Double optional: Series line width in points.
-MarkerFillColor String optional: Marker fill color. Named colors and hexadecimal values are accepted.
-MarkerLineColor String optional: Marker line color. Named colors and hexadecimal values are accepted.
-MarkerLineWidthPoints Double optional: Marker line width in points.
-MarkerSize Int32 optional: Marker size.
-MarkerStyle OfficeChartMarkerShape optional: Marker style name.; Possible values: Auto, Circle, Dash, Diamond, Dot, Picture, Plus, Square, Star, Triangle, X
-PassThru SwitchParameter optional: Emit the object created or changed by the command.
-SeriesIndex Int32 requiredsets: Index: Zero-based series index.
-IgnoreCase Boolean optionalsets: Name: Ignore case when matching series name.
-SeriesName String requiredsets: Name: Series name.

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.