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
Uh oh!
There was an error while loading. Please reload this page.
-
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