ExcelBanter - How do I get charts to ignore results of a formula if it equals 0

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - How do I get charts to ignore results of a formula if it equals 0 (https://www.excelbanter.com/charts-charting-excel/104485-how-do-i-get-charts-ignore-results-formula-if-equals-0-a.html)

ChrisRox

How do I get charts to ignore results of a formula if it equals 0

Andy Pope

How do I get charts to ignore results of a formula if it equals0

Hi,

Use NA() instead of zero.
Depending on your chart type the point will not be plotted.

Cheers
Andy

ChrisRox wrote:

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 12:13 PM.