Pie chart percentage update

[needexcelhelp]

I created a pie chart based on data from two cells. The figures in the two cells are derived from sum of other columns on the worksheet, which auto-updates periodically. The pie chart looks fine just when i created it but i found out later that the "percentage" data label doesnt change when the source data value changes. basically what i need is a "dynamic" pie chart that autoupdates when underlying values change. help is appreciated, thank you!

 

[needexcelhelp]

found out myself!

cheers

 

[SkipVought]

Hi,

Welcome to Tek-Tips.

Tek-Tips is a site where we share our knowledge and experience freely with other members.

So if you found a solution to your question, it would be greatly appreciated by other members, if you would post your solution, for the benefit of all.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}