M
MRomanow
I am trying to chart revenue trends over a monthly period. However,
want the series line in the chart to stop at the last day revenue i
shown: I want it to disappear from the chart entirely (not drop t
zero). I am running into a problem with the following data:
MON
2-Feb-04 ='Monthly Detail Summary'!C12
TUE
3-Feb-04 =IF(ISERROR('Monthly Detai
Summary'!D12+B8),#N/A,IF('Monthly Detai
Summary'!D12+B8=B8,#N/A,'Monthly Detail Summary'!D12+B8))
WED
4-Feb-04 =IF(ISERROR('Monthly Detai
Summary'!E12+C8),#N/A,IF('Monthly Detai
Summary'!E12+C8=C8,#N/A,'Monthly Detail Summary'!E12+C8))
If there is revenue for all of these days, the formula works just fine
However, if there is no revenue for any of the days, it puts #N/A fo
all of the remaining cells (which is counterproductive to what I want)
Current Results
MON Initial Rev: =$29,648
TUE Additional Rev: $2,000 +$29,648 =$31,648
WED No Revenue today: =#N/A (should b
$31,648)
THU Additional Rev: $2,000 + $31,648 =#N/A (should be #33,648)
Any help would be great!!
want the series line in the chart to stop at the last day revenue i
shown: I want it to disappear from the chart entirely (not drop t
zero). I am running into a problem with the following data:
MON
2-Feb-04 ='Monthly Detail Summary'!C12
TUE
3-Feb-04 =IF(ISERROR('Monthly Detai
Summary'!D12+B8),#N/A,IF('Monthly Detai
Summary'!D12+B8=B8,#N/A,'Monthly Detail Summary'!D12+B8))
WED
4-Feb-04 =IF(ISERROR('Monthly Detai
Summary'!E12+C8),#N/A,IF('Monthly Detai
Summary'!E12+C8=C8,#N/A,'Monthly Detail Summary'!E12+C8))
If there is revenue for all of these days, the formula works just fine
However, if there is no revenue for any of the days, it puts #N/A fo
all of the remaining cells (which is counterproductive to what I want)
Current Results
MON Initial Rev: =$29,648
TUE Additional Rev: $2,000 +$29,648 =$31,648
WED No Revenue today: =#N/A (should b
$31,648)
THU Additional Rev: $2,000 + $31,648 =#N/A (should be #33,648)
Any help would be great!!