Macro fails to produce Category Name and Percentage values - Pie C

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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.
 
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
 
Back
Top