View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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