If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|