how to hide the Axis on a chart? #1457
Replies: 1 comment
-
solution: $cDef = @{
Title = ''
ChartType = 'BarStacked'
XRange = 'Name'
YRange = @('StartDate', 'Duration')
NoLegend = $true
}
$pkg = $data | Export-Excel -Path $CsvPath -WorksheetName 'Data' -AutoNameRange -FreezeTopRow -PassThru
$chart = Add-ExcelChart @cDef -Worksheet $pkg.Data -PassThru
$chart.Series[0].Fill.Style = 'NoFill'
$chart.Axis[0].deleted = $true
Close-ExcelPackage -Show $pkg |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I need a chart with a minimum of labels. I hid the title thanks to
-Title ''
, the legend thanks to-NoLegend
. Can I somehow hide theXAxis
?Beta Was this translation helpful? Give feedback.
All reactions