|
| 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
March 4th, 2010, 03:34 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
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
March 4th, 2010, 04:13 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 | |
|
|
Linear Mode
