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.

In this tutorial, we will explain how to make a Step Chart in Microsoft Excel with or without dates. Charts are a graphical representation of data.

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.

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.