Dynamic Pie Chart that ignores Suppliers with zero sales

[ikench]

I have a range of suppliers that sales data is automatically captured and sorted. I now need to make a pie chart but have no idea how to make the chart ignore the suppliers with zero revenue. The suppliers could change with each document I create and could change within one document over the course of time. I need for this to be automatically organized in the pie chart. Right now I have all included in the legend and the chart plot. I know I could do this with filtering but that will not work long term.

Thanks in advance for the help.

[Greg M]

Hi there,

Here's a VERY cheap 'n' cheerful way of achieving what you need by using a helper column.

Sorry, it's pretty late here so I can't really propose a solution using dynamic ranges just at the moment

Hope this helps (if only somewhat!)

Regards,

Greg M

[ikench]

Thanks Greg, works like a charm.

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're very welcome - glad I was able to help.

Best regards,

Greg M