Can i use a formula in the excel chart wizard?

  • Thread starter Thread starter IhateWORK
  • Start date Start date
I

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
 
You can't use formulas in the reference boxes in the chart wizard. You
can only use range references or defined names.

- Jon
 
Back
Top