Hi All,
First off thanks for taking the time to read the following question/issue/plea for help

I have a data set in pivot form which i have created a pivot chart and wondered if there was anyway that the Legend that is displayed could only show the items which have a greater or equal number than 1 (basically if the item is zero then dont show in the legend area).

Hope this makes sense at all?

Kind Regards