| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart wizard for excel 2007 | Charts and Charting in Excel | |||
| Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
| Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
| Why is the chart wizard greyed out on some of my Excel spreadsheet | Charts and Charting in Excel | |||
| Chart Wizard in Excel not flexible enough | Charts and Charting in Excel | |||
Hybrid Mode
