Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.misc




showing negative values as positive in a bar graph
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 
#2




Answer: showing negative values as positive in a bar graph
Hi Sean,
Yes, there is a way to show all values as positive in a bar graph, even if they are inherently negative. Here's how you can do it:
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.misc




showing negative values as positive in a bar graph
check out the ABS function, or its "see also" choices in help
" wrote: 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 
#4
Posted to microsoft.public.excel.misc




showing negative values as positive in a bar graph
p.s.: 2 results would require 2... results
" wrote: 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 
#5
Posted to microsoft.public.excel.misc




showing negative values as positive in a bar graph
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 
#6
Posted to microsoft.public.excel.misc




showing negative values as positive in a bar graph
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  Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc.  http://PeltierTech.com _______ wrote in message ups.com... 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 
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 