Make a chart return only figures greater than 1

[s786]

Hi,

So I've got a list of 40+ numbers that change when the customer is chosen. I need the bar chart to be dynamic and change with these figures - that part is easy, however there are a lot of zero's and I want the chart to pick up and change only on results that are 1 or more...

Any advise please?

Thanks in advance

[zbor]

If you get data with formula try to return #N/A instad of 0.
If not add aditional column like: =IF(A1=0, NA(), A1)

[s786]

Thanks, but the horizontal axis is still picking up the series name and returning the values as 0. I only want the horizontal axis to return the name of everything that is more than 1. Is this possible?

Cheers

[Andy Pope]

Either filter the data and ensure Plot visible cells is disabled.

Or you will need to use formula to build a table of charting data that excludes data items not matching criteria. You then need to use dynamic named ranges to select only the required records from the new table.

[s786]

Either filter the data and ensure Plot visible cells is disabled.

Or you will need to use formula to build a table of charting data that excludes data items not matching criteria. You then need to use dynamic named ranges to select only the required records from the new table.

That second paragraph sounds more reasonable to my scenario (unfortunately I can't filter)

Any advice on how to do this?

[Andy Pope]

Use appraoch similar to this, which is for zeros in a pie chart.
http://www.andypope.info/charts/piezeros.htm