How to neglect zero's in chart?

[atulrajratna]

Hi team,


I have a chart based on a run rate table. the table shows percentage of current over. so there are some numbers as well as zero's.

Suppose the game is in 9th over & run rate is 15.71 but the series goes down as 10th & next all overs have number 0 in the table.

The series should be stopped on 9th over. Please check-

https://skydrive.live.com/redir.aspx?cid=92bd629a339d0180&resid=92BD629A339D0180!115&parid=92BD629A339D0180!103&authkey=!AJMUSoQ7_TXph8U


If the table has any zero, that should be neglected in the chart, How to do this?

Please help me.


Thanks,

Atul

 

[Faseeh]

Hi Atul,


A simple formula will do the trick:

=IFERROR(IF(ISBLANK(C3),NA(),100*C3/$C$23),"")

Because graph will not plot NA()...


here is the file:

http://dl.dropbox.com/u/60644346/cricket_resolved.xlsx


Do not bother about error message you can skip its printing by 'Page setup > Dispaly error > '<blank>' see print preview of my file...


Regards,

Faseeh