Problem with chart object in Excel 2000

[anuktac]

Hi all,
I have a bit of code for drawing a chart using a macro. This is a part of an Application we have.
The code is

x=0
y=0
width=750
height=300
Set co = Sheets(Chapter).ChartObjects.Add(x, y, width, height)
co.Chart.ChartWizard Source:=Worksheets(Chapter_2_1).Range("A32:I92&quot, _
Gallery:=xlLine, Format:=2, PlotBy:=xlRows, categorylabels:=1, serieslabels:=1

This used to work very well in Excel 97. But now we have to migrate to Excel 2000, and I am finding that this does not work the way it did in 97. Instead of plotting the series according to xlRows, it plots it by default using xlColumns. And in the Chart Toolbar, the xlrows and xlcolumns buttons are disabled.

Can anyone help with this? How can I make the chart accept the data in rows as the line series?

-Anukta

 

[anuktac]

I just realized that this occurs only when the data soiurce I am using is a Pivot table. When the data source is a normal excel range it does not have a problem.

This happens only in 2000. Any ideas?

-Anukta