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

Authored help example

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.