SimulationHistogram
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationHistogram(Reference Cell, Buckets, Labels)
Function arguments:
| Reference Cell | Cell to use as source |
| Buckets | number of buckets |
| Labels | Whether to show labels (default TRUE) |
This function creates a histogram table describing the data distribution of the reference cell.
This is a dynamic-array version of the histogram table function. In this version, you specify the number of buckets as an argument, and the function returns a table with that many rows.
This function makes it easier to dynamically adjust the table. It’s also more LLM-friendly.
After you create the table, you can use standard Excel charting tools to create a column chart.
Example
Change the number of buckets in cell E2 and the histogram table will adjust automatically.