Hello

I am producing a simple spreadsheet for analysis of a clients life
insurance needs. The results within the sheet will then create a graph
showing the various areas they need to cover. I have done this in a
pie chart (pay mortgage, funeral costs, clear credit card debt etc)

The chart is just fine however because I have about 15 possible cells
to complete on the spreadsheet, depending on the client, some will
remain empty (as they have no such need) The problem i have is that
the resulting graph is cluttered up with legends for the '0' or zero
categories. Is there an easy way to select these to not appear? I only
want those with amounts above zero to show on the graph

Thanks heaps


Tony