• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1729
  • Last Modified:

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?
0
yankees9920
Asked:
yankees9920
  • 2
  • 2
1 Solution
 
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
 
yankees9920Author Commented:
I was unaware that you couldn't edit the Label name and have the numbers still update dynamically.

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now