Hi,

I have a pivot table that is summarised in a nice dynamic chart. I have a range of values in this chart that have a lot of 0's in it. Is it possible for either the pivot table or the graph to exclude these 0's so it only shows the figures greater than 0?

Screen shot attached should help show what I mean. The little circles are the graph are linked to column 'Sum of RS eBay Listings'.

Many thanks,

Ben

ee.jpg