showing negative values as positive in a bar graph

[sbweld]

Hello,

I'm trying to create a bar graph of a data set. I have values that are
inherently negative (issued checks and withdrawls). It's important
that these numbers are negative because they contribute to a total at
the end. I need to create a bar graph of this data (including the
total) but the checks and withdrawls end up being negative on the bar
graph but I want them to show as positive values in the graph. I can
change the data to absolute values instead, but that makes my total
inaccurate.


Is there a way to show all values as positive in a bar graph?

Sean

 

[Guest]

check out the ABS function, or its "see also" choices in help

 

[Guest]

p.s.: 2 results would require 2... results

 

[sbweld]

Thanks for your help, I decided to go with the ABS function. When I
did the SUM for the total I just used a negative sign in the sum...
=sum(-L71,L72,-L73)


It seems like a bit of an unusual way... in my opinion. I can't
imagine my instructor did this the same way I did.

Thanks again
Sean

 

[Jon Peltier]

Remember, you're asking the chart and the calculation to treat these numbers
differently. I usually create a separate chart data range using a formula,
so I can format it or lay it out differently.

In your case it's easy. In the range of chart data, you need just ABS with
links to the original data, and do the calculations on the original data.
You don't need to display the calculated chart data if you don't want.

- Jon