CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL
 

i have a chart which is populated by formulas on a monthly basis but the line
graph reads blank cells which has formulas but not data in as a ZERO value
which makes the line graph drop to zero at which ever point the last monthly
figure goes in is there away of the series fuctiion that reads the range not
read the formula as a value but as a blank

CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL
 

You are limited as to how to handle empty cells in a chart. With the chart
selected, use Tools | Options and go to the [Chart] tab, you'll see 3 options
for handling empty cells:
Not Plotted (leave gaps)
Zero [what you've got now]
Interpolated

The last makes a best guess where the point would lay between the points on
either side of it. Not Plotted sounds like what you want to look at
initially.

The options on that tab are only available when you have a chart selected,
with no chart selected they are all grayed out.


"AJ-foster" wrote:

i have a chart which is populated by formulas on a monthly basis but the line
graph reads blank cells which has formulas but not data in as a ZERO value
which makes the line graph drop to zero at which ever point the last monthly
figure goes in is there away of the series fuctiion that reads the range not
read the formula as a value but as a blank

CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL
 

The way i do it is
=IF(C64=0,"",SUM(X64*1000)/C64)
Works for me

"AJ-foster" wrote:

i have a chart which is populated by formulas on a monthly basis but the line
graph reads blank cells which has formulas but not data in as a ZERO value
which makes the line graph drop to zero at which ever point the last monthly
figure goes in is there away of the series fuctiion that reads the range not
read the formula as a value but as a blank