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.....
Agravated Early on a Friday.....
