Charting.ps1
|
function DoChart { param( $targetData, $title, [OfficeOpenXml.Drawing.Chart.eChartType]$ChartType, [Switch]$NoLegend, [Switch]$ShowCategory, [Switch]$ShowPercent ) if($targetData[0] -is [System.ValueType]) { $chart = New-ExcelChart -YRange "A1:A$($targetData.count)" -Title $title -ChartType $ChartType } else { $xyRange = Get-XYRange $targetData $X = $xyRange.XRange.ExcelColumn $XRange = "{0}2:{0}{1}" -f $X,($targetData.count+1) $Y = $xyRange.YRange.ExcelColumn $YRange = "{0}2:{0}{1}" -f $Y,($targetData.count+1) $chart = New-ExcelChart -XRange $xRange -YRange $yRange -Title $title -ChartType $ChartType ` -NoLegend:$NoLegend -ShowCategory:$ShowCategory -ShowPercent:$ShowPercent } $xlFile = [System.IO.Path]::GetTempFileName() -replace "tmp","xlsx" $targetData | Export-Excel $xlFile -ExcelChartDefinition $chart -Show -AutoSize } function BarChart { param( [Parameter(ValueFromPipeline=$true)] $targetData, $title, [OfficeOpenXml.Drawing.Chart.eChartType]$ChartType="BarStacked", [Switch]$NoLegend, [Switch]$ShowCategory, [Switch]$ShowPercent ) Begin { $data = @() } Process { $data += $targetData} End { DoChart $data $title -ChartType $ChartType ` -NoLegend:$NoLegend -ShowCategory:$ShowCategory -ShowPercent:$ShowPercent } } function PieChart { param( [Parameter(ValueFromPipeline=$true)] $targetData, $title, [OfficeOpenXml.Drawing.Chart.eChartType]$ChartType="PieExploded3D", [Switch]$NoLegend, [Switch]$ShowCategory, [Switch]$ShowPercent ) Begin { $data = @() } Process { $data += $targetData} End { DoChart $data $title -ChartType $ChartType ` -NoLegend:$NoLegend -ShowCategory:$ShowCategory -ShowPercent:$ShowPercent } } function LineChart { param( [Parameter(ValueFromPipeline=$true)] $targetData, $title, [OfficeOpenXml.Drawing.Chart.eChartType]$ChartType="Line", [Switch]$NoLegend, [Switch]$ShowCategory, [Switch]$ShowPercent ) Begin { $data = @() } Process { $data += $targetData} End { DoChart $data $title -ChartType $ChartType ` -NoLegend:$NoLegend -ShowCategory:$ShowCategory -ShowPercent:$ShowPercent } } function ColumnChart { param( [Parameter(ValueFromPipeline=$true)] $targetData, $title, [OfficeOpenXml.Drawing.Chart.eChartType]$ChartType="ColumnStacked", [Switch]$NoLegend, [Switch]$ShowCategory, [Switch]$ShowPercent ) Begin { $data = @() } Process { $data += $targetData} End { DoChart $data $title -ChartType $ChartType ` -NoLegend:$NoLegend -ShowCategory:$ShowCategory -ShowPercent:$ShowPercent } } |