Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel chart with positive and negative values
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel chart with positive and negative values
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. " wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing positive values to negative | New Users to Excel | |||
how to turn positive to negative values in excel | Excel Worksheet Functions | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions | |||
switching values from positive to negative | Excel Worksheet Functions |