I have a spreadsheet that picks up monthly data from another spreadsheet
and displays the data in a table and a chart. It obviously has formulas
in for each month of the year and months April-Dec are returning the
value of '0', since the data has yet to be input into the other
spreadsheet for these months.
The problem is that my line graph looks like it plummets to 0 in April,
whereas in fact I would just like the line to stop at March - how do I
do this?
I have tried putting in an IF<0 formula, but "" still plots as 0!
The Charts tab on Options has the check box of 'plot empty cells as not
plotted' checked and I have also tried hiding zero values in the
spreadsheet, but neither of these work. Please help!


--
ajames
------------------------------------------------------------------------
ajames's Profile: http://www.excelforum.com/member.php...o&userid=31502
View this thread: http://www.excelforum.com/showthread...hreadid=532328