New-ExcelChart.ps1
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 |
function New-ExcelChart { param( $Title="Chart Title", $Header, [OfficeOpenXml.Drawing.Chart.eChartType]$ChartType="ColumnStacked", $XRange, $YRange, $Width=500, $Height=350, $Row=0, $RowOffSetPixels=10, $Column=6, $ColumnOffSetPixels=5, [Switch]$NoLegend, [Switch]$ShowCategory, [Switch]$ShowPercent, $SeriesHeader ) [PSCustomObject]@{ Title=$Title Header=$Header ChartType=$ChartType XRange=$XRange YRange=$YRange Width=$Width Height=$Height Row=$Row RowOffSetPixels=$RowOffSetPixels Column=$Column ColumnOffSetPixels=$ColumnOffSetPixels NoLegend = if($NoLegend) {$true} else {$false} ShowCategory = if($ShowCategory) {$true} else {$false} ShowPercent = if($ShowPercent) {$true} else {$false} SeriesHeader=$SeriesHeader } } |