Excel 2007 Pie Chart Data Labels not updating

Good Afternoon,  I have an Excel 2007 Pie Chart that does not update the Data Labels as the data is changed.  The pie slices change in relation to the changes made in the data, but the Data Labels remain at the original value.  The only way I have been able "fix" this, is to create new data labels.  Is there a fix available for this?

I'm running this on Win XP SP3.

Thanks

Barrie
Springbok86Asked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
Righ click on top of your data series and choose Format Data Series. On the Data Labels check the option "Automatic Text". Now it will update your data labels each time you change a value on your cells.

Note: I'm oppening the file with Excel 2003 with the compatibility add-in so the location of the menus may differ from Excel 2007.

jppinto
0
 
jppintoCommented:
Is Calculation set to Automatic?

Can you please post a sample sheet for us to take a look?

jppinto
0
 
Saqib Husain, SyedEngineerCommented:
How do you paste the data labels?

Are you, by any chance, using third party software like J-Walk chart tools to label the data?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Springbok86Author Commented:
Thanks for the quick response, and the answer to the three questions is Yes it's on Automatic recalculation, Yes I can send you a sample file and thirdly, No, I am not using any third party software.

The labels are generated by the application.  What I have found out is, when I have only the Data value as the label, it updates correctly.  However, when I select the option to have both the value and it's percentage on the chart, it does not update at all.

The attached image shows the pie chart in question.  I have discovered this.  If I leave the format of the label value/%  at it's default, example 40, 25% it updates correctly, but if I mess with the formating to make it look a bit more presentable by removing the comma and putting the percentage on another line, updating is not done.

I appreciate the help.
Doc1.doc
0
 
Saqib Husain, SyedEngineerCommented:
I thought you said it was an Excel pie chart.

The pie chart attached is not an Excel pie chart. This might have been created in Excel but now that it is pasted in word it is no longer an Excel chart and will not update either the label or the slices.

You might be able to have it updated if you paste a linked object from Excel.

Saqib
0
 
Springbok86Author Commented:
I also said in the last message that I attached "AN IMAGE".  I know it won't update.  The pie chart that I'm working with is in an Excel file with all links intact.

It's a simple enough chart which is easy to replicate if necessary.
0
 
Saqib Husain, SyedEngineerCommented:
So why dont you post the excel chart with the links intact so that we try to figure out what is preventing the update?
0
 
Saqib Husain, SyedEngineerCommented:
If it has proprietary information just delete it and only leave the numbers which affect the graph
0
 
Springbok86Author Commented:
Hi Saqibh,
Here it is.
Book1.xlsx
0
 
Saqib Husain, SyedEngineerCommented:
Will it be possible to save it as a 2003 workbook? I do not have 2007 at the moment
0
 
Springbok86Author Commented:
Still on 2003, Saqibh?  I would have thought that in your role you would need to be current with you Office versions.  Here you go.
Book1.xls
0
 
Saqib Husain, SyedEngineerCommented:
Yes you are right. Actually I had reformatted my hard disk two weeks ago and installed 2003 and am lazy enough to install 2007 as well and yes I have had to let go a number of questions because the uploaded files were in 2007.

Same for this case. You now have a solution to your problem.

Best of luck

Saqib
0
 
Springbok86Author Commented:
While the solution did not entirely resolve my issue, it validated what I had found.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Saqib, have you heard of the Compatibility Pack?
0
 
Saqib Husain, SyedEngineerCommented:
Yes I have. But I prefer the real thing. I have used it only once to see it working. The reason is that I am not comfortable for doing my day-to-day work on 2007. In only one instance did the number of rows exceed 65536 for which I used 2007. I don't remember exceeding any of the other limitations of 2003 which would affect my work. There has always been a workaround.

So basically I only use 2007 for accessing files from EE. And the compatibility pack does not help in most of the cases because we need to know command sequences to be of any help and this can only be seen from the real thing,

Anyway thanks for your consideration.

I have seen some of your posts and am happy that EE is improving its standards through folks like you. and we get the chance to learn more and more. Keep up the good work.

Saqib
0
 
jppintoCommented:
0
All Courses

From novice to tech pro — start learning today.