View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ccdae ccdae is offline
external usenet poster
 
Posts: 2
Default How do I ensure that in a chart zero(0) values are not shown ?

I have a series of cells in which a value is calcualted every month and a
Graph which displayes the result. For future months the Graph shows a line
from the last value to '0'. How can I ensure that this is not shown withouth
copying the formula each time at the end of the month ?