Hi I don't think this is possible to automate the chart to display non-zero
entries only. The only way round it would be to put the zeros at the top or
bottom, perhaps by sorting, then re-create the chart excluding the zero
entries. It would be possible to write a macro that automates this, but
depending on how often the chart would need to be refreshed it'd probably be
best just to manually re-sort and re-create the chart as and when needed.

" wrote:

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