Cmdlet

Set-OfficeExcelChartAxis

Aliases: ExcelChartAxis

Module: PSWriteOffice
Aliases: ExcelChartAxis
Inputs: OfficeIMO.Excel.ExcelChart
Outputs: OfficeIMO.Excel.ExcelChart
Source: SetOfficeExcelChartAxisCommand.cs:26 Edit on GitHub

Configures common Excel chart axis titles, formats, scale, and gridlines.

Syntax

Set-OfficeExcelChartAxis
[-AxisGroup <Primary|Secondary>]
[-CategoryGridlineColor <String>]
[-CategoryMajorUnit <Double>]
[-CategoryMaximum <Double>]
[-CategoryMinimum <Double>]
[-CategoryMinorUnit <Double>]
[-CategoryNumberFormat <String>]
[-CategoryTitle <String>]
-Chart <ExcelChart>
[-GridlineWidthPoints <Double>]
[-PassThru]
[-ShowCategoryMajorGridlines]
[-ShowCategoryMinorGridlines]
[-ShowValueMajorGridlines]
[-ShowValueMinorGridlines]
[-SourceLinked <Boolean>]
[-ValueGridlineColor <String>]
[-ValueMajorUnit <Double>]
[-ValueMaximum <Double>]
[-ValueMinimum <Double>]
[-ValueMinorUnit <Double>]
[-ValueNumberFormat <String>]
[-ValueTitle <String>]
[<CommonParameters>]

Parameter set: All Parameter Sets

Examples

Format value axis and gridlines.

$chart | Set-OfficeExcelChartAxis -CategoryTitle 'Month' -ValueTitle 'Revenue' -ValueNumberFormat '$#,##0' -ValueMinimum 0 -ValueMajorUnit 100 -ShowValueMajorGridlines

Sets axis titles, value formatting, scale, and major value gridlines.

Use a scaled date/category axis for a line chart.

$chart |
                Set-OfficeExcelChartAxis -CategoryTitle 'Week' -CategoryNumberFormat 'yyyy-mm-dd' -CategoryMinimum 46000 -CategoryMaximum 46090 -CategoryMajorUnit 14 -CategoryMinorUnit 7

Configures the chart's X axis through OfficeIMO's category/date-axis scale support while keeping the workbook chart object on the pipeline.

Parameters

-AxisGroup OfficeChartAxisGroup optional: Axis group to configure.; Possible values: Primary, Secondary
-CategoryGridlineColor String optional: Optional category gridline color. Named colors and hexadecimal values are accepted.
-CategoryMajorUnit Double optional: Category/date axis major unit.
-CategoryMaximum Double optional: Category/date axis maximum.
-CategoryMinimum Double optional: Category/date axis minimum.
-CategoryMinorUnit Double optional: Category/date axis minor unit.
-CategoryNumberFormat String optional: Category axis number format code.
-CategoryTitle String optional: Category axis title.
-Chart ExcelChart requiredpipeline: True (ByValue): Chart to update.
-GridlineWidthPoints Double optional: Optional gridline width in points.
-PassThru SwitchParameter optional: Emit the object created or changed by the command.
-ShowCategoryMajorGridlines SwitchParameter optional: Show category major gridlines.
-ShowCategoryMinorGridlines SwitchParameter optional: Show category minor gridlines.
-ShowValueMajorGridlines SwitchParameter optional: Show value major gridlines.
-ShowValueMinorGridlines SwitchParameter optional: Show value minor gridlines.
-SourceLinked Boolean optional: Keep axis number formats linked to source cells.
-ValueGridlineColor String optional: Optional value gridline color. Named colors and hexadecimal values are accepted.
-ValueMajorUnit Double optional: Value axis major unit.
-ValueMaximum Double optional: Value axis maximum.
-ValueMinimum Double optional: Value axis minimum.
-ValueMinorUnit Double optional: Value axis minor unit.
-ValueNumberFormat String optional: Value axis number format code.
-ValueTitle String optional: Value axis title.

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.