LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing positive values to negative jay New Users to Excel 2 July 7th 07 01:34 AM
how to turn positive to negative values in excel Paula1 Excel Worksheet Functions 4 February 23rd 06 10:54 PM
Formula to make Negative Values Positive & Positive Values Negative? mustard Excel Discussion (Misc queries) 4 September 26th 05 10:05 PM
... Count, <<< Positive Values minus Negative Values >>> ... Dr. Darrell Excel Worksheet Functions 4 September 8th 05 01:36 PM
switching values from positive to negative lob Excel Worksheet Functions 5 February 18th 05 11:11 PM


All times are GMT +1. The time now is 03:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"