Chart Labels Not Updating Correctly ??

jdowski

Board Regular
Joined
Apr 21, 2002
Messages
235
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.....
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,144,148
Messages
5,722,779
Members
422,457
Latest member
Mrmuskins

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top