View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Khai N[_2_] Khai N[_2_] is offline
external usenet poster
 
Posts: 3
Default Graphing: Stopping the downvard line

Hi,
when generating a line graph with a range of values in a colum and only some
values entered in the range (that is, the range include empty cells), the
line graph draws a steep down line to the zero value. How can this be
avoided, i.e. the graph stops before the empty colum and not continue to draw
the zero value on the category axis?