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.

Xbox Live Points Features

• Enhance your Xbox 360 experience with the array of downloadable content available via Xbox Live marketplace using our Xbox live points.
• Our Xbox live points provide relative microsoft points redeemable in the Xbox live marketplace.
• Download add-ons such as songs, maps, levels, and characters on Xbox live marketplace.
• Play fun arcade games to demonstrate your prowess on classic titles
• Play high-definition movies and TV shows for an additional entertainment.
• Outfit your avatar in special fashions and props.

Cheap microsoft pointsWhy Buy an Xbox Live Gold Subscription or Microsoft Points Online?Many may consider why you would want to buy your Xbox Live Subscription or your Microsoft Points card online. Microsoft offers them for purchase over Xbox Live, and you can also buy them at any local game store or superstore. There are a few reasons listed below to avoid purchasing points or subscriptions this way.

• If you buy your Xbox Live Gold Subscription over Xbox 360 Live you will be auto billed to your credit card each time your subscription runs out. This takes a long annoying phone call to cancel.
• Buying MS Points cards at a local store will cost you more for the following reasons; You have to pay for the gas to make the trip, you waste your time driving and waiting in line, and you also have to pay taxes on any store purchases.
• Some Debit or Credit cards may not be accepted by Xbox Live.
• Some APO (Army Post Office) FPO (Fleet Post Office) addresses can not be used as a credit card billing address over Xbox Live. This leaves most credit or debit cards with APO or FPO billing address's unable to purchase Xbox Live Gold or Microsoft points over Xbox Live.