Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro fails to produce Category Name and Percentage values - Pie C
Hi
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' Any suggestions as how to resolve? The problem is consistent at three sites that I use all with official licensed software. Thanks Jay |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro fails to produce Category Name and Percentage values -Pie C
Hi Jay,
I was able to reproduce the problem if I recorder the steps when using the chart wizard and at step 3 I set the data labels to display. Basically the data label code was not recorder. I guess that constitutes a bug ;) To work around it set the data labels after the wizard is closed. No need to stop the macro recorder. Just finish with the wizard and then select the pie and add data labels via the format dialog. This is captured in the macro. Cheers Andy Jay wrote: Hi 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' Any suggestions as how to resolve? The problem is consistent at three sites that I use all with official licensed software. Thanks Jay -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro fails to produce Category Name and Percentage values - P
Andy
Thanks. Yes it is consistent as you describe. I did exactly what you describe as a workaround to get the 'Category Name' and 'Percentages' in after the macro ran. 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 Jay "Andy Pope" wrote: Hi Jay, I was able to reproduce the problem if I recorder the steps when using the chart wizard and at step 3 I set the data labels to display. Basically the data label code was not recorder. I guess that constitutes a bug ;) To work around it set the data labels after the wizard is closed. No need to stop the macro recorder. Just finish with the wizard and then select the pie and add data labels via the format dialog. This is captured in the macro. Cheers Andy Jay wrote: Hi 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' Any suggestions as how to resolve? The problem is consistent at three sites that I use all with official licensed software. Thanks Jay -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro fails to produce Category Name and Percentage values -P
Hi,
The macro recorder is a great tool for producing code but don't rely on it to 'work straight out of the box'. Most recorder generated code will require some editing to make it more generic and or robust. I couldn't find any reference to this bug in the MSDN knowledge base. Cheers Andy Jay wrote: Andy Thanks. Yes it is consistent as you describe. I did exactly what you describe as a workaround to get the 'Category Name' and 'Percentages' in after the macro ran. 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 Jay "Andy Pope" wrote: Hi Jay, I was able to reproduce the problem if I recorder the steps when using the chart wizard and at step 3 I set the data labels to display. Basically the data label code was not recorder. I guess that constitutes a bug ;) To work around it set the data labels after the wizard is closed. No need to stop the macro recorder. Just finish with the wizard and then select the pie and add data labels via the format dialog. This is captured in the macro. Cheers Andy Jay wrote: Hi 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' Any suggestions as how to resolve? The problem is consistent at three sites that I use all with official licensed software. Thanks Jay -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro fails to produce Category Name and Percentage values - P
Hi Andy,
I wrote a macro that creates a chart, adds data labels of Category name and Value. However, when I save and close the report, the Category Name is lost. I open the workbook again, and it is gone and the Category Name box is unchecked. I can check it, they appear, but when I save as a 2003 workbook they disappear. Have you heard of this before? It sounds like a setting but I can't find one. I used a co-worker's machine (again running 2007), and it works fine. I can save and close, and on reopening the Category Names are on my pie chart. Very strange. Any help is appreciated. "Andy Pope" wrote: Hi, The macro recorder is a great tool for producing code but don't rely on it to 'work straight out of the box'. Most recorder generated code will require some editing to make it more generic and or robust. I couldn't find any reference to this bug in the MSDN knowledge base. Cheers Andy Jay wrote: Andy Thanks. Yes it is consistent as you describe. I did exactly what you describe as a workaround to get the 'Category Name' and 'Percentages' in after the macro ran. 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 Jay "Andy Pope" wrote: Hi Jay, I was able to reproduce the problem if I recorder the steps when using the chart wizard and at step 3 I set the data labels to display. Basically the data label code was not recorder. I guess that constitutes a bug ;) To work around it set the data labels after the wizard is closed. No need to stop the macro recorder. Just finish with the wizard and then select the pie and add data labels via the format dialog. This is captured in the macro. Cheers Andy Jay wrote: Hi 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' Any suggestions as how to resolve? The problem is consistent at three sites that I use all with official licensed software. Thanks Jay -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Macro fails to produce Category Name and Percentage values - P
Hi,
No I have not heard of this before. Is your pc patched to the same level as your co-worker? You could check your excel options. Compare settings in the Advance section with the excel file open. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "pd_2004" wrote in message ... Hi Andy, I wrote a macro that creates a chart, adds data labels of Category name and Value. However, when I save and close the report, the Category Name is lost. I open the workbook again, and it is gone and the Category Name box is unchecked. I can check it, they appear, but when I save as a 2003 workbook they disappear. Have you heard of this before? It sounds like a setting but I can't find one. I used a co-worker's machine (again running 2007), and it works fine. I can save and close, and on reopening the Category Names are on my pie chart. Very strange. Any help is appreciated. "Andy Pope" wrote: Hi, The macro recorder is a great tool for producing code but don't rely on it to 'work straight out of the box'. Most recorder generated code will require some editing to make it more generic and or robust. I couldn't find any reference to this bug in the MSDN knowledge base. Cheers Andy Jay wrote: Andy Thanks. Yes it is consistent as you describe. I did exactly what you describe as a workaround to get the 'Category Name' and 'Percentages' in after the macro ran. 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 Jay "Andy Pope" wrote: Hi Jay, I was able to reproduce the problem if I recorder the steps when using the chart wizard and at step 3 I set the data labels to display. Basically the data label code was not recorder. I guess that constitutes a bug ;) To work around it set the data labels after the wizard is closed. No need to stop the macro recorder. Just finish with the wizard and then select the pie and add data labels via the format dialog. This is captured in the macro. Cheers Andy Jay wrote: Hi 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' Any suggestions as how to resolve? The problem is consistent at three sites that I use all with official licensed software. Thanks Jay -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|