Using Excel 2007; I have a pie chart whose chosen Chart Options/Data Labels
are "Category Name" and "Value" which in turn are linked to data that gets pulled in/updated via a web query.
When I update the query and new data is brought in, 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