ImportExcel

4.0.12

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

   }

}