View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
John Mansfield John Mansfield is offline
external usenet poster
 
Posts: 235
Default Chart suppression of zero's

Another option would be to make your chart dynamic:

http://www.cellmatrix.net/index.php/...de_zero_values

--
John Mansfield
http://cellmatrix.net





"ncalpaperboy" wrote:

HI, for a chart series of historical data that is not yet populated, I want
to suppress the chart plotting of zero's. The option of plot empty cells as
'not plottted' does not work. Thank you.