Can i use a formula in the excel chart wizard?

[IhateWORK]

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

 

[Jon Peltier]

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

- Jon