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