Pie Chart Label Help!!

[stephen.smith]

Hi Guys
I have 50 worksheets which have 3 pie charts on each page. These pie charts contain information which is updated on a daily basis so the information represented is changing continously. However I have noticed that the data labels are not updating, this is extremely frustrating when trying to analyse the data. Is there a way to fix this easily.
Thanks in advance
Stephen

 

[Kurt]

Can you post some code or tell us how you are getting the data to the lables?

That would be a great start for me or anyone else looking at this.

 

[stephen.smith]

Hi
I have attached what the cells look like which I am using to create the pie charts. I am not using code but would happily use some code to fix the problem if anyone can supply some. The information comes into the sheet from a separate worksheet. The cells K1:K4 are locked as the page is password protected, does this effect it? The numbers are updating in the cells and the size of the slices in the chart are updating but the data labels are not.

Excel Workbook
	I	J	K	L
1		Series 1	3
2		Series 2	2
3		Series 3	6
4		Series 4	1
5
6	The Above Information J1:J4 Has the Series Name, K1:K4 has the number which is presented in the data label. This info is coming from a separate worksheet.
7
8
9
10
11
12
13
14
15
Sheet1