Need urgent help with VBA 2007 CHARTWIZARD method !!!
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 |
Need urgent help with VBA 2007 CHARTWIZARD method !!!
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "rAJU_sR" wrote in message ... 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 |
Need urgent help with VBA 2007 CHARTWIZARD method !!!
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:="" "Jon Peltier" wrote: 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "rAJU_sR" wrote in message ... 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 |
All times are GMT +1. The time now is 01:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com