Create Excel bar chart using PowerShell by repeating symbols based on values with custom styling

ExcelPlots.ps1

$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 -Width 35 `
    -Range 'C2:C7' -Formula '=REPT("|",B2)' `
    -FontName 'Playbill' -FontColor "Green"

Close-ExcelPackage $xlPkg -Show