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", _
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
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", _
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