Home → Troubleshooting → @RISK for Excel: Other Issues → Chart in Excel Graphs Only 200 Data Points
Applies to:
@RISK for Excel 3.5 and newer
@RISK for Project 3.5 and newer
There are thousands of data points in my @RISK input or output distribution, but when I use the Chart in Excel command (Graph in Excel for @RISK 3.x/4.x), only 200 points (or even fewer) are listed in Excel, and it appears that only these points have been graphed.
Keep in mind that to graph a distribution of data, it must first be binned. The points that you see in Excel are the positions and heights of the histogram bars, not the actual data points. @RISK decides how many bars to use, based on the number of data points (number of iterations), but the number of bins is never more than 200.
Last edited: 2012-01-18