Pie chart data labels not updating!

[peftypefty]

When I make changes to the data that are the data source for a pie chart, the pie chart data labels always fail to update. I would expect this from Excel97, but I'm working in Excel 2003... Is this autoupdating issue still a known Excel bug? Is there a straightforward workaround?

Thanks!

- pk
-----------------------------------------------------------------------------------------
"The odds are good, but the goods are odd."

 

[RalphA]

Hmm, that is strange! I use Excel 97, and I just tried out all the different data labels, and, when I change the data, the update to the chart and its data labels takes place correctly. Perhaps you are lacking installation of one of the Add-Ins? (Tools, Add-Ins... I have them all checked!). Let us know if this fixes the problem.

 

[peftypefty]

Pie data label updating

OK, I just tried it on a workbook of smaller total size and reduced formulaic complexity, and the labels all updated correctly and instantly. So now my question becomes,

Is there any way to force Excel to update labels on highly complex or formulaic sheets?

Thanks . . .

 

[RalphA]

Reading your last post, I will retire and let the field open to any real Excel guru that reads this. Good luck!

Over and out.

 

[estensen]

Make sure that the Data sheet(s) are not hidden. When the sheets are hidden, the label on the graph will not update.

 

[estensen]

Make sure that the Data sheet(s) are not hidden. When the sheets are hidden, the label on the graph will not update.