Chart Questions

[Guest]

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

 

[Frank Kabel]

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