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