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