A dialog box will appear with options for the analysis. Click in the "Input Range" box in the dialog that appears. Click and drag on the spreadsheet to highlight the data you want to analyze.

With that, Excel can generate a series of random numbers based on the data entered and the standard deviation. With this data you can then create a curved chart, known as a bell curve.

Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.

Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

Now it’s time to use the procedure to prompt you to select a range. For our purposes, the range you select doesn’t matter. To display the InputBox, do the following: Click the Developers tab.