Set chart location to a dedicated worksheet

[geoced]

Hello,

I've been trying to set the location of a chart such that it is not embedded as an object in an existing worksheet but sits on a dedicated worksheet (see dialog box in the screenshot below). It should look like this (fullscreen graph with no cells):

But no matter what I try, it always ends up as an embedded object:

Can this be achieved ?

[geoced]

Found it !

You have to create an ExcelChartSheet with this code:

$chartSheet = $xl.Workbook.Worksheets.AddChart('SheetTitle', [OfficeOpenXml.Drawing.Chart.eChartType]::Line)
$chart = $chartSheet.Drawings[0]
$chart.Title.Text = 'Chart Title'
$series = $chart.Series.Add($yRange, $xRange)

Would be nice if this option was offered by ImportExcel, e.g. as a [switch] parameter of Add-ExcelChart !

[dfinke]

Only so many switches can be offered. Sorry