pie chart data labels auto update ?

  • Thread starter ORLANDO VAZQUEZ
  • Start date
O

ORLANDO VAZQUEZ

Hi,

Using Excel 2003; I have a pie chart whose chosen Chart Options/Data Labels
are "Category Name" and "Percentage" which in turn are linked to a
concatenated formula showing manager name, dollar amounts and then
percentages.

When these linked formula values are updated, the chart data labels do not
automatically update and require me to go to Chart Options/Data Labels and
deselect then reselect "Category Name" and "Percentage" to force them to
update and then I have to reformat them, etc, etc.

Am I doing something wrong or does excel really not update these values on
the fly? My calculation is set to automatic.

Please let me know if it is possible to have them automatically update.

Thank you.
Orlando
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top