Palisade Knowledge Base

HomeTroubleshooting@RISK for Excel: Other IssuesChart in Excel Graphs Only 200 Data Points

8.29. 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