Hi All

I'm new to the forum but have used this place in the past and found it very helpful as an information resource so I thought it only right to register.

I do have an issue that I'm hoping someone can help me with however.

I have a Pie chart in a Worksheet, I want the pie chart to only show data from fields that have a value, at the moment it shows a thin slice and when hovered over it says 0%, I have tried selecting the "Show empty cells as Gaps" radio button but some of the thin slices are still showing.

I also only what the legend to show the fields that have values against them, at the moment I have a long list of headings/legends, I only want the ones in the list to show that have a value displayed in the pie chart.

I hope this makes sense to you all, shout if it does not.

I have created an example Sheet with a chart in if anyone would like to take a look, I tried uploading but dont appear to be able to.

Thanks in advance.