Need urgent help with VBA 2007 CHARTWIZARD method !!!

[rAJU_sR]

Hey,

I am getting the runtime error -2147467259(80004005) "The specified
dimension is not valid for the current chart type"

in EXCEL 2007 VBA code to generate a 3D PIE. This code just fine in EXCEL
2003.



so what changed in 2007? Any ideas to fix this.



BTW, i need to make this code run in both 2003 and 2007... please help!!!



This is a urgent issue and i need to fix this ASAP. so any
comments/suggestions are most appreciated.





Thanks,

Raju

 

[Jon Peltier]

You did one thing right: you provided the error number and description.

You did two things wrong. 1. You neglected to provide the code that failed.
2. You're using a 3D pie chart, one of the least effective ways to display
information..

- Jon

 

[rAJU_sR]

hi,

here is the code:
ActiveChart.ChartWizard Source:=xyz, Gallery:=xl3DPie, _
Format:=7, PlotBy:=xlColumns, CategoryLabels:=1, SeriesLabels:=1, _
HasLegend:=2, Title:="", CategoryTitle:="", ValueTitle:="",
ExtraTitle:=""