151 votesAccepting Votes · 21 comments · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →
1,234 votes130 comments · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
Thank you for taking the time to share your request for linking min/max values of a chart axis to the cell value! We think this suggestion has merit; however, we don’t expect to devote time to it in the near future. We will continue tracking votes and comments here, and will keep this suggestion under consideration for future development.
Thank you again, and please keep sharing your thoughts!
14 votes5 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for logging this, Lyubomir. How do you do these today? Is deeper integration with R potentially useful for such scenarios, at least for the analysis?
An error occurred while saving the commentLyubomir Georgiev commented
Hi Ashvini. Thank you for your comment.
Currently, to do this type of probabilistic analysis, I use a combination of build in Excel functions (ex. BINOM.INV, NORM. INV, etc.) and VBA. I use VBA to:
- create inverse cumulative distribution functions not supported in Excel;
- sample/simulate all inverse cumulative distribution functions by continuously recalculating my spreadsheet and storing outputs for each iteration;
- run sensitivity analysis on the results;
There are quite a few third party Excel add-ins which facilitate the above-mentioned tasks. The issue with all of them (a part from being quite expensive) is that once a model is built using some external functionalities, you can no longer use it on computers where the third party add-in is not installed. This severely limits the ability to collaborate on the content and consume the output of the probabilistic analysis. That’s why I believe that having natively supported Excel tools is the optimal solution.Lyubomir Georgiev shared this idea ·
56 votes9 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →