negative values in chart

[cassiopea]

Hello!

In Excel 2002 I had a chart with a negative values, which I didn't want to be seen on the chart ie. only positive vaues should be seen on the chart. I set mimimum to zero, and it worked well. But when I got Excel 2007, the same chart shows negative values, although the mimimum is still set to zero. When I print the chart out, the thin line of the negative values can also bee seen on a chart and I don't want that. What do I have to do?

[Andy Pope]

Apply border with same colour as column to remove the negative overhang.

Or use formula to create chart specific data,

=IF(B2<0,NA(),B2)