Excel chart with positive and negative values

[cath_murray]

I want to chart movements within a bank account. So want to show
positive values with negatives offsetting to get to a bank balance. I
want to do this with either bars or areas rather than lines. For
example in one month I want to show £1000 income with £700 expenditure
giving net £300 with the £1000 positive and the £700 negative. Do you
think thats possible?

 

[Guest]

You could try the chart type Stacked Bars or Stacked Area. You could choose
to put the +300 and -700 in your data sheet so only the 300 shows over the
zero line. Or, you could plot both as + numbers and make 700 red and 300
black, for example. Which one is best would likely depend upon whether any
of your data has you going net negative.