Graphics zero

Bert · May 9th, 2002, 03:31 PM

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. · May 9th, 2002, 03:36 PM

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 · May 9th, 2002, 03:50 PM

Thanks a lot, works fine

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 03:31 PM	#1
Bert New Member Join Date: May 2002 Posts: 5	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

May 9th, 2002, 03:36 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]

May 9th, 2002, 03:50 PM	#3
Bert New Member Join Date: May 2002 Posts: 5	Thanks a lot, works fine