Revenue charting

  • Thread starter Thread starter MRomanow
  • Start date Start date
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!!
 
Hi
not sure this will help you but you may change the formulas to
IF(ISERROR('Monthly DetailSummary'!D12+B8),B8,'Monthly
DetailSummary'!D12+B8)

But there could be a good reason why your formula currently returns
#NA?
 
MRomanow
The #N/A is usually used to prevent the item from being charted. If the cell is left blank then you will get a broken line. If the cell contains a "" it will be treated as a zero. However, when the cell contains a #N/A error the data set will be completely ignored

I usually enter this into my formulas as NA(), but the #N/A seems to work also

So if the formula is returning #N/A, then the data set should not be charted, but are you still getting zero values in your chart

In regard to the days with no revenue problem, What is being enter in 'Monthly Detail Summary'!D12 and B8 when you don't have any revenue? These are the cells which are causing the #N/A error

Good Luck
Mark Graesse
(e-mail address removed)
Our Fair City - Boston M

----- Frank Kabel wrote: ----

H
not sure this will help you but you may change the formulas t
IF(ISERROR('Monthly DetailSummary'!D12+B8),B8,'Monthl
DetailSummary'!D12+B8

But there could be a good reason why your formula currently return
#NA



-
Regard
Frank Kabe
Frankfurt, German
 
Back
Top