yankees9920
asked on
Pie chart data labels not updating
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
the fly?
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
the fly?
Can you upload a copy of your file?
ASKER
The issue I am having is with the pie chart on the lower left of the 1st page.
The breakout data (Non-Enh PTs and # Enh PTs) are from Sheet 2.
PTs in Test is from sheet 3
Active PTs is the sum of Non-Enh and #Enh.
If you change data on sheet 3 (which is intranet web query) the ones that will affect this chart are B2 and F2.
sample-file.xls
The breakout data (Non-Enh PTs and # Enh PTs) are from Sheet 2.
PTs in Test is from sheet 3
Active PTs is the sum of Non-Enh and #Enh.
If you change data on sheet 3 (which is intranet web query) the ones that will affect this chart are B2 and F2.
sample-file.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was unaware that you couldn't edit the Label name and have the numbers still update dynamically.
Thanks
Thanks