I have a data access page where i have a pivot table an a chart
now I want to change the chart from a pie to a clustered column chart an
backwards

I have the VBScript code but only when de data is an array:

           With oChart.SeriesCollection.Add
                .Caption = "1998"
                .SetData c.chDimCategories, c.chDataLiteral, _
                         Array("East","West","North","South")
                .SetData c.chDimValues, c.chDataLiteral, _
                         Array(1000, 2020, 1800, 1300)
           End With

So how can I change this script so the data would be from my pivot table
named pvtable1
instead of an array.

Thanks