REPT Charts in Excel

[dfinke]

Add plot data based on Units Sold using the Excel REPT function and change the font to PlayBill.

Export your data to Excel, use PassThru then in the second Set-ExcelRange you use the formula '=REPT("|",B2)' which will repeat the character | by the number in B2. -Range 'C2:C7' adds this formula for each cell.

The Magic

Using -FontName 'Playbill' the bar!

$data = ConvertFrom-Csv @"
Name,UnitsSold
John,100
Jane,200
Tom,120
Jane,300
Jim,150
Mary,250
"@

$xlFile = "$PSScriptRoot\spike.xlsx"
Remove-Item $xlFile -ErrorAction SilentlyContinue

$xlPkg = $data | Export-Excel -Path $xlFile -AutoSize -PassThru

Set-ExcelRange -Worksheet $xlPkg.Sheet1 -Range 'C1:C1' -Value 'Plot'
Set-ExcelRange -Worksheet $xlPkg.Sheet1 -Range 'C2:C7' -Formula '=REPT("|",B2)' -FontName 'Playbill' -FontColor "Green" -Width 35

Close-ExcelPackage $xlPkg -Show