Chart Label Help.....Really !!....Please !!!

[jdowski]

I have a spreadsheet that creates approximately 20 charts. It utilizes MS Query to bring fresh data into dynamic named ranges. The MS Query works fine, the named ranges work great. My problem is that the labels on the chart don't always reflect the changes to the source data. My solution thus far has been to visually inspect every chart against its source data and then delete the incorrect label and bring it back in. This takes too long. Right now the only code in this spreadsheet is code that cycles from sheet to sheet running the MS Query. Should I try to programatically delete and refresh all the chart labels too? Has anyone else run into this problem? Is there any other way to eliminate these frustrating errors !?!?!?!?

Agravated Early on a Friday.....

 

[Damon Ostrander]

Hi jdowski,

This may be obvious, but my first thought is that possibly you have automatic calculation turned off, which would keep the charts from updating automatically.

You didn't mention what types of labels you were referring to. Are these Title or axis labels? Or are they individual data point labels or legend (series) labels? Or possibly textboxes that you have linked to your data?

Damon

 

[jdowski]

I'm sorry. These are 3-D pie charts I'm referring to and the labels are data points. I have a dynamic named range for the data, and another for the labels. They are working fine. New data comes in via MS Query. Sometimes there are more data points, sometimes less, sometimes the same but different categories.....
Thanks,

Joe
Woodbury, CT. USA