View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Hari
 
Posts: n/a
Default Skipping Zero values for plots

Hi,

How do I make a chart such that if I have some zero values then those
dont get plotted (especially in case of Line charts). Rather if I have
values

Oct 56
Nov 0
Dec 100

Then I would have only a straight line from Oct to Dec. I might have
such zero value pattern for many data points.

Is this possible to achieve without any complicated manipulation (I
think I have one in mind).

regards,
HP
India