Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am a Process Engineer in a semiconductor manufacturing facility. I have 2
suggestions 1. I use extensivelly a range calculation which is simply the maximum value minus the minimum of a population. It would be very useful to have a function (called range) to have it done at once instead of having to type max()-min(). 2. For populations comparisons we use box plots. It would be nice to have a chart type for box plots. Thanks, Sebastian Fishman ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If your range is named, say "population", then you can use that name in you
formula. =MAX(population)-MIN(population). If the numbers in the range fluctuate in length down the page (e.g. sometimes you have 400 numbers and other times you have 500) then make the "population" range extend to line 600. This way you never have to adjust the range; just put in your new numbers and the calculation is made. "sebafishman" wrote: I am a Process Engineer in a semiconductor manufacturing facility. I have 2 suggestions 1. I use extensivelly a range calculation which is simply the maximum value minus the minimum of a population. It would be very useful to have a function (called range) to have it done at once instead of having to type max()-min(). 2. For populations comparisons we use box plots. It would be nice to have a chart type for box plots. Thanks, Sebastian Fishman ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Missing x-axis labels on chart in XL97 | Charts and Charting in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Fan charts | Charts and Charting in Excel | |||
Formula to list unique values | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |