Hello

Is it possible using formula or vba to create a chart from a table that only shows headings that have values greater than zero. I tried Charts("Chart1").DisplayBlanksAs = xlNotPlotted but couldn't get it to work

Thanks in advance

James

Hi James

have a look at Andy Pope's side
http://andypope.info/charts/piezeros.htm

He uses formulas and defined names to create a pi chart without showing
zero values.
HTH
Frank

James L wrote:
Hello,

Is it possible using formula or vba to create a chart from a table
that only shows headings that have values greater than zero. I tried
Charts("Chart1").DisplayBlanksAs = xlNotPlotted but couldn't get it
to work.

Thanks in advance,

James