Graphics zero

[Bert]

I have an OLAP tool running wich links to Excel. I have a graph connected to it in Excel. It's a graph that shos profit for all the months. But there is data till May in it, so in May the grap goes to zero. How can I avoide this.

PS : Even in monts with zero is a formula connecting to the OLAP (TM1) tool

 

[Mark W.]

Return #N/A (or a NULL value) instead of 0 for May and beyond.

If you're already returning a NULL value...

1. Select the chart
2. Choose the Tools | Options... menu command's Chart tab
3. Set the "Plot empty cells as:" radio button group as desired.
This message was edited by Mark W. on 2002-05-09 14:48

 

[Bert]

Thanks a lot, works fine