The Excel commands for the histogram

$\backslash$table$[[$Class Interval,F$,$X $($Mid$-$Point$)],[20-40,2,30],[40-60,4,50],[60-80,3,70],[80-100,1,90],[,10,]]$

The Excel commands for the histogram are:

a$.$ In cell A$2$ indicate that the column of data is the class interval and in B$2$ that it is the frequency. In cells $C3$ to $C6.$ Insert the midpoints of the Class interval. In B$2$ to B$6,$ record the class frequencies. When you have finished entering data in cell B$6,$ hit the Enter key.

b$.$ With your mouse, highlight cells B$3$ through B$6.$

c$.$ From the tabs$,$ select Insert. From the Charts, select Column, then $2-$D column and pick the first chart type. A graph will appear.

d$.$ When the graph area is active, a Chart Tools tab appears at the top of the screen. Select the Design tab, and then select Data. Under Horizontal $($Category$)$ Aris Labels. Click Bdit, then use the mouse to select cells C$3$ through C$6$ and click Ok twice. The horizontal axis now shows the class midpoints.

e$.$ With the Chart Tools displayed at the top, select the Design tab, Select Chart Layout. Select the layout.

f$.$ With Chart Tools displayed at the top, select the layout tab. Double$-$click on the Chart Title and type in an appropriate title. Next, under the same layout tab, select Axis Titles. Using Primary Vertical Aris Title, name the vertical axis Frequency and delete the words axis. Using the Primary Horizontal Aris Title, name it Mid$-$Point, Next select Legend and select None.

g$.$ Double$-$glick one of the columns in the graph. Then from the Tabs across the top select Layout. On the left$-$hand side of the tool bar, click the words Format Selection. A dialog box will appear. Under Series Option, change, the Gap Width to $0\%$ by moving the arrow all the way to the left, and then click the Close buttion at the bottom of the dialog box.

Please show examples on Excel of the steps! :)