Data Labels in Pie Graph

**Jonathan78** · 07-04-2010, 02:35 PM

I'm using a pie-graph, but have a problem with the data labels.
I guess it has something to do with the dynamic range but can't solve the problem myself.

Perhaps one of you can help me with this.
See attachment

**teylyn** · 07-05-2010, 12:32 AM

Change your formula in column C to

=IF(A4="",NA(),B4/$B$2)
copy down

Then your labels will sort themselves out because the NA points will not be plotted. If you really intend to plot up to 50 data points, then I strongly advise against the pie chart. Use a column or bar chart instead. It will be much easier to interpret.

cheers