View Single Post
  #1   Report Post  
marika1981
 
Posts: n/a
Default overcoming zero values in line graph

I have a 12-month line graph where some of the earliest and most recent data
is still zero.

Is there a way to have Excel not plot zero values - to avoid the big rises
and drop offs they cause - and, rather, just have the graph start and end
wherever there is positive data?

(NOTE: for multiple reasons, I can't erase the formulae in the cells
yielding the zero values, or have them display the N/A message....)

Thanks!!!

Marika :)