This makes a bar chart okay
But not such a good area chart
We can create a table that splits the positive and negative values
but the result is disappointing
The areas simply go to zero at the next value, which is not what we want. This happens even when the Excel Time-scale X axis type is selected by going to Chart..Chart Options..Axes and selecting "Time-scale". However, Time-scale has one feature that lets us easily fix the problem. Unlike the ordinary category axis, it does not present values in the same order as they appear in the table, but in strict time order. So if we make a new set of rows below our first set
where the formulae are (left to right, assuming the original table header started at cell A1)
then the two areas should meet the zero line at the same interpolated date!
Remember, this only works if you've selected the "Time-scale" option in Chart Options. If you're looking for more Excel help, see the Jon Peltier and Andy Pope links on the right.