Charting negative nos

[Chris Taylor]

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]

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]

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]

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

=-D50

and copy down and across