Examples/Charts/ChartAndTrendlines.ps1
|
# Creates a worksheet, addes a chart and then a Linear trendline $xlfile = "$env:TEMP\trendLine.xlsx" Remove-Item $xlfile -ErrorAction SilentlyContinue $data = ConvertFrom-Csv @" Region,Item,TotalSold West,screws,60 South,lemon,48 South,apple,71 East,screwdriver,70 East,kiwi,32 West,screwdriver,1 South,melon,21 East,apple,79 South,apple,68 South,avocado,73 "@ $cd = New-ExcelChartDefinition -XRange Region -YRange TotalSold -ChartType ColumnClustered -ChartTrendLine Linear $data | Export-Excel $xlfile -ExcelChartDefinition $cd -AutoNameRange -Show |