Thread: 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

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

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
>

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