Vista - Create a Chart in Excel

Hi,

As i am working through my project I keep hitting the wall with Excel.
I need to take some data and create a stacked bar chart with it.

I created a macro in Excel to do this, but I would like to run it as
part of my PowerShell script.

Here is the Excell Macro:

Sub Macro3()
'
' Macro3 Macro
'

'
Range("A81:B82").Select
ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=Range("'2545'!$A$81:$B$82")
ActiveChart.ChartType = xlBarStacked
ActiveChart.PlotArea.Select
ActiveChart.SetSourceData
ActiveSheet.ChartObjects("Chart 17").Activate
ActiveChart.SeriesCollection(1).XValues = "='2545'!$A$80"
End Sub


Here is as far as I have gotten with PS;

$x = New-Object -comobject Excel.Application
$x.Visible = $True
$x.DisplayAlerts = $False
$y = $x.Workbooks.Add()
$z = $y.Worksheets.Item(1)

$range = $z.range("A81:B82").Select
$y.sheets.Shapes.AddChart.Select
$ActiveChart.SetSourceData Source:=Range("'2545'!$A$81:$B$82")
<---- error is here !!!
$ActiveChart.ChartType = xlBarStacked
$ActiveChart.PlotArea.Select
$ActiveChart.SetSourceData
$ActiveSheet.ChartObjects("Chart 17").Activate
$ActiveChart.SeriesCollection(1).XValues = "='2545'!$A$80"



TIA

Olddog