Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
2007: Chartwizard bugs | Excel Programming | |||
Urgent help Runtime error ‘1004’ Method ‘SaveAs’ of object’-Workbook’ failed ????? | Excel Programming | |||
CreateCubeFile Method - RARELY Used - Need urgent help | Excel Programming | |||
Sub Total Method URGENT | Excel Programming |