Not plotting zero values

  • Thread starter Thread starter Charles Delamain
  • Start date Start date
C

Charles Delamain

I have created a chart with the date as the x axis,
running to the end of the year. Each week, as new
statistics arrive, I put them into the appropriate cells.
The graph plots a subsequent cell that applies a formula
to the inserted data. So that others can use this with
minimum fuss, I have copied the formula through to the end
of the year, and applied an "if" statement so that if the
data entry cells are blank, then the formula returns a
blank. Nevertheless, the chart applies a zero value to the
blank results, meaning the line graph drops to the x axis
until the end of the year. How can I tell the graph to
only plot the result if the formula provides a value,
rather than a blank?
Please help!
 
Charles said:
I have created a chart with the date as the x axis,
running to the end of the year. Each week, as new
statistics arrive, I put them into the appropriate cells.
The graph plots a subsequent cell that applies a formula
to the inserted data. So that others can use this with
minimum fuss, I have copied the formula through to the end
of the year, and applied an "if" statement so that if the
data entry cells are blank, then the formula returns a
blank. Nevertheless, the chart applies a zero value to the
blank results, meaning the line graph drops to the x axis
until the end of the year. How can I tell the graph to
only plot the result if the formula provides a value,
rather than a blank?
Please help!
Click to expand...

Two options:

1. Tools | Options | Chart tab | Plot empty cells as... not plotted.

2. Change your formula to return #NA (use NA() function) instead of a blank
cell.

Dave
dvt at psu dot edu
 
Back
Top