Cmdlet

Set-OfficeExcelChartPoint

Aliases: ExcelChartPoint

Module: PSWriteOffice
Aliases: ExcelChartPoint
Inputs: OfficeIMO.Excel.ExcelChart
Outputs: OfficeIMO.Excel.ExcelChart
Source: SetOfficeExcelChartPointCommand.cs:17 Edit on GitHub

Configures fill and line styling for a single Excel chart data point.

Syntax

Set-OfficeExcelChartPoint
-Chart <ExcelChart>
[-FillColor <String>]
[-LineColor <String>]
[-LineWidthPoints <Double>]
[-PassThru]
-PointIndex <UInt32>
-SeriesIndex <Int32>
[<CommonParameters>]

Parameter set: Index

Set-OfficeExcelChartPoint
-Chart <ExcelChart>
[-FillColor <String>]
[-IgnoreCase <Boolean>]
[-LineColor <String>]
[-LineWidthPoints <Double>]
[-PassThru]
-PointIndex <UInt32>
-SeriesName <String>
[<CommonParameters>]

Parameter set: Name

Examples

Highlight one data point.

$chart | Set-OfficeExcelChartPoint -SeriesName 'Revenue' -PointIndex 1 -FillColor '#C00000'

Applies a point-specific fill override to the second point in the Revenue series.

Parameters

-Chart ExcelChart requiredpipeline: True (ByValue): Chart to update.
-FillColor String optional: Point fill color. Named colors and hexadecimal values are accepted.
-LineColor String optional: Point line color. Named colors and hexadecimal values are accepted.
-LineWidthPoints Double optional: Point line width in points.
-PassThru SwitchParameter optional: Emit the object created or changed by the command.
-PointIndex UInt32 required: Zero-based data point index within the series.
-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.