| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Minimum and maximum value of Axis set by user by reference to form
Excel seems to have 2 alternatives for defining the min/ max value of an
axis: either automatically or preset by the user. But is there any way that the minimum and maximum value that the axis is defined by the user based on the values of the spreadsheet (i.e., halfway between the above two apparent options provided by microsoft)? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Minimum and maximum value of Axis set by user by reference to form
Yes, you can tie axis values to worksheet cells via a macro. The process is
described via the link below . . . http://peltiertech.com/Excel/Charts/...nkToSheet.html -- John Mansfield http://cellmatrix.net "jonny" wrote: Excel seems to have 2 alternatives for defining the min/ max value of an axis: either automatically or preset by the user. But is there any way that the minimum and maximum value that the axis is defined by the user based on the values of the spreadsheet (i.e., halfway between the above two apparent options provided by microsoft)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| maximum/minimum value in formula | Excel Discussion (Misc queries) | |||
| Spinners - minimum and maximum | Excel Discussion (Misc queries) | |||
| How do I find the cell reference that contains the minimum or maximum | Excel Worksheet Functions | |||
| Maximum & Minimum values in a coulmn | Excel Discussion (Misc queries) | |||
| Maximum and minimum cell value | Excel Discussion (Misc queries) | |||
Hybrid Mode
