Since releasing Version 4 of the Statistical PERT® Normal Edition this past January, I’ve had a few people contact me saying that they couldn’t use the new Monte Carlo simulation tab that I’ve included in that release.
After doing some investigation, I now think I know what the problem is. The Monte Carlo simulation worksheet in V4 uses Excel’s “Histogram chart” to visually depict the 10,000 trials of the simulation. However, Microsoft only introduced the histogram chart in Excel 2016. Excel 2010 and Excel 2013 don’t have this chart, so users of these older versions of Excel see an error message where the histogram is supposed to be.
If you’re using either Excel 2010 or Excel 2013, you can manually create the histogram chart yourself by Googling “histogram chart Excel 2013” and you’ll see results that explain a manual process for creating a histogram chart. Here are some of the result links I found:
- Histogram in Excel: Easy Steps 2016, 2013, 2010-2007
- Create a histogram in Excel (2013), by Microsoft
- Create a histogram (also by Microsoft, from their Office site)
Of course, you can always save yourself the trouble of manually creating a histogram chart by upgrading to the latest release of Excel.