View Single Post
  #1   Report Post  
Kris B
 
Posts: n/a
Default ignoring null values in graph

I've built a data sheet to represent monthly result data that is appended to
each month. In the out-months a formula exists to prevent a DIV/0 error in
the data sheet. Problem is, the out months graph with a zero value. How do
I fix without having to update the chart range or formulas that calc the
percentages each month?