Project

PSWriteOffice

PowerShell document automation across Word, Excel, PowerPoint, PDF, Reader, Confluence, Visio, and open text formats.

View on GitHub Releases Get package
Stars 159
Forks 14
PowerShell Gallery downloads 158,661
Release v3.0.5
Language: C# Updated: 2026-09-03

API Reference

Cmdlet

Set-OfficeExcelChartAxis

Aliases: ExcelChartAxis
Namespace PSWriteOffice
Aliases
ExcelChartAxis
Inputs
OfficeIMO.Excel.ExcelChart
Outputs
OfficeIMO.Excel.ExcelChart
Source
Sources/PSWriteOffice/Cmdlets/Excel/SetOfficeExcelChartAxisCommand.cs:26 Edit on GitHub

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

Remarks

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

Examples

Authored help example

Format value axis and gridlines.

PS>


$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.

PS>


$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.

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-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

Parameters

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

Outputs

OfficeIMO.Excel.ExcelChart