Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro fails in Pie Chart - Can Microsoft / MVP please comment
Hi
I posted this on 17 Nov 2005. Andy Pope in a reply post has confirmed that he can reproduce the problem. Please can someone at Microsoft or an MVP see below and offer soem advice Microsoft Office Excel 2003 (11.6355.6360) SP1 When you record a macro in Excel to produce a Pie Chart with 'Chart Title', 'Category Name' and 'Percentage', and when the macro is run it produces the Chart with 'Chart Title' but does NOT add the 'Category Name' and 'Percentages' It would be nice if someone at Microsoft can confirm if this has been resolved - - With a patch - If so is this patch available in a Service Pack? - If so which Service Pack ? - If not is their a plan to resolve this ? The problem exists at a University, A College of Further Education and on my own XP installation. Any help/advice to resolve offcially and permananetly will be welcome Thanks Jay |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro fails in Pie Chart - Can Microsoft / MVP please comment
1. I just checked this on the latest SP of Excel 2003, and it does not
capture the data labels in the chart wizard. Therefore, it's not included in any patch. 2. I cannot speak for Microsoft, but this is the kind of thing that I wouldn't expect to be patched. Many other glitches in macro recorded code have persisted since Excel 97 or even Excel 5. So don't hold your breath. 3. The macro recorder produces code which at best is inefficient, and at worst won't run. Recorded code should be run with this understanding. I use the recorder all the time, because it's quicker than looking up syntax in the VBE Object Browser, but I never use it as is. Andy did propose a workaround: record the macro but just create the chart with the wizard, then when the wizard is closed apply the labels. The recorder picks up the labels this way as if it worked in the first place. It's probably a better use of your efforts to understand the limitations of the macro recorder and work around it, rather than to push for it to be made perfect (or at least merely inefficient). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Jay" wrote in message ... Hi I posted this on 17 Nov 2005. Andy Pope in a reply post has confirmed that he can reproduce the problem. Please can someone at Microsoft or an MVP see below and offer soem advice Microsoft Office Excel 2003 (11.6355.6360) SP1 When you record a macro in Excel to produce a Pie Chart with 'Chart Title', 'Category Name' and 'Percentage', and when the macro is run it produces the Chart with 'Chart Title' but does NOT add the 'Category Name' and 'Percentages' It would be nice if someone at Microsoft can confirm if this has been resolved - - With a patch - If so is this patch available in a Service Pack? - If so which Service Pack ? - If not is their a plan to resolve this ? The problem exists at a University, A College of Further Education and on my own XP installation. Any help/advice to resolve offcially and permananetly will be welcome Thanks Jay |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro fails in Pie Chart - Can Microsoft / MVP please comment
Jon
This is an excellent reply and yes I had searched for any reference to a fix/patch before I posted. Yes ofcourse I use the work around and did even before I posted but wanted to make sure that here in Scotland we hadn't missed something. I shall share Andy and your replies with the tutur concerned and many thanks. Jay "Jon Peltier" wrote: 1. I just checked this on the latest SP of Excel 2003, and it does not capture the data labels in the chart wizard. Therefore, it's not included in any patch. 2. I cannot speak for Microsoft, but this is the kind of thing that I wouldn't expect to be patched. Many other glitches in macro recorded code have persisted since Excel 97 or even Excel 5. So don't hold your breath. 3. The macro recorder produces code which at best is inefficient, and at worst won't run. Recorded code should be run with this understanding. I use the recorder all the time, because it's quicker than looking up syntax in the VBE Object Browser, but I never use it as is. Andy did propose a workaround: record the macro but just create the chart with the wizard, then when the wizard is closed apply the labels. The recorder picks up the labels this way as if it worked in the first place. It's probably a better use of your efforts to understand the limitations of the macro recorder and work around it, rather than to push for it to be made perfect (or at least merely inefficient). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Jay" wrote in message ... Hi I posted this on 17 Nov 2005. Andy Pope in a reply post has confirmed that he can reproduce the problem. Please can someone at Microsoft or an MVP see below and offer soem advice Microsoft Office Excel 2003 (11.6355.6360) SP1 When you record a macro in Excel to produce a Pie Chart with 'Chart Title', 'Category Name' and 'Percentage', and when the macro is run it produces the Chart with 'Chart Title' but does NOT add the 'Category Name' and 'Percentages' It would be nice if someone at Microsoft can confirm if this has been resolved - - With a patch - If so is this patch available in a Service Pack? - If so which Service Pack ? - If not is their a plan to resolve this ? The problem exists at a University, A College of Further Education and on my own XP installation. Any help/advice to resolve offcially and permananetly will be welcome Thanks Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Update Chart Macro | Charts and Charting in Excel | |||
Import chart to Power Point and Macro problem | Excel Discussion (Misc queries) |