ExcelBanter - Chart

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Chart (https://www.excelbanter.com/excel-discussion-misc-queries/1161-chart.html)

Chart

Hi

I want to plot a chart but it not to show the values if the value of the
formula is zero even though they are ranged.

Is there anyway this can be done?

Cheers
Shona

Andy Pope

Hi Shona,

Try using the NA() formula instead of zero or ""

Cheers
Andy

SS wrote:
Hi

I want to plot a chart but it not to show the values if the value of the
formula is zero even though they are ranged.

Is there anyway this can be done?

Cheers
Shona

--

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

All times are GMT +1. The time now is 09:49 PM.