Charting negative nos

Chris Taylor · Mar 12th, 2002, 05:13 AM

I have a list of negative numbers that I need to plot as positives. Is it possible to change the sign in the chart?

Dave Hawley · Mar 12th, 2002, 05:18 AM

Not too sure I understand??? Why not reference the cell values that is your charts underlying data like:

=-A6

This will convert it to a posotive. The only other alternative would be to drag the actual data point up to the positive value, but this will also change it's real cell value.

Chris Taylor · Mar 12th, 2002, 05:34 AM

The range I am picking up is as follows

=Results!$D$150:$W$150

It will not let me put a - in

thanks

Dave Hawley · Mar 12th, 2002, 05:41 AM

No, I mean create a duplicate set of values which are positive eg;

=-D50

and copy down and across

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 05:13 AM	#1
Chris Taylor New Member Join Date: Mar 2002 Posts: 2	I have a list of negative numbers that I need to plot as positives. Is it possible to change the sign in the chart?

Mar 12th, 2002, 05:18 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Not too sure I understand??? Why not reference the cell values that is your charts underlying data like: =-A6 This will convert it to a posotive. The only other alternative would be to drag the actual data point up to the positive value, but this will also change it's real cell value.

Mar 12th, 2002, 05:34 AM	#3
Chris Taylor New Member Join Date: Mar 2002 Posts: 2	The range I am picking up is as follows =Results!$D$150:$W$150 It will not let me put a - in thanks

Mar 12th, 2002, 05:41 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	No, I mean create a duplicate set of values which are positive eg; =-D50 and copy down and across