I need to create some charts using data that already exist in my workbook. Generation of Chart is correct, but axis data is not. It is always numeric, but In some charts i have text or date-time values. After generation, there is no possibility to change type of xAsis
$reportFilePath = "d:test.xlsx"
$worksheetName = "Trends"
$excelPackage = Open-ExcelPackage -Path $reportFilePath
$worksheet = $excelPackage.Workbook.Worksheets[$worksheetName]
Add-ExcelChart -Worksheet $worksheet -XRange "A2:A14" -YRange "B2:B14" -ChartType
XYScatterSmoothNoMarkers -ChartTrendLine Linear -LegendPosition Bottom -SeriesHeader
'aa' -ShowCategory -TitleBold
# Save and close Excel package
Close-ExcelPackage -ExcelPackage $excelPackage -Show
In column A i have only date-time values but on XAsis this data is numeric 🙁