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

This page was: Helpful |
Not Helpful