ImportExcel

1.90

New-ExcelChart.ps1

                                function New-ExcelChart {

    param(

        $Title="Chart Title",

        [OfficeOpenXml.Drawing.Chart.eChartType]$ChartType="ColumnStacked",

        $XRange,

        $YRange,

        $Width=500,

        $Height=350,

        $PosRow=0,

        $PosRowOffSetPixels=10,

        $PosColumn=6,

        $PosColumnOffSetPixels=5

    )

    [PSCustomObject]@{

        Title=$Title

        ChartType=$ChartType

        XRange=$XRange

        YRange=$YRange

        Width=$Width

        Height=$Height

        PosRow=$PosRow

        PosRowOffSetPixels=$PosRowOffSetPixels

        PosColumn=$PosColumn

        PosColumnOffSetPixels=$PosColumnOffSetPixels

    }

}