API Reference
Cmdlet
Set-OfficeExcelChartSeries
Configures Excel chart series colors, line style, and markers.
Remarks
Configures Excel chart series colors, line style, and markers.
Examples
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 <Double>] [-MarkerFillColor <String>] [-MarkerLineColor <String>] [-MarkerLineWidthPoints <Double>] [-MarkerSize <Int32>] [-MarkerStyle <Auto>] [-PassThru] -SeriesIndex <Int32> [<CommonParameters>]Parameter set:
IndexParameters
- Chart ExcelChart
- Chart to update.
- FillColor String
- Series fill color. Named colors and hexadecimal values are accepted.
- LineColor String
- Series line color. Named colors and hexadecimal values are accepted.
- LineWidthPoints Double
- Series line width in points.
- MarkerFillColor String
- Marker fill color. Named colors and hexadecimal values are accepted.
- MarkerLineColor String
- Marker line color. Named colors and hexadecimal values are accepted.
- MarkerLineWidthPoints Double
- Marker line width in points.
- MarkerSize Int32
- Marker size.
- MarkerStyle OfficeChartMarkerShape
- Marker style name.
- Possible values:
Auto,Circle,Dash,Diamond,Dot,Picture,Plus,Square,Star,Triangle,X - PassThru SwitchParameter
- Emit the object created or changed by the command.
- SeriesIndex Int32
- Zero-based series index.
Outputs
OfficeIMO.Excel.ExcelChart
Set-OfficeExcelChartSeries -Chart <ExcelChart> [-FillColor <String>] [-IgnoreCase <Boolean>] [-LineColor <String>] [-LineWidthPoints <Double>] [-MarkerFillColor <String>] [-MarkerLineColor <String>] [-MarkerLineWidthPoints <Double>] [-MarkerSize <Int32>] [-MarkerStyle <Auto>] [-PassThru] -SeriesName <String> [<CommonParameters>]Parameter set:
NameParameters
- Chart ExcelChart
- Chart to update.
- FillColor String
- Series fill color. Named colors and hexadecimal values are accepted.
- IgnoreCase Boolean
- Ignore case when matching series name.
- LineColor String
- Series line color. Named colors and hexadecimal values are accepted.
- LineWidthPoints Double
- Series line width in points.
- MarkerFillColor String
- Marker fill color. Named colors and hexadecimal values are accepted.
- MarkerLineColor String
- Marker line color. Named colors and hexadecimal values are accepted.
- MarkerLineWidthPoints Double
- Marker line width in points.
- MarkerSize Int32
- Marker size.
- MarkerStyle OfficeChartMarkerShape
- Marker style name.
- Possible values:
Auto,Circle,Dash,Diamond,Dot,Picture,Plus,Square,Star,Triangle,X - PassThru SwitchParameter
- Emit the object created or changed by the command.
- SeriesName String
- Series name.
Outputs
OfficeIMO.Excel.ExcelChart