Can i use a formula in the excel chart wizard?
 

I am creating a coursework in which i have to analyse a lot of data in the
spreadsheet. it is already cluttered with columns and i dont want to add
extra columns to add to the clutter. i was wondering whether there is a way
to plot absolute values of a column without changing the actual values in the
column or creating a new column using ABS() function.

Thanx

Can i use a formula in the excel chart wizard?
 

You can't use formulas in the reference boxes in the chart wizard. You
can only use range references or defined names.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/3/2010 10:34 PM, IhateWORK wrote:
I am creating a coursework in which i have to analyse a lot of data in the
spreadsheet. it is already cluttered with columns and i dont want to add
extra columns to add to the clutter. i was wondering whether there is a way
to plot absolute values of a column without changing the actual values in the
column or creating a new column using ABS() function.

Thanx