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?
LVL 3
yankees9920Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick MatthewsCommented:
Can you upload a copy of your file?
0
yankees9920Author Commented:
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
0
Patrick MatthewsCommented:
Looks to me like you edited the labels for one of the data points, and that caused them to stop updating.

I reset the labels and then added them back using Category Name and Value, and they then started updating dynamically again.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
yankees9920Author Commented:
I was unaware that you couldn't edit the Label name and have the numbers still update dynamically.

Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.